RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA396510" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA396510 · 14 ✖

analysis 1

  • blastn · 14 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
411890 411890 PRJNA396510_P_NODE_1701_length_407_cov_5.952514_g1632_i0 PRJNA396510 1701 407 5.952514 24.22673198 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 579 1.45e-160   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1632 i0 94.865 0.909090909090909 370 19 91 0 1 370 2179 2548 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 370 579 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1686756 1686756 PRJNA396510_P_NODE_7402_length_217_cov_2.125000_g7333_i0 PRJNA396510 7402 217 2.125 4.61125 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 285 1.74e-72   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7333 i0 90.323 1 217 21 100 0 1 217 4442 4226 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 217 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
4238968 4238968 PRJNA396510_P_NODE_204_length_1003_cov_3.525157_g151_i1 PRJNA396510 204 1003 3.525157 35.35732471 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 575 4.879999999999998e-159   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g151 i1 97.619 0.511465603190429 336 7 51 1 358 693 1105 771 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 513 575 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
5515629 5515629 PRJNA396510_P_NODE_225_length_968_cov_3.130577_g151_i2 PRJNA396510 225 968 3.130577 30.30398536 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 431 1.08e-115   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g151 i2 89.881 0.495867768595041 336 33 50 1 358 693 1105 771 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 480 431 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
5515636 5515636 PRJNA396510_P_NODE_645_length_618_cov_4.182777_g584_i0 PRJNA396510 645 618 4.182777 25.84956186 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 778 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g584 i0 97.788 0.731391585760518 452 9 73 1 167 618 4 454 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 452 778 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
6789678 6789678 PRJNA396510_P_NODE_186_length_1041_cov_4.114919_g151_i0 PRJNA396510 186 1041 4.114919 42.83630679 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 444 1.4899999999999994e-119   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g151 i0 96.629 0.359269932756964 267 9 36 0 377 643 1442 1708 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 374 444 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9340068 9340068 PRJNA396510_P_NODE_1728_length_404_cov_1.760563_g1659_i0 PRJNA396510 1728 404 1.760563 7.11267452 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 213 1.68e-50   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1659 i0 94.245 0.344059405940594 139 8 34 0 266 404 3703 3841 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 139 213 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11890750 11890750 PRJNA396510_P_NODE_7250_length_219_cov_2.870588_g7181_i0 PRJNA396510 7250 219 2.870588 6.28658772 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 381 2.1799999999999996e-101   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7181 i0 98.605 0.981735159817352 215 3 98 0 5 219 4704 4490 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 215 381 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16989364 16989364 PRJNA396510_P_NODE_1654_length_413_cov_1.958791_g1585_i0 PRJNA396510 1654 413 1.958791 8.08980683 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 374 7.46e-99   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1585 i0 90.747 0.680387409200969 281 24 68 2 1 280 5608 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 281 374 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16989365 16989365 PRJNA396510_P_NODE_34_length_1694_cov_2.693617_g30_i0 PRJNA396510 34 1694 2.693617 45.62987198 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 752 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g30 i0 97.291 0.40495867768595 443 12 40 0 960 1402 3703 4145 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 686 752 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
20813545 20813545 PRJNA396510_P_NODE_4357_length_272_cov_1.919283_g4288_i0 PRJNA396510 4357 272 1.919283 5.22044976 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 348 2.8400000000000003e-91   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g4288 i0 89.744 1.00367647058824 273 26 100 2 1 272 5833 6104 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 273 348 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
22088420 22088420 PRJNA396510_P_NODE_1278_length_460_cov_2.880779_g1209_i0 PRJNA396510 1278 460 2.880779 13.2515834 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 638 2.6899999999999994e-178   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1209 i0 91.522 1 460 39 100 0 1 460 6960 6501 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 460 638 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
22088430 22088430 PRJNA396510_P_NODE_18_length_2154_cov_4.161520_g14_i0 PRJNA396510 18 2154 4.16152 89.6391408 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2728 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g14 i0 95.591 0.919684308263695 1701 73 92 2 1 1700 7028 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1981 2728 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24638313 24638313 PRJNA396510_P_NODE_760_length_580_cov_3.719397_g151_i3 PRJNA396510 760 580 3.719397 21.5725026 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 294 8.62e-75   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g151 i3 92.647 0.351724137931034 204 15 35 0 377 580 1442 1645 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 204 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;