RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA975724", tax_phylum = "Uroviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA975724 · 5 ✖

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
3818819 3818819 PRJNA975724_S_NODE_63163_length_273_cov_2.175000_g62982_i0 PRJNA975724 63163 273 2.175 5.93775 Ehrlichviridae 3424644 Viruses Viruses 52.8 0.025   NTclustered gi|2581897208|gb|OR338916.1| 3075862 g62982 i0 100 0.41025641025641 28 0 10 0 231 258 33296 33323 Bacillus phage DZ1, complete genome blastn 112 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Ehrlichviridae Dazunavirus Dazunavirus DZ1
8919625 8919625 PRJNA975724_S_NODE_24307_length_368_cov_2.928814_g24126_i0 PRJNA975724 24307 368 2.928814 10.77803552 Tanisvirus 2843069 Viruses Viruses 52.8 0.035   NTclustered gi|2554108187|gb|OR159671.1| 3062834 g24126 i0 100 0.228260869565217 28 0 8 0 96 123 1855 1882 Gordonia phage Conley, complete genome blastn 84 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Tanisvirus Gordonia phage Conley
12424878 12424878 PRJNA975724_S_NODE_24630_length_367_cov_1.846939_g24449_i0 PRJNA975724 24630 367 1.846939 6.7782661299999996 Caudoviricetes sp. 2832643 Viruses Viruses 222 2.51e-53   NTclustered gi|2054596226|tpg|BK021635.1| 2832643 g24449 i0 81.752 5.89645776566757 274 43 74 4 81 353 13688 13421 MAG TPA_asm: Caudoviricetes sp. isolate ctG972, partial genome blastn 2164 222 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16250248 16250248 PRJNA975724_S_NODE_87153_length_244_cov_1.350877_g86972_i0 PRJNA975724 87153 244 1.350877 3.29613988 Bacillus phage vB_BspM_AgentSmith 2836110 Viruses Viruses 54.7 0.006   NTclustered gi|2067460077|gb|MW749006.1| 2836110 g86972 i0 92.308 0.159836065573771 39 1 16 2 174 211 138216 138179 Bacillus phage vB_BspM_AgentSmith, complete genome blastn 39 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BspM_AgentSmith
18798855 18798855 PRJNA975724_S_NODE_75255_length_255_cov_1.549451_g75074_i0 PRJNA975724 75255 255 1.549451 3.95110005 Caudoviricetes sp. 2832643 Viruses Viruses 56.5 0.002   NTclustered gi|2914804131|gb|OR221383.1| 2832643 g75074 i0 100 3.19607843137255 30 0 12 0 226 255 42029 42058 MAG: Caudoviricetes sp. isolate MSP1711 genomic sequence blastn 815 56.5 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);;