RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA724011", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

  • Orthornavirae · 13 ✖

bioproject 1

  • PRJNA724011 · 13 ✖

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
3261700 3261700 PRJNA724011_P_NODE_108483_length_242_cov_0.911243_g107460_i0 PRJNA724011 108483 242 0.911243 2.20520806 Zhejiang mamastrovirus 4 2920441 Viruses Viruses 58.4 4.69e-4   NTclustered gi|2203408083|gb|MW784070.1| 2920441 g107460 i0 100 0.384297520661157 31 0 13 0 161 191 6320 6290 MAG: Zhejiang mamastrovirus 4 isolate 7-333329, complete genome blastn 93 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae Mamastrovirus Zhejiang mamastrovirus 4
23664030 23664030 PRJNA724011_P_NODE_95339_length_250_cov_0.870056_g94316_i0 PRJNA724011 95339 250 0.870056 2.17514 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 141 4.7e-29   NTclustered gi|1698236883|gb|MN034603.1| 3003959 g94316 i0 83.784 9.42 148 24 59 0 3 150 10520 10667 MAG: Picornavirales sp. isolate H1_Bulk_Litter_5_scaffold_57 RNA-dependent RNA polymerase (H1BulkLitter557_000001) gene, complete cds; and hypothetical protein (H1BulkLitter557_000002) gene, partial cds blastn 2355 141 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26767329 26767329 PRJNA724011_P_NODE_72501_length_294_cov_1.520362_g71478_i0 PRJNA724011 72501 294 1.520362 4.46986428 Picornavirales-like virus 2 3137794 Viruses Viruses 43.5 0.0391   NR BFJ38645.1 3137794 g71478 i0 32.2 0.918367346938776 90 55 86.7 3 22 276 2336 2424 BFJ38645.1 MAG: polyprotein [Picornavirales-like virus 2] diamond 270 43.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales-like virus 2
27841677 27841677 PRJNA724011_P_NODE_22764_length_602_cov_3.043478_g21750_i0 PRJNA724011 22764 602 3.043478 18.32173756 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 125 2.78e-29   NR XCM67837.1 3003959 g21750 i0 75.3 0.363787375415282 73 18 36.4 0 601 383 1688 1760 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 219 125 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28031395 28031395 PRJNA724011_P_NODE_61265_length_325_cov_1.527778_g60242_i0 PRJNA724011 61265 325 1.527778 4.9652785 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 74.3 8.41e-13   NR XCM67837.1 3003959 g60242 i0 52 0.923076923076923 100 34 92.3 4 16 315 7 92 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 300 74.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28378604 28378604 PRJNA724011_P_NODE_75506_length_287_cov_1.584112_g74483_i0 PRJNA724011 75506 287 1.584112 4.54640144 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 148 6.03e-39   NR XCM67837.1 3003959 g74483 i0 74.7 0.993031358885017 95 24 99.3 0 287 3 81 175 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 285 148 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28410242 28410242 PRJNA724011_P_NODE_40826_length_416_cov_1.116618_g39803_i0 PRJNA724011 40826 416 1.116618 4.64513088 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 173 4.41e-47   NR XCM67837.1 3003959 g39803 i0 62.5 0.980769230769231 136 51 98.1 0 3 410 861 996 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 408 173 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28915016 28915016 PRJNA724011_P_NODE_108648_length_242_cov_0.911243_g107625_i0 PRJNA724011 108648 242 0.911243 2.20520806 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 147 8.13e-39   NR XCM67837.1 3003959 g107625 i0 90 0.991735537190083 80 8 99.2 0 2 241 458 537 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 240 147 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29199775 29199775 PRJNA724011_P_NODE_82009_length_273_cov_1.535000_g80986_i0 PRJNA724011 82009 273 1.535 4.19055 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 168 3.4799999999999997e-46   NR XCM67837.1 3003959 g80986 i0 89.9 0.978021978021978 89 9 97.8 0 5 271 557 645 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 267 168 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30178508 30178508 PRJNA724011_P_NODE_992_length_2556_cov_3.430930_g831_i0 PRJNA724011 992 2556 3.43093 87.6945708 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1122 0   NR XCM67838.1 3003959 g831 i0 69.7 0.906103286384977 772 230 90.4 2 2556 247 252 1021 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2316 1122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30305359 30305359 PRJNA724011_P_NODE_40772_length_416_cov_1.790087_g39749_i0 PRJNA724011 40772 416 1.790087 7.44676192 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 199 4.199999999999999e-56   NR XCM67837.1 3003959 g39749 i0 82.5 0.865384615384615 120 21 86.5 0 362 3 302 421 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 360 199 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30494540 30494540 PRJNA724011_P_NODE_111453_length_232_cov_2.729560_g110430_i0 PRJNA724011 111453 232 2.72956 6.3325792 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 115 1.14e-27   NR XCM67837.1 3003959 g110430 i0 72.7 0.995689655172414 77 21 99.6 0 231 1 1312 1388 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 231 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32455149 32455149 PRJNA724011_P_NODE_21559_length_624_cov_2.589837_g20547_i0 PRJNA724011 21559 624 2.589837 16.16058288 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 373 7.299999999999998e-116   NR XCM67837.1 3003959 g20547 i0 84.1 1 208 33 100 0 624 1 1465 1672 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 624 373 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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);;