RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1000943" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1000943 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
26615291 26615291 PRJNA1000943_P_NODE_1_length_3542_cov_44.793600_g0_i0 PRJNA1000943 1 3542 44.7936 1586.589312 Viruses 10239 Viruses Viruses 117 2.13e-22   NR XCM67689.1 1955153 g0 i0 23.1 1.38311688311688 859 462 62.9 31 1158 3386 270 1045 XCM67689.1 MAG: structural polyprotein [Picornavirales sp.] diamond 4899 118 0.991525423728814 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
26812870 26812870 PRJNA1000943_P_NODE_9421_length_271_cov_1.909091_g9283_i0 PRJNA1000943 9421 271 1.909091 5.17363661 Carrot torradovirus 1 1425364 Viruses Viruses 74.7 3.08e-13   NR QJX15640.1 1425364 g9283 i0 44.6 5.09225092250923 83 41 86.3 2 32 265 1303 1385 QJX15640.1 polyprotein [Carrot torradovirus 1] diamond 1380 74.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Torradovirus Torradovirus carotae
30824220 30824220 PRJNA1000943_P_NODE_5314_length_347_cov_1.423358_g5176_i0 PRJNA1000943 5314 347 1.423358 4.93905226 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 72.4 5.18e-12   NR XCM68071.1 3003959 g5176 i0 36.5 0.994236311239193 115 69 96.8 3 339 4 1923 2036 XCM68071.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 345 72.4 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);;