RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1008624 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27414009 27414009 PRJNA1008624_P_NODE_18083_length_200_cov_2.410596_g17895_i0 PRJNA1008624 18083 200 2.410596 4.821192 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 92.4 6.76e-20   NR XCM67741.1 3003959 g17895 i0 73 1.92 63 17 94.5 0 5 193 1934 1996 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 384 92.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27666538 27666538 PRJNA1008624_P_NODE_2724_length_523_cov_2.438819_g2544_i0 PRJNA1008624 2724 523 2.438819 12.75502337 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 58.5 2.19e-6   NR XCM67741.1 3003959 g2544 i0 27 0.69980879541109 122 84 68.8 2 59 418 1060 1178 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 366 58.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28266045 28266045 PRJNA1008624_P_NODE_3866_length_436_cov_2.258398_g3680_i0 PRJNA1008624 3866 436 2.258398 9.84661528 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 138 1.02e-34   NR UNY41988.1 3003959 g3680 i0 44.8 0.98394495412844 143 79 98.4 0 431 3 1173 1315 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 429 138 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29560621 29560621 PRJNA1008624_P_NODE_23930_length_178_cov_2.689922_g23742_i0 PRJNA1008624 23930 178 2.689922 4.78806116 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 60.8 6.47e-9   NR XCM68142.1 3003959 g23742 i0 53.4 0.97752808988764 58 27 97.8 0 174 1 139 196 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 174 60.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31077305 31077305 PRJNA1008624_P_NODE_11135_length_250_cov_1.711443_g10947_i0 PRJNA1008624 11135 250 1.711443 4.2786075 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 127 6.749999999999999e-32   NR XCM68142.1 3003959 g10947 i0 71.3 1.92 80 23 96 0 248 9 237 316 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 480 127 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31266856 31266856 PRJNA1008624_P_NODE_9675_length_269_cov_1.527273_g9487_i0 PRJNA1008624 9675 269 1.527273 4.10836437 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 62 8.78e-9   NR UNY41988.1 3003959 g9487 i0 44.9 1.97397769516729 89 40 93.7 4 257 6 85 169 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 531 62 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);;