RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1145997 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
27512994 27512994 PRJNA1145997_P_NODE_30603_length_373_cov_1.030000_g27984_i0 PRJNA1145997 30603 373 1.03 3.8419 Xanthomonas phage Xoo-sp13 2591401 Viruses Viruses 61.6 3.17e-9   NR QDJ96209.1 2591401 g27984 i0 65.8 0.635388739946381 38 13 30.6 0 372 259 77 114 QDJ96209.1 hypothetical protein Xoosp13_22 [Xanthomonas phage Xoo-sp13] diamond 237 61.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage Xoo-sp13
27576101 27576101 PRJNA1145997_P_NODE_30304_length_379_cov_1.418301_g27685_i0 PRJNA1145997 30304 379 1.418301 5.37536079 Pseudomonas phage Skulduggery 2006671 Viruses Viruses 186 1.4299999999999998e-56   NR YP_010655373.1 2006671 g27685 i0 68.3 1.9868073878628 126 40 99.7 0 2 379 136 261 YP_010655373.1 small terminase subunit [Pseudomonas phage Skulduggery] diamond 753 186 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Skulduggeryvirus Skulduggeryvirus skulduggery
27607779 27607779 PRJNA1145997_P_NODE_39724_length_269_cov_1.132653_g37105_i0 PRJNA1145997 39724 269 1.132653 3.04683657 Halorubrum phage GNf2 889959 Viruses Viruses 135 4.24e-36   NR AGF91192.1 889959 g37105 i0 77.4 0.936802973977695 84 19 93.7 0 252 1 1 84 AGF91192.1 hypothetical protein HAPG_00006 [Halorubrum phage GNf2] diamond 252 135 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Thumleimavirales Soleiviridae   Halorubrum phage GNf2
27955035 27955035 PRJNA1145997_P_NODE_45005_length_248_cov_1.400000_g42386_i0 PRJNA1145997 45005 248 1.4 3.472 Caudoviricetes sp. 2832643 Viruses Viruses 55.8 1.72e-7   NR XOS47164.1 2832643 g42386 i0 77.8 0.435483870967742 36 8 43.5 0 110 3 52 87 XOS47164.1 MAG: hypothetical protein MSP0423_154 [Caudoviricetes sp.] diamond 108 55.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28460351 28460351 PRJNA1145997_P_NODE_26706_length_465_cov_1.938776_g24089_i0 PRJNA1145997 26706 465 1.938776 9.0153084 Arthrobacter phage SWEP2 2945958 Viruses Viruses 66.6 7.12e-11   NR USL85101.1 2945958 g24089 i0 60.8 0.329032258064516 51 20 32.9 0 463 311 60 110 USL85101.1 hypothetical protein [Arthrobacter phage SWEP2] diamond 153 66.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Casidaviridae Swepdovirus Swepdovirus SWEP2
28838952 28838952 PRJNA1145997_P_NODE_45768_length_247_cov_0.896552_g43149_i0 PRJNA1145997 45768 247 0.896552 2.21448344 uncultured Caudovirales phage 2100421 Viruses Viruses 99.8 2.16e-22   NR CAB4139374.1 2100421 g43149 i0 62.5 0.874493927125506 72 27 87.4 0 218 3 8 79 CAB4139374.1 RTPR, ribonucleoside-triphosphate reductase, adenosylcobalamin-dependent [uncultured Caudovirales phage] diamond 216 99.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30007550 30007550 PRJNA1145997_P_NODE_33751_length_324_cov_1.661355_g31132_i0 PRJNA1145997 33751 324 1.661355 5.3827902 Caudoviricetes sp. 2832643 Viruses Viruses 132 1.9e-33   NR DAP65153.1 2832643 g31132 i0 68.8 2.01851851851852 109 31 99.1 2 322 2 300 407 DAP65153.1 MAG TPA: Cation transport ATPase [Caudoviricetes sp.] diamond 654 132 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30639142 30639142 PRJNA1145997_P_NODE_33793_length_323_cov_6.980000_g31174_i0 PRJNA1145997 33793 323 6.98 22.5454 uncultured Caudovirales phage 2100421 Viruses Viruses 55.1 4e-6   NR CAB5219857.1 2100421 g31174 i0 52.9 2.38699690402477 51 24 47.4 0 161 9 1 51 CAB5219857.1 hypothetical protein UFOVP237_15 [uncultured Caudovirales phage] diamond 771 55.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31018479 31018479 PRJNA1145997_P_NODE_40415_length_264_cov_1.308901_g37796_i0 PRJNA1145997 40415 264 1.308901 3.45549864 Caudoviricetes sp. 2832643 Viruses Viruses 95.5 1.5899999999999995e-23   NR DAU46689.1 2832643 g37796 i0 61.7 0.920454545454545 81 29 89.8 1 1 237 6 86 DAU46689.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 243 95.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31207546 31207546 PRJNA1145997_P_NODE_36675_length_292_cov_1.132420_g34056_i0 PRJNA1145997 36675 292 1.13242 3.3066664 Pseudomonas phage Astolliot 2928830 Viruses Viruses 91.3 4.33e-21   NR UOL48877.1 2928830 g34056 i0 50.6 0.832191780821918 81 37 83.2 1 290 48 63 140 UOL48877.1 hypothetical protein [Pseudomonas phage Astolliot] diamond 243 91.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Otagovirus Pseudomonas phage Astolliot
32030542 32030542 PRJNA1145997_P_NODE_42778_length_252_cov_0.871508_g40159_i0 PRJNA1145997 42778 252 0.871508 2.19620016 Caudoviricetes sp. 2832643 Viruses Viruses 53.1 5.5e-7   NR DAM43665.1 2832643 g40159 i0 52.8 0.630952380952381 53 25 63.1 0 216 58 1 53 DAM43665.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 159 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32125564 32125564 PRJNA1145997_P_NODE_43938_length_250_cov_0.881356_g41319_i0 PRJNA1145997 43938 250 0.881356 2.20339 Pseudomonas phage Skulduggery 2006671 Viruses Viruses 123 2.14e-30   NR YP_010655392.1 2006671 g41319 i0 68.3 0.984 82 26 98.4 0 247 2 491 572 YP_010655392.1 tail protein [Pseudomonas phage Skulduggery] diamond 246 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Skulduggeryvirus Skulduggeryvirus skulduggery
32157153 32157153 PRJNA1145997_P_NODE_43298_length_251_cov_1.314607_g40679_i0 PRJNA1145997 43298 251 1.314607 3.29966357 Pseudomonas phage Skulduggery 2006671 Viruses Viruses 135 5.0299999999999995e-37   NR YP_010655412.1 2006671 g40679 i0 78.3 0.99203187250996006 83 18 99.2 0 1 249 78 160 YP_010655412.1 hypothetical protein PP627_gp40 [Pseudomonas phage Skulduggery] diamond 249 135 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Skulduggeryvirus Skulduggeryvirus skulduggery
32157157 32157157 PRJNA1145997_P_NODE_48018_length_244_cov_0.912281_g45399_i0 PRJNA1145997 48018 244 0.912281 2.22596564 Xanthomonas phage XAJ2 1775249 Viruses Viruses 94.4 2.28e-20   NR AMW36132.1 1775249 g45399 i0 63.8 0.983606557377049 80 29 98.4 0 3 242 152 231 AMW36132.1 major tail tube protein [Xanthomonas phage XAJ2] diamond 240 94.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Xajduovirus Xajduovirus XAJ2

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);;