RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA683669" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA683669 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
28345410 28345410 PRJNA683669_P_NODE_18966_length_296_cov_2.331839_g18734_i0 PRJNA683669 18966 296 2.331839 6.90224344 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 168 6.65e-46   NR XCM67837.1 3003959 g18734 i0 73.5 0.993243243243243 98 26 99.3 0 3 296 1423 1520 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 294 168 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28345417 28345417 PRJNA683669_P_NODE_23586_length_266_cov_1.637306_g23354_i0 PRJNA683669 23586 266 1.637306 4.35523396 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 95.9 1.03e-20   NR XCM67837.1 3003959 g23354 i0 49.4 0.981203007518797 87 44 98.1 0 261 1 1305 1391 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 261 95.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28408642 28408642 PRJNA683669_P_NODE_26026_length_251_cov_0.865169_g25794_i0 PRJNA683669 26026 251 0.865169 2.17157419 Atrato Picorna-like virus 2689353 Viruses Viruses 82.8 3.36e-16   NR QHA33691.1 2689353 g25794 i0 48.1 2.92828685258964 79 41 94.4 0 13 249 2468 2546 QHA33691.1 polyprotein, partial [Atrato Picorna-like virus] diamond 735 82.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Atrato Picorna-like virus
30366946 30366946 PRJNA683669_P_NODE_52_length_3275_cov_5.090256_g43_i0 PRJNA683669 52 3275 5.090256 166.705884 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 607 9.069999999999999e-197   NR XCM67838.1 3003959 g43 i0 34.9 0.924274809160305 1009 567 87.2 18 297 3152 46 1021 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 3027 607 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30808896 30808896 PRJNA683669_P_NODE_4974_length_579_cov_2.784585_g4747_i0 PRJNA683669 4974 579 2.784585 16.12274715 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 275 1.1199999999999999e-81   NR XCM67837.1 3003959 g4747 i0 65.6 0.994818652849741 192 66 99.5 0 2 577 1521 1712 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 576 275 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31187691 31187691 PRJNA683669_P_NODE_335_length_1885_cov_2.080022_g281_i0 PRJNA683669 335 1885 2.080022 39.2084147 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 628 9.83e-204   NR XCM67837.1 3003959 g281 i0 55.7 0.905570291777188 569 244 90.1 4 1758 61 310 873 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 1707 628 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31219277 31219277 PRJNA683669_P_NODE_7175_length_477_cov_1.898515_g6944_i0 PRJNA683669 7175 477 1.898515 9.05591655 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 142 1.09e-35   NR XCM67837.1 3003959 g6944 i0 42.2 1.0125786163522 161 90 100 2 477 1 1035 1194 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 483 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31504456 31504456 PRJNA683669_P_NODE_2996_length_758_cov_1.572263_g2791_i0 PRJNA683669 2996 758 1.572263 11.91775354 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 137 1.0699999999999999e-32   NR XCM67837.1 3003959 g2791 i0 54.5 0.530343007915567 134 57 52.2 3 756 361 129 260 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 402 137 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);;