RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA724011" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 15 ✖

bioproject 1

  • PRJNA724011 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
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
28536662 28536662 PRJNA724011_P_NODE_109647_length_241_cov_0.916667_g108624_i0 PRJNA724011 109647 241 0.916667 2.20916747 Foveavirus mali 35350 Viruses Viruses 154 3.04e-41   NR AID68943.1 35350 g108624 i0 86.3 0.995850622406639 80 11 99.6 0 1 240 548 627 AID68943.1 RNA-dependent RNA polymerase [Foveavirus mali] diamond 240 154 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Foveavirus mali
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
29799322 29799322 PRJNA724011_P_NODE_40891_length_415_cov_2.695906_g39868_i0 PRJNA724011 40891 415 2.695906 11.1880099 Crogonang virus 12 3062925 Viruses Viruses 52 1.44e-4   NR WPR18034.1 3062925 g39868 i0 29.6 0.903614457831325 125 78 86 3 50 406 614 734 WPR18034.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 12] diamond 375 52 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Crogonang virus 12
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
30905410 30905410 PRJNA724011_P_NODE_97774_length_248_cov_1.851429_g96751_i0 PRJNA724011 97774 248 1.851429 4.59154392 Crogonang virus 12 3062925 Viruses Viruses 54.7 2.46e-6   NR WPR18034.1 3062925 g96751 i0 41.8 0.955645161290323 79 35 89.5 2 5 226 624 696 WPR18034.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 12] diamond 237 54.7 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Crogonang virus 12
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
32518483 32518483 PRJNA724011_P_NODE_29259_length_513_cov_3.493182_g28241_i0 PRJNA724011 29259 513 3.493182 17.92002366 African cichlid piscichuvirus 3065075 Viruses Viruses 111 6.82e-25   NR WLN26256.1 3065075 g28241 i0 48.3 0.690058479532164 118 59 67.8 1 500 153 117 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 354 111 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus

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