RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA999043" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA999043 · 5 ✖

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.
29395011 29395011 PRJNA999043_P_NODE_14769_length_369_cov_0.895270_g14674_i0 PRJNA999043 14769 369 0.89527 3.3035463 Escherichia phage Lambda imm21 2918897 Viruses Viruses 78.2 2.07e-16   NR UNA07126.1 2918897 g14674 i0 60.3 0.51219512195122 63 25 51.2 0 189 1 1 63 UNA07126.1 hypothetical protein CPT_lambdaimm21_027 [Escherichia phage Lambda imm21] diamond 189 78.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lambdavirus Escherichia phage Lambda imm21
32303066 32303066 PRJNA999043_P_NODE_18019_length_300_cov_1.215859_g17924_i0 PRJNA999043 18019 300 1.215859 3.647577 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 3.02e-11   NR DAG14272.1 2832643 g17924 i0 56.6 1 53 23 53 0 240 82 1 53 DAG14272.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 300 63.9 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);;