RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA721440", tax_kingdom = "Heunggongvirae" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 4 ✖

tax_kingdom 1

  • Heunggongvirae · 4 ✖

bioproject 1

  • PRJNA721440 · 4 ✖

analysis 1

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
10914202 10914202 PRJNA721440_S_NODE_929_length_537_cov_31.508197_g807_i0 PRJNA721440 929 537 31.508197 169.19901789 Caudoviricetes sp. 2832643 Viruses Viruses 65.8 6.78e-6   NTclustered gi|2056808531|tpg|BK057475.1| 2832643 g807 i0 97.436 0.480446927374302 39 0 7 1 42 79 17 55 MAG TPA_asm: Caudoviricetes sp. isolate ctwEd7, partial genome blastn 258 65.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18562010 18562010 PRJNA721440_S_NODE_9595_length_208_cov_0.930818_g9469_i0 PRJNA721440 9595 208 0.930818 1.93610144 Achromobacter phage tuull 3074846 Viruses Viruses 58.4 3.92e-4   NTclustered gi|2618964722|gb|OR396896.1| 3074846 g9469 i0 94.737 0.182692307692308 38 0 18 2 6 42 36626 36662 Achromobacter phage tuull, partial genome blastn 38 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage tuull
23663180 23663180 PRJNA721440_S_NODE_14459_length_179_cov_1.130769_g14333_i0 PRJNA721440 14459 179 1.130769 2.02407651 Caudoviricetes sp. 2832643 Viruses Viruses 315 1.75e-81   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g14333 i0 98.324 328.77094972067 179 3 100 0 1 179 17963 18141 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 58850 315 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23663210 23663210 PRJNA721440_S_NODE_3879_length_293_cov_16.106557_g3753_i0 PRJNA721440 3879 293 16.106557 47.19221201 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1.26e-5   NTclustered gi|2059855482|tpg|BK040575.1| 2832643 g3753 i0 97.368 0.238907849829352 38 0 13 1 1 37 5 42 MAG TPA_asm: Caudoviricetes sp. isolate ctwIV1, partial genome blastn 70 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);;