contig_metadata
23 rows where bioproject = "PRJNA312615" and tax_superkingdom = "Viruses"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2929458 | 2929458 | PRJNA312615_P_NODE_7583_length_446_cov_1.410579_g7433_i0 | PRJNA312615 | 7583 | 446 | 1.410579 | 6.29118234 | Campylobacter phage CJLB-4 | 2781358 | Viruses | Viruses | 56.2 | 1.31e-7 | NR | QPB10331.1 | 2781358 | g7433 | i0 | 66.7 | 0.302690582959641 | 45 | 15 | 30.3 | 0 | 290 | 156 | 10 | 54 | QPB10331.1 hypothetical protein [Campylobacter phage CJLB-4] | diamond | 135 | 56.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Campylobacter phage CJLB-4 | ||||
| 5482033 | 5482033 | PRJNA312615_P_NODE_50045_length_169_cov_0.866667_g49894_i0 | PRJNA312615 | 50045 | 169 | 0.866667 | 1.46466723 | Cutibacterium phage vB_CacS-HV1 | 3236917 | Viruses | Viruses | 307 | 2.73e-79 | NTclustered | gi|2780182484|gb|PQ037195.1| | 3236917 | g49894 | i0 | 99.408 | 99.7041420118343 | 169 | 1 | 100 | 0 | 1 | 169 | 192 | 360 | Cutibacterium phage vB_CacS-HV1, complete genome | blastn | 16850 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Cutibacterium phage vB_CacS-HV1 | ||||
| 11857047 | 11857047 | PRJNA312615_P_NODE_42770_length_187_cov_1.420290_g42619_i0 | PRJNA312615 | 42770 | 187 | 1.42029 | 2.6559423 | Pyongtaek Culex Ribovirus | 2902618 | Viruses | Viruses | 307 | 3.09e-79 | NTclustered | gi|2163656929|gb|MT568536.1| | 2902618 | g42619 | i0 | 96.257 | 1.60427807486631 | 187 | 7 | 100 | 0 | 1 | 187 | 9047 | 8861 | MAG: Pyongtaek Culex Ribovirus isolate A18.4517 genomic sequence, sequence | blastn | 300 | 307 | 1 | Viruses | Pyongtaek Culex Ribovirus | ||||||||
| 13132033 | 13132033 | PRJNA312615_P_NODE_37611_length_200_cov_1.350993_g37460_i0 | PRJNA312615 | 37611 | 200 | 1.350993 | 2.701986 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 220 | 4.5e-53 | NTclustered | gi|2914775648|gb|OR222112.1| | 2832643 | g37460 | i0 | 91.772 | 30.48 | 158 | 13 | 79 | 0 | 3 | 160 | 12602 | 12445 | MAG: Caudoviricetes sp. isolate MSP0869 genomic sequence | blastn | 6096 | 220 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20190020 | 20190020 | PRJNA312615_P_NODE_35236_length_206_cov_51.191083_g35085_i0 | PRJNA312615 | 35236 | 206 | 51.191083 | 105.45363098 | root | 1 | Root_unresolved | Root_unresolved | 267 | 5.91e-67 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g35085 | i0 | 100 | 69.9029126213592 | 144 | 0 | 70 | 0 | 7 | 150 | 11379 | 11236 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 14400 | 267 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22741020 | 22741020 | PRJNA312615_P_NODE_58938_length_155_cov_2.896226_g58787_i0 | PRJNA312615 | 58938 | 155 | 2.896226 | 4.4891503 | Viruses | 10239 | Viruses | Viruses | 287 | 3.21e-73 | NTclustered | gi|1631923064|ref|NC_041928.1| | 1340769 | g58787 | i0 | 100 | 17 | 155 | 0 | 100 | 0 | 1 | 155 | 12348 | 12502 | Staphylococcus phage phiIBB-SEP1, complete genome | blastn | 2635 | 287 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Sepunavirus | Sepunavirus SEP1 | |||
| 23330576 | 23330576 | PRJNA312615_P_NODE_48799_length_171_cov_2.122951_g48648_i0 | PRJNA312615 | 48799 | 171 | 2.122951 | 3.63024621 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g48648 | i0 | 100 | 1 | 171 | 0 | 100 | 0 | 1 | 171 | 25627 | 25457 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 171 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23330620 | 23330620 | PRJNA312615_P_NODE_50639_length_168_cov_0.873950_g50488_i0 | PRJNA312615 | 50639 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 87.9 | 3.87e-13 | NTclustered | gi|2914888655|gb|OR222597.1| | 2832643 | g50488 | i0 | 80 | 10.6130952380952 | 130 | 16 | 74 | 8 | 37 | 161 | 87859 | 87735 | MAG: Caudoviricetes sp. isolate MSP0337 genomic sequence | blastn | 1783 | 87.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24015780 | 24015780 | PRJNA312615_P_NODE_36379_length_203_cov_23.019481_g36228_i0 | PRJNA312615 | 36379 | 203 | 23.019481 | 46.72954643 | root | 1 | Root_unresolved | Root_unresolved | 274 | 3.47e-69 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g36228 | i0 | 100 | 92.2955665024631 | 148 | 0 | 93 | 0 | 1 | 148 | 28637 | 28490 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 18736 | 274 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25289857 | 25289857 | PRJNA312615_P_NODE_16240_length_304_cov_20.929412_g16089_i0 | PRJNA312615 | 16240 | 304 | 20.929412 | 63.62541248 | root | 1 | Root_unresolved | Root_unresolved | 516 | 8.36e-142 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g16089 | i0 | 98.962 | 95.0822368421053 | 289 | 1 | 95 | 2 | 6 | 293 | 14830 | 15117 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 28905 | 516 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25290095 | 25290095 | PRJNA312615_P_NODE_35980_length_204_cov_42.277419_g35829_i0 | PRJNA312615 | 35980 | 204 | 42.277419 | 86.24593476 | root | 1 | Root_unresolved | Root_unresolved | 263 | 7.549999999999999e-66 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g35829 | i0 | 98.658 | 73.0392156862745 | 149 | 1 | 73 | 1 | 1 | 148 | 11551 | 11403 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 14900 | 263 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 27737998 | 27737998 | PRJNA312615_P_NODE_56904_length_163_cov_0.894737_g56753_i0 | PRJNA312615 | 56904 | 163 | 0.894737 | 1.45842131 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 55.1 | 5.41e-7 | NR | ARF12097.1 | 1977640 | g56753 | i0 | 51.9 | 0.957055214723926 | 52 | 24 | 93.9 | 1 | 9 | 161 | 107 | 158 | ARF12097.1 hypothetical protein Klosneuvirus_3_232 [Klosneuvirus KNV1] | diamond | 156 | 55.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 28779468 | 28779468 | PRJNA312615_P_NODE_6387_length_482_cov_1.279446_g6239_i0 | PRJNA312615 | 6387 | 482 | 1.279446 | 6.16692972 | Enterobacteria phage IME1 | 1090133 | Viruses | Viruses | 117 | 4.56e-29 | NR | YP_007004316.1 | 1090133 | g6239 | i0 | 46.5 | 0.79045643153527 | 127 | 68 | 79 | 0 | 480 | 100 | 27 | 153 | YP_007004316.1 regulatory protein Q [Enterobacteria phage IME10] | diamond | 381 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Enterobacteria phage IME10 | ||||
| 28937567 | 28937567 | PRJNA312615_P_NODE_14148_length_327_cov_1.107914_g13997_i0 | PRJNA312615 | 14148 | 327 | 1.107914 | 3.62287878 | Escherichia phage Lambda | 2681611 | Viruses | Viruses | 71.2 | 6.81e-14 | NR | NP_040643.1 | 2681611 | g13997 | i0 | 46.9 | 0.587155963302752 | 64 | 34 | 58.7 | 0 | 120 | 311 | 1 | 64 | NP_040643.1 hypothetical protein lambdap73 [Escherichia phage Lambda] | diamond | 192 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 29442404 | 29442404 | PRJNA312615_P_NODE_32490_length_215_cov_0.861446_g32339_i0 | PRJNA312615 | 32490 | 215 | 0.861446 | 1.8521089 | Multiple sclerosis associated retrovirus element | 89382 | Viruses | Viruses | 41.6 | 0.00877 | NR | AAD48373.1 | 89382 | g32339 | i0 | 55.9 | 0.474418604651163 | 34 | 15 | 47.4 | 0 | 102 | 1 | 14 | 47 | AAD48373.1 unknown protein U5/2 [Multiple sclerosis associated retrovirus element] | diamond | 102 | 41.6 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus W | ||
| 29537326 | 29537326 | PRJNA312615_P_NODE_45190_length_181_cov_1.515152_g45039_i0 | PRJNA312615 | 45190 | 181 | 1.515152 | 2.74242512 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 89.7 | 2.95e-19 | NR | YP_010803269.1 | 3060017 | g45039 | i0 | 70.7 | 0.961325966850829 | 58 | 17 | 96.1 | 0 | 179 | 6 | 292 | 349 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 174 | 89.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29726543 | 29726543 | PRJNA312615_P_NODE_17690_length_291_cov_1.140496_g17539_i0 | PRJNA312615 | 17690 | 291 | 1.140496 | 3.31884336 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.7 | 1.48e-21 | NR | DAH93386.1 | 2832643 | g17539 | i0 | 69.7 | 1.36082474226804 | 66 | 20 | 68 | 0 | 290 | 93 | 48 | 113 | DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] | diamond | 396 | 91.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29916471 | 29916471 | PRJNA312615_P_NODE_44071_length_184_cov_1.133333_g43920_i0 | PRJNA312615 | 44071 | 184 | 1.133333 | 2.08533272 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 57 | 4.79e-8 | NR | DBA50495.1 | 3115894 | g43920 | i0 | 46.7 | 0.978260869565217 | 60 | 32 | 97.8 | 0 | 3 | 182 | 110 | 169 | DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377] | diamond | 180 | 57 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 30168844 | 30168844 | PRJNA312615_P_NODE_50092_length_169_cov_0.866667_g49941_i0 | PRJNA312615 | 50092 | 169 | 0.866667 | 1.46466723 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 47.4 | 2.79e-4 | NR | DBA50496.1 | 3115894 | g49941 | i0 | 65.6 | 0.568047337278107 | 32 | 11 | 56.8 | 0 | 3 | 98 | 178 | 209 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 96 | 47.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 30737663 | 30737663 | PRJNA312615_P_NODE_56954_length_163_cov_0.894737_g56803_i0 | PRJNA312615 | 56954 | 163 | 0.894737 | 1.45842131 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 94.7 | 3.78e-21 | NR | CAB4147586.1 | 2100421 | g56803 | i0 | 81.1 | 3.92024539877301 | 53 | 10 | 97.5 | 0 | 5 | 163 | 269 | 321 | CAB4147586.1 phage_term_2, phage terminase, large subunit, PBSX family [uncultured Caudovirales phage] | diamond | 639 | 94.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30800843 | 30800843 | PRJNA312615_P_NODE_24954_length_245_cov_0.872449_g24803_i0 | PRJNA312615 | 24954 | 245 | 0.872449 | 2.13750005 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 68.6 | 2.59e-11 | NR | DAC81401.1 | 2609864 | g24803 | i0 | 48.8 | 2.00816326530612 | 82 | 41 | 99.2 | 1 | 244 | 2 | 169 | 250 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 492 | 68.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31306537 | 31306537 | PRJNA312615_P_NODE_415_length_1349_cov_1.535385_g360_i0 | PRJNA312615 | 415 | 1349 | 1.535385 | 20.71234365 | Escherichia phage Kati | 3233700 | Viruses | Viruses | 190 | 7.04e-51 | NR | XNS38751.1 | 3233700 | g360 | i0 | 54.6 | 1.22535211267606 | 185 | 84 | 41.1 | 0 | 5 | 559 | 314 | 498 | XNS38751.1 hypothetical protein WLKYIJTT_CDS0034 [Escherichia phage Kati] | diamond | 1653 | 190 | 1 | Viruses | Escherichia phage Kati | ||||||||
| 32729466 | 32729466 | PRJNA312615_P_NODE_19580_length_275_cov_2.030973_g19429_i0 | PRJNA312615 | 19580 | 275 | 2.030973 | 5.58517575 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 64.3 | 2.52e-11 | NR | DAI56203.1 | 2832643 | g19429 | i0 | 66.7 | 0.523636363636364 | 48 | 16 | 52.4 | 0 | 192 | 49 | 24 | 71 | DAI56203.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 144 | 64.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
Advanced export
JSON shape: default, array, newline-delimited
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);;