RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA340009 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1666475 1666475 PRJNA340009_P_NODE_14162_length_313_cov_5.132576_g13855_i0 PRJNA340009 14162 313 5.132576 16.06496288 Microviridae sp. 2202644 Viruses Viruses 193 1.65e-44   NTclustered gi|1603902751|gb|MH616940.2| 2202644 g13855 i0 87.805 1.27476038338658 164 20 52 0 46 209 2333 2170 MAG: Microviridae sp. isolate ctdg534, complete genome blastn 399 193 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
1667224 1667224 PRJNA340009_P_NODE_80822_length_152_cov_2.456311_g80515_i0 PRJNA340009 80822 152 2.456311 3.73359272 Microviridae sp. 2202644 Viruses Viruses 110 7.27e-20   NTclustered gi|2906151359|gb|PQ646576.1| 2202644 g80515 i0 93.243 0.486842105263158 74 5 49 0 1 74 3631 3558 MAG: Microviridae sp. isolate k127_3173000 genomic sequence blastn 74 110 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
10595756 10595756 PRJNA340009_P_NODE_26589_length_239_cov_2.147368_g26282_i0 PRJNA340009 26589 239 2.147368 5.13220952 Microviridae sp. 2202644 Viruses Viruses 392 1.11e-104   NTclustered gi|2497507111|gb|OQ709380.1| 2202644 g26282 i0 96.234 2 239 9 100 0 1 239 2860 2622 MAG: Microviridae sp. isolate SHu1-1, complete genome blastn 478 392 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
13146101 13146101 PRJNA340009_P_NODE_67251_length_165_cov_0.879310_g66944_i0 PRJNA340009 67251 165 0.87931 1.4508615 Microviridae sp. 2202644 Viruses Viruses 108 2.9e-19   NTclustered gi|2384854028|gb|OM154917.1| 2202644 g66944 i0 85.437 8.83636363636364 103 15 62 0 50 152 101 203 MAG: Microviridae sp. isolate Miresoil microvirus 98, complete genome blastn 1458 108 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
16969525 16969525 PRJNA340009_P_NODE_36174_length_210_cov_1.236025_g35867_i0 PRJNA340009 36174 210 1.236025 2.5956525 Microviridae sp. 2202644 Viruses Viruses 359 9.7e-95   NTclustered gi|2906151359|gb|PQ646576.1| 2202644 g35867 i0 99 0.952380952380952 200 2 95 0 11 210 2903 2704 MAG: Microviridae sp. isolate k127_3173000 genomic sequence blastn 200 359 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
16969679 16969679 PRJNA340009_P_NODE_49414_length_184_cov_2.940741_g49107_i0 PRJNA340009 49414 184 2.940741 5.41096344 Microviridae sp. 2202644 Viruses Viruses 89.8 1.2e-13   NTclustered gi|2384853757|gb|OM154888.1| 2202644 g49107 i0 81.818 0.945652173913043 110 17 59 3 1 108 3599 3707 MAG: Microviridae sp. isolate Miresoil microvirus 69, complete genome blastn 174 89.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
19518392 19518392 PRJNA340009_P_NODE_74936_length_162_cov_0.902655_g74629_i0 PRJNA340009 74936 162 0.902655 1.4623011 Microviridae sp. 2202644 Viruses Viruses 54.7 0.004   NTclustered gi|2384853489|gb|OM154857.1| 2202644 g74629 i0 100 0.179012345679012 29 0 18 0 19 47 2344 2372 MAG: Microviridae sp. isolate Miresoil microvirus 38, complete genome blastn 29 54.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.

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