RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJDB14275" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJDB14275 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
28485244 28485244 PRJDB14275_P_NODE_7067_length_169_cov_1.238462_g7008_i0 PRJDB14275 7067 169 1.238462 2.09300078 Pectobacterium phage DU_PP_V 2041492 Viruses Viruses 44.7 8.57e-4   NR YP_009795259.1 2041492 g7008 i0 48.5 0.585798816568047 33 17 58.6 0 71 169 2 34 YP_009795259.1 hypothetical protein HOS40_gp117 [Pectobacterium phage DU_PP_V] diamond 99 44.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Hongcheonvirus Hongcheonvirus DUPPV
28737835 28737835 PRJDB14275_P_NODE_6767_length_174_cov_1.333333_g6708_i0 PRJDB14275 6767 174 1.333333 2.31999942 uncultured Caudovirales phage 2100421 Viruses Viruses 75.1 5.63e-14   NR CAB4146221.1 2100421 g6708 i0 76.5 0.879310344827586 51 12 87.9 0 155 3 371 421 CAB4146221.1 PolA DNA polymerase I - 3'-5' exonuclease and polymerase domains [uncultured Caudovirales phage] diamond 153 75.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29779721 29779721 PRJDB14275_P_NODE_5451_length_208_cov_1.183432_g5392_i0 PRJDB14275 5451 208 1.183432 2.46153856 uncultured Caudovirales phage 2100421 Viruses Viruses 113 3.65e-27   NR CAB4127530.1 2100421 g5392 i0 82.4 0.980769230769231 68 12 98.1 0 206 3 398 465 CAB4127530.1 Phage P22-like portal protein [uncultured Caudovirales phage] diamond 204 113 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30727458 30727458 PRJDB14275_P_NODE_3334_length_325_cov_1.835664_g3275_i0 PRJDB14275 3334 325 1.835664 5.965908 uncultured Caudovirales phage 2100421 Viruses Viruses 179 1.15e-53   NR CAB4149628.1 2100421 g3275 i0 81 0.969230769230769 105 20 96.9 0 1 315 26 130 CAB4149628.1 hypothetical protein UFOVP548_26 [uncultured Caudovirales phage] diamond 315 179 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30948876 30948876 PRJDB14275_P_NODE_7214_length_167_cov_0.960938_g7155_i0 PRJDB14275 7214 167 0.960938 1.60476646 uncultured Caudovirales phage 2100421 Viruses Viruses 95.5 8.74e-24   NR CAB4123298.1 2100421 g7155 i0 76.4 0.988023952095808 55 13 98.8 0 167 3 4 58 CAB4123298.1 Rus Holliday junction resolvase [uncultured Caudovirales phage] diamond 165 95.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31232889 31232889 PRJDB14275_P_NODE_4495_length_248_cov_2.196172_g4436_i0 PRJDB14275 4495 248 2.196172 5.44650656 Caudoviricetes sp. 2832643 Viruses Viruses 67.4 7.17e-11   NR XOE93962.1 2832643 g4436 i0 63 1.30645161290323 54 20 65.3 0 82 243 159 212 XOE93962.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 324 67.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31738965 31738965 PRJDB14275_P_NODE_7757_length_159_cov_0.866667_g7698_i0 PRJDB14275 7757 159 0.866667 1.37800053 uncultured Caudovirales phage 2100421 Viruses Viruses 62.4 1.42e-9   NR CAB4205538.1 2100421 g7698 i0 56.6 2.9811320754717 53 23 100 0 159 1 1379 1431 CAB4205538.1 Domain of unknown function DUF4214 [uncultured Caudovirales phage] diamond 474 62.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31928905 31928905 PRJDB14275_P_NODE_4697_length_238_cov_1.658291_g4638_i0 PRJDB14275 4697 238 1.658291 3.94673258 uncultured Caudovirales phage 2100421 Viruses Viruses 91.7 2.17e-19   NR CAB4211635.1 2100421 g4638 i0 57.3 2.83613445378151 75 32 94.5 0 11 235 937 1011 CAB4211635.1 PcfJ-like protein, partial [uncultured Caudovirales phage] diamond 675 91.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32340511 32340511 PRJDB14275_P_NODE_6179_length_187_cov_1.391892_g6120_i0 PRJDB14275 6179 187 1.391892 2.60283804 Caudoviricetes sp. 2832643 Viruses Viruses 111 6.470000000000001e-27   NR QRW43102.1 2832643 g6120 i0 98.2 0.898395721925134 56 1 89.8 0 187 20 163 218 QRW43102.1 MAG: terminase large subunit [Caudoviricetes sp.] diamond 168 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32435541 32435541 PRJDB14275_P_NODE_7019_length_170_cov_0.801527_g6960_i0 PRJDB14275 7019 170 0.801527 1.3625959 Caudoviricetes sp. 2832643 Viruses Viruses 110 1.33e-26   NR QRW43102.1 2832643 g6960 i0 87.5 0.988235294117647 56 7 98.8 0 169 2 13 68 QRW43102.1 MAG: terminase large subunit [Caudoviricetes sp.] diamond 168 110 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);;