RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA454503 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
26696184 26696184 PRJNA454503_P_NODE_47361_length_218_cov_1.656051_g47032_i0 PRJNA454503 47361 218 1.656051 3.61019118 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 118 7.680000000000001e-29   NR XCM67837.1 3003959 g47032 i0 79.2 0.990825688073395 72 15 99.1 0 1 216 90 161 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 216 118 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27044553 27044553 PRJNA454503_P_NODE_2_length_9601_cov_20.024738_g1_i0 PRJNA454503 2 9601 20.024738 1922.57509538 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 2280 0   NR UNY41988.1 3003959 g1 i0 42.9 0.986772211227997 3158 1431 94.2 53 9434 393 1 2938 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 9474 2280 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27076134 27076134 PRJNA454503_P_NODE_14622_length_301_cov_2.166667_g14293_i0 PRJNA454503 14622 301 2.166667 6.52166767 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 178 2.26e-49   NR XCM67837.1 3003959 g14293 i0 82 0.996677740863787 100 18 99.7 0 1 300 1613 1712 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 300 178 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27234190 27234190 PRJNA454503_P_NODE_24343_length_252_cov_1.020942_g24014_i0 PRJNA454503 24343 252 1.020942 2.57277384 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 71.2 3.84e-12   NR XCM67837.1 3003959 g24014 i0 49.4 0.988095238095238 83 24 98.8 1 250 2 275 339 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 249 71.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27392353 27392353 PRJNA454503_P_NODE_15443_length_295_cov_1.303419_g15114_i0 PRJNA454503 15443 295 1.303419 3.84508605 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 171 5.55e-47   NR XCM67837.1 3003959 g15114 i0 79.6 0.996610169491525 98 20 99.7 0 2 295 1392 1489 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 294 171 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28592125 28592125 PRJNA454503_P_NODE_35847_length_232_cov_1.263158_g35518_i0 PRJNA454503 35847 232 1.263158 2.93052656 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 114 2.9100000000000003e-27   NR XCM67837.1 3003959 g35518 i0 70.3 0.956896551724138 74 22 95.7 0 2 223 802 875 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 222 114 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29760098 29760098 PRJNA454503_P_NODE_34271_length_234_cov_1.248555_g33942_i0 PRJNA454503 34271 234 1.248555 2.9216187 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 150 5.96e-40   NR XCM67837.1 3003959 g33942 i0 87 0.987179487179487 77 10 98.7 0 232 2 1480 1556 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 231 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30044456 30044456 PRJNA454503_P_NODE_87111_length_200_cov_2.330935_g86782_i0 PRJNA454503 87111 200 2.330935 4.66187 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 119 2.33e-29   NR XCM67837.1 3003959 g86782 i0 90.9 0.99 66 6 99 0 199 2 481 546 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 198 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31308387 31308387 PRJNA454503_P_NODE_47695_length_218_cov_1.636943_g47366_i0 PRJNA454503 47695 218 1.636943 3.56853574 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 104 5.619999999999999e-24   NR XCM67837.1 3003959 g47366 i0 73.6 0.990825688073395 72 19 99.1 0 218 3 1325 1396 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 216 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32035999 32035999 PRJNA454503_P_NODE_98_length_2797_cov_2.933480_g51_i0 PRJNA454503 98 2797 2.93348 82.0494356 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1179 0   NR XCM67838.1 3003959 g51 i0 65.8 0.946013585984984 882 277 92.1 4 2 2578 142 1021 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2646 1179 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32321111 32321111 PRJNA454503_P_NODE_4919_length_522_cov_2.509761_g4594_i0 PRJNA454503 4919 522 2.509761 13.10095242 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 129 4.89e-31   NR XCM67838.1 3003959 g4594 i0 67 0.540229885057471 94 31 54 0 241 522 45 138 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 282 129 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);;