RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA999043" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA999043 · 3 ✖

analysis 1

  • blastn · 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
2254646 2254646 PRJNA999043_P_NODE_13182_length_410_cov_3.074184_g13087_i0 PRJNA999043 13182 410 3.074184 12.6041544 Caudoviricetes sp. 2832643 Viruses Viruses 553 8.859999999999998e-153   NTclustered gi|2914826682|gb|OR222326.1| 2832643 g13087 i0 91.4 76.6170731707317 407 29 99 2 5 410 1704 1303 MAG: Caudoviricetes sp. isolate MSP1075 genomic sequence blastn 31413 553 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4807750 4807750 PRJNA999043_P_NODE_21824_length_250_cov_1.305085_g21729_i0 PRJNA999043 21824 250 1.305085 3.2627125 Caudoviricetes sp. 2832643 Viruses Viruses 375 1.18e-99   NTclustered gi|2914826682|gb|OR222326.1| 2832643 g21729 i0 93.651 1.772 252 14 100 2 1 250 49165 49416 MAG: Caudoviricetes sp. isolate MSP1075 genomic sequence blastn 443 375 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17557659 17557659 PRJNA999043_P_NODE_21534_length_251_cov_0.865169_g21439_i0 PRJNA999043 21534 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 453 5.34e-123   NTclustered gi|2914865133|gb|OR222511.1| 2832643 g21439 i0 99.203 1 251 2 100 0 1 251 77034 76784 MAG: Caudoviricetes sp. isolate MSP0434 genomic sequence blastn 251 453 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;