contig_metadata
20 rows where bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1409515 | 1409515 | PRJEB673_P_NODE_6422_length_343_cov_2.798701_g6073_i0 | PRJEB673 | 6422 | 343 | 2.798701 | 9.59954443 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g6073 | i0 | 100 | 8.45481049562682 | 29 | 0 | 8 | 0 | 8 | 36 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 16711637 | 16711637 | PRJEB673_P_NODE_9414_length_198_cov_1.226994_g9065_i0 | PRJEB673 | 9414 | 198 | 1.226994 | 2.42944812 | Weissella phage phiYS61 | 1161906 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|399528370|ref|NC_018270.1| | 1161906 | g9065 | i0 | 100 | 0.141414141414141 | 28 | 0 | 14 | 0 | 113 | 140 | 21003 | 20976 | Weissella phage phiYS61, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Weissella phage phiYS61 | |||||
| 20535803 | 20535803 | PRJEB673_P_NODE_2717_length_600_cov_1.658407_g2416_i0 | PRJEB673 | 2717 | 600 | 1.658407 | 9.950442 | Cripavirus sp. | 1955141 | Viruses | Viruses | 186 | 1.22e-50 | NR | ULF99874.1 | 1955141 | g2416 | i0 | 46.7 | 3.95 | 197 | 105 | 98.5 | 0 | 599 | 9 | 1517 | 1713 | ULF99874.1 MAG: hypothetical protein 1 [Cripavirus sp.] | diamond | 2370 | 186 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 21811736 | 21811736 | PRJEB673_P_NODE_98_length_2363_cov_2.653780_g63_i0 | PRJEB673 | 98 | 2363 | 2.65378 | 62.7088214 | Cripavirus | 144051 | Viruses | Viruses | 212 | 7.839999999999998e-54 | NR | ULF99858.1 | 1955141 | g63 | i0 | 42.3 | 2.15700380871773 | 307 | 152 | 35.8 | 6 | 2334 | 1489 | 197 | 503 | ULF99858.1 MAG: hypothetical protein 2 [Cripavirus sp.] | diamond | 5097 | 212 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 26748802 | 26748802 | PRJEB673_P_NODE_9241_length_205_cov_1.141176_g8892_i0 | PRJEB673 | 9241 | 205 | 1.141176 | 2.3394108 | Adintovirus pavo15764 | 3115938 | Viruses | Viruses | 43.5 | 0.011 | NR | DBA50334.1 | 3115938 | g8892 | i0 | 45.5 | 0.64390243902439 | 44 | 24 | 64.4 | 0 | 164 | 33 | 214 | 257 | DBA50334.1 MAG TPA_asm: Penton [Adintovirus pavo15764] | diamond | 132 | 43.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus pavo15764 | |||
| 26876171 | 26876171 | PRJEB673_P_NODE_1_length_6210_cov_3.522915_g0_i0 | PRJEB673 | 1 | 6210 | 3.522915 | 218.7730215 | Ripucork virus | 3130406 | Viruses | Viruses | 347 | 7.69e-100 | NR | WZH59587.1 | 3130406 | g0 | i0 | 34.4 | 0.297584541062802 | 616 | 377 | 29.1 | 10 | 1215 | 3023 | 12 | 613 | WZH59587.1 MAG: RNA-dependent RNA polymerase [Ripucork virus] | diamond | 1848 | 347 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Ripucork virus | |||
| 27152894 | 27152894 | PRJEB673_P_NODE_1822_length_716_cov_1.444934_g1574_i0 | PRJEB673 | 1822 | 716 | 1.444934 | 10.34572744 | Cripavirus | 144051 | Viruses | Viruses | 102 | 1.12e-20 | NR | NP_044946.1 | 64279 | g1574 | i0 | 44.8 | 2.47206703910615 | 116 | 63 | 48.2 | 1 | 163 | 507 | 16 | 131 | NP_044946.1 capsid polyprotein, partial [Drosophila C virus] | diamond | 1770 | 103 | 0.990291262135922 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 27160257 | 27160257 | PRJEB673_P_NODE_5322_length_387_cov_1.727273_g4973_i0 | PRJEB673 | 5322 | 387 | 1.727273 | 6.68454651 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 51.6 | 9.95e-5 | NR | DBA50496.1 | 3115894 | g4973 | i0 | 42.5 | 0.62015503875969 | 80 | 46 | 62 | 0 | 30 | 269 | 112 | 191 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 240 | 51.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28013469 | 28013469 | PRJEB673_P_NODE_8845_length_232_cov_1.086294_g8496_i0 | PRJEB673 | 8845 | 232 | 1.086294 | 2.52020208 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 49.3 | 1.33e-4 | NR | DBA50496.1 | 3115894 | g8496 | i0 | 68.8 | 0.413793103448276 | 32 | 10 | 41.4 | 0 | 229 | 134 | 177 | 208 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 96 | 49.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28708057 | 28708057 | PRJEB673_P_NODE_10567_length_172_cov_1.007299_g10218_i0 | PRJEB673 | 10567 | 172 | 1.007299 | 1.73255428 | Gremmeniella abietina RNA virus MS1 | 191436 | Viruses | Viruses | 68.9 | 1e-12 | NR | AII15934.1 | 191436 | g10218 | i0 | 51.8 | 1.95348837209302 | 56 | 27 | 97.7 | 0 | 172 | 5 | 40 | 95 | AII15934.1 RNA-dependent RNA polymerase, partial [Gremmeniella abietina RNA virus MS1] | diamond | 336 | 68.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus gremmeniellae | ||
| 28992383 | 28992383 | PRJEB673_P_NODE_4828_length_418_cov_2.574413_g4480_i0 | PRJEB673 | 4828 | 418 | 2.574413 | 10.76104634 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 139 | 8.47e-38 | NR | DBA50496.1 | 3115894 | g4480 | i0 | 55.1 | 0.990430622009569 | 138 | 62 | 99 | 0 | 2 | 415 | 63 | 200 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 414 | 139 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 29307756 | 29307756 | PRJEB673_P_NODE_2029_length_682_cov_2.284389_g1766_i0 | PRJEB673 | 2029 | 682 | 2.284389 | 15.57953298 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 261 | 6.750000000000001e-79 | NR | XCM68377.1 | 3003959 | g1766 | i0 | 58.7 | 7.95307917888563 | 225 | 92 | 98.5 | 1 | 6 | 677 | 260 | 484 | XCM68377.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 5424 | 261 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30160264 | 30160264 | PRJEB673_P_NODE_10352_length_176_cov_1.120567_g10003_i0 | PRJEB673 | 10352 | 176 | 1.120567 | 1.97219792 | Wilkie partiti-like virus 2 | 2010284 | Viruses | Viruses | 46.6 | 6.6e-4 | NR | YP_009388578.1 | 2010284 | g10003 | i0 | 32.8 | 1.96022727272727 | 58 | 39 | 98.9 | 0 | 175 | 2 | 373 | 430 | YP_009388578.1 RdRp [Wilkie partiti-like virus 2] | diamond | 345 | 46.6 | 1 | Viruses | Wilkie partiti-like virus 2 | ||||||||
| 30287308 | 30287308 | PRJEB673_P_NODE_9452_length_196_cov_5.186335_g9103_i0 | PRJEB673 | 9452 | 196 | 5.186335 | 10.1652166 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 63.5 | 4.78e-10 | NR | DBA50496.1 | 3115894 | g9103 | i0 | 51.6 | 0.979591836734694 | 64 | 31 | 98 | 0 | 194 | 3 | 123 | 186 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 192 | 63.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 30855548 | 30855548 | PRJEB673_P_NODE_8874_length_229_cov_1.201031_g8525_i0 | PRJEB673 | 8874 | 229 | 1.201031 | 2.75036099 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 74.3 | 5.33e-14 | NR | DAC81394.1 | 2609864 | g8525 | i0 | 55.3 | 0.995633187772926 | 76 | 34 | 99.6 | 0 | 228 | 1 | 58 | 133 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 228 | 74.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31139565 | 31139565 | PRJEB673_P_NODE_3515_length_532_cov_2.076459_g3194_i0 | PRJEB673 | 3515 | 532 | 2.076459 | 11.04676188 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 176 | 1.09e-50 | NR | DAC81401.1 | 2609864 | g3194 | i0 | 67.1 | 0.806390977443609 | 143 | 47 | 80.6 | 0 | 102 | 530 | 1 | 143 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 429 | 176 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31899034 | 31899034 | PRJEB673_P_NODE_12357_length_154_cov_1.462185_g12008_i0 | PRJEB673 | 12357 | 154 | 1.462185 | 2.2517649 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 67 | 1.14e-11 | NR | DAC81394.1 | 2609864 | g12008 | i0 | 65.3 | 0.954545454545455 | 49 | 17 | 95.5 | 0 | 2 | 148 | 164 | 212 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 147 | 67 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32752421 | 32752421 | PRJEB673_P_NODE_13060_length_150_cov_1.034783_g12711_i0 | PRJEB673 | 13060 | 150 | 1.034783 | 1.5521745 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 41.2 | 0.0383 | NR | ULF99807.1 | 1955144 | g12711 | i0 | 40.8 | 0.98 | 49 | 25 | 98 | 1 | 4 | 150 | 437 | 481 | ULF99807.1 MAG: putative replicase polyprotein, partial [Dicistroviridae sp.] | diamond | 147 | 41.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 32846794 | 32846794 | PRJEB673_P_NODE_20_length_3473_cov_3.276905_g0_i1 | PRJEB673 | 20 | 3473 | 3.276905 | 113.80691065 | Ripucork virus | 3130406 | Viruses | Viruses | 96.3 | 4.54e-16 | NR | WZH59589.1 | 3130406 | g0 | i1 | 25 | 0.43276706017852 | 501 | 334 | 41.7 | 17 | 1379 | 2827 | 37 | 513 | WZH59589.1 MAG: hypothetical protein [Ripucork virus] | diamond | 1503 | 96.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Ripucork virus | |||
| 32878312 | 32878312 | PRJEB673_P_NODE_11040_length_165_cov_3.907692_g10691_i0 | PRJEB673 | 11040 | 165 | 3.907692 | 6.4476918 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 52.4 | 7.05e-7 | NR | DAC81395.1 | 2609864 | g10691 | i0 | 62.3 | 0.963636363636364 | 53 | 20 | 96.4 | 0 | 161 | 3 | 1 | 53 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 159 | 52.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;