RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA694557 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
24899773 24899773 PRJNA694557_P_NODE_3680_length_796_cov_3.609959_g3480_i0 PRJNA694557 3680 796 3.609959 28.73527364 Caudoviricetes sp. 2832643 Viruses Viruses 406 3.26e-138   NR XOQ89705.1 2832643 g3480 i0 78 0.96105527638191 255 52 95.7 2 12 773 161 412 XOQ89705.1 MAG: p097 protein [Caudoviricetes sp.] diamond 765 406 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26682330 26682330 PRJNA694557_P_NODE_14261_length_346_cov_3.109890_g14041_i0 PRJNA694557 14261 346 3.10989 10.7602194 Viruses 10239 Viruses Viruses 113 4.81e-28   NR UQS94696.1 2832323 g14041 i0 55 1.73410404624277 100 42 84.1 1 293 3 1 100 UQS94696.1 major tail protein [Arthrobacter phage Zeina] diamond 600 114 0.991228070175439 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Arthrobacter phage Zeina
26797736 26797736 PRJNA694557_P_NODE_22601_length_257_cov_1.673913_g22381_i0 PRJNA694557 22601 257 1.673913 4.30195641 Caudoviricetes sp. 2832643 Viruses Viruses 58.5 1.18e-7   NR XOR32326.1 2832643 g22381 i0 45.8 0.968871595330739 83 42 95.7 2 257 12 351 431 XOR32326.1 MAG: capsid maturation protease [Caudoviricetes sp.] diamond 249 58.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26797738 26797738 PRJNA694557_P_NODE_25481_length_242_cov_2.248521_g25261_i0 PRJNA694557 25481 242 2.248521 5.44142082 Caudoviricetes sp. 2832643 Viruses Viruses 80.9 6.34e-16   NR XOR82967.1 2832643 g25261 i0 51.4 0.892561983471074 72 35 89.3 0 224 9 189 260 XOR82967.1 MAG: hypothetical protein MSP1870_2 [Caudoviricetes sp.] diamond 216 80.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27588202 27588202 PRJNA694557_P_NODE_24944_length_244_cov_3.011696_g24724_i0 PRJNA694557 24944 244 3.011696 7.34853824 Caudoviricetes sp. 2832643 Viruses Viruses 76.6 4.33e-14   NR XOE94180.1 2832643 g24724 i0 67.3 0.602459016393443 49 16 60.2 0 95 241 496 544 XOE94180.1 MAG: DNA primase/helicase [Caudoviricetes sp.] diamond 147 76.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27840482 27840482 PRJNA694557_P_NODE_22964_length_254_cov_2.121547_g22744_i0 PRJNA694557 22964 254 2.121547 5.38872938 Caudoviricetes sp. 2832643 Viruses Viruses 48.1 3.91e-4   NR DAI57693.1 2832643 g22744 i0 31.3 1.96062992125984 83 56 98 1 4 252 12 93 DAI57693.1 MAG TPA: Structural protein [Caudoviricetes sp.] diamond 498 48.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28030209 28030209 PRJNA694557_P_NODE_1945_length_1149_cov_2.375465_g1806_i0 PRJNA694557 1945 1149 2.375465 27.29409285 Caudoviricetes sp. 2832643 Viruses Viruses 102 1.09e-19   NR XOR06736.1 2832643 g1806 i0 30.6 0.673629242819843 258 160 66.6 6 766 2 50 291 XOR06736.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 774 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28061630 28061630 PRJNA694557_P_NODE_14225_length_347_cov_2.138686_g14005_i0 PRJNA694557 14225 347 2.138686 7.42124042 uncultured Caudovirales phage 2100421 Viruses Viruses 57.4 9.01e-7   NR CAB4139653.1 2100421 g14005 i0 28.8 1.20172910662824 139 65 91.6 3 341 24 503 640 CAB4139653.1 hypothetical protein UFOVP342_68 [uncultured Caudovirales phage] diamond 417 57.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28282505 28282505 PRJNA694557_P_NODE_15346_length_330_cov_3.151751_g15126_i0 PRJNA694557 15346 330 3.151751 10.4007783 Acinetobacter phage nACB1 3015924 Viruses Viruses 174 1.05e-48   NR WAW11599.1 3015924 g15126 i0 83.7 0.945454545454545 104 17 94.5 0 315 4 425 528 WAW11599.1 putative tail withlytic transglycosylase [Acinetobacter phage nACB1] diamond 312 174 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae   Acinetobacter phage nACB1
29009304 29009304 PRJNA694557_P_NODE_18708_length_291_cov_3.889908_g18488_i0 PRJNA694557 18708 291 3.889908 11.31963228 Salicola phage SCTP-2 2015814 Viruses Viruses 54.7 4.16e-6   NR ASV44554.1 2015814 g18488 i0 45.6 0.587628865979381 57 31 58.8 0 280 110 534 590 ASV44554.1 hypothetical protein PBI_SCTP2_539 [Salicola phage SCTP-2] diamond 171 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Salicola phage SCTP-2
29861453 29861453 PRJNA694557_P_NODE_16391_length_317_cov_4.008197_g16171_i0 PRJNA694557 16391 317 4.008197 12.70598449 Xanthomonas phage Xoo-sp14 2769337 Viruses Viruses 84.3 2.25e-16   NR QNR51696.1 2769337 g16171 i0 41.5 1.00315457413249 106 59 99.4 3 2 316 90 193 QNR51696.1 putative virion structural protein [Xanthomonas phage Xoo-sp14] diamond 318 84.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage Xoo-sp14
30524893 30524893 PRJNA694557_P_NODE_23333_length_251_cov_1.764045_g23113_i0 PRJNA694557 23333 251 1.764045 4.42775295 Caudoviricetes sp. 2832643 Viruses Viruses 62.4 3.57e-9   NR XOR06478.1 2832643 g23113 i0 42.9 0.920318725099602 77 42 90.8 2 16 243 14 89 XOR06478.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 231 62.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31536525 31536525 PRJNA694557_P_NODE_14816_length_338_cov_1.743396_g14596_i0 PRJNA694557 14816 338 1.743396 5.89267848 Caudoviricetes sp. 2832643 Viruses Viruses 68.9 6.39e-11   NR XOQ97981.1 2832643 g14596 i0 79.1 0.381656804733728 43 9 38.2 0 130 2 27 69 XOQ97981.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 129 68.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31757704 31757704 PRJNA694557_P_NODE_19517_length_284_cov_1.459716_g19297_i0 PRJNA694557 19517 284 1.459716 4.14559344 Acinetobacter phage nACB1 3015924 Viruses Viruses 64.7 1.16e-9   NR WAW11594.1 3015924 g19297 i0 51.7 0.940140845070423 89 43 94 0 18 284 641 729 WAW11594.1 hypothetical protein nACB1_012 [Acinetobacter phage nACB1] diamond 267 64.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae   Acinetobacter phage nACB1
31915864 31915864 PRJNA694557_P_NODE_5077_length_660_cov_2.885860_g4861_i0 PRJNA694557 5077 660 2.88586 19.046676 Caudoviricetes sp. 2832643 Viruses Viruses 87.4 1.23e-16   NR DAX02293.1 2832643 g4861 i0 28.2 1.49090909090909 163 115 73.6 2 62 547 2 163 DAX02293.1 MAG TPA: Protein of unknown function (DUF3150) [Caudoviricetes sp.] diamond 984 87.4 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);;