contig_metadata
20 rows where bioproject = "PRJNA1148190" and tax_clade = "Pithoviruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9228159 | 9228159 | PRJNA1148190_P_NODE_784628_length_241_cov_0.916667_g773455_i0 | PRJNA1148190 | 784628 | 241 | 0.916667 | 2.20916747 | Pithovirus LCPAC4 | 2506596 | Viruses | Viruses | 58.5 | 1.01e-7 | NR | QBK93150.1 | 2506596 | g773455 | i0 | 39.7 | 0.846473029045643 | 68 | 41 | 84.6 | 0 | 2 | 205 | 501 | 568 | QBK93150.1 MAG: DNA-directed RNA polymerase subunit beta [Pithovirus LCPAC403] | diamond | 204 | 58.5 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC403 | |||||||
| 13044926 | 13044926 | PRJNA1148190_P_NODE_151691_length_427_cov_1.305085_g140524_i0 | PRJNA1148190 | 151691 | 427 | 1.305085 | 5.57271295 | Solivirus sp. | 2487772 | Viruses | Viruses | 52.8 | 0.041 | NTclustered | gi|1512481561|gb|MK072489.1| | 2487772 | g140524 | i0 | 100 | 0.0655737704918033 | 28 | 0 | 7 | 0 | 70 | 97 | 15250 | 15223 | MAG: Solivirus sp. clone Solivirus_1 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Pithoviruses | Solivirus sp. | |||||||
| 24518545 | 24518545 | PRJNA1148190_P_NODE_231780_length_354_cov_1.096085_g220610_i0 | PRJNA1148190 | 231780 | 354 | 1.096085 | 3.8801409 | Pithovirus LCPAC001 | 2506585 | Viruses | Viruses | 58.4 | 7.2e-4 | NTclustered | gi|1588063028|gb|MK500429.1| | 2506585 | g220610 | i0 | 100 | 0.488700564971751 | 31 | 0 | 9 | 0 | 210 | 240 | 1620 | 1650 | MAG: Pithovirus LCPAC001 genomic sequence | blastn | 173 | 58.4 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC001 | |||||||
| 26755021 | 26755021 | PRJNA1148190_P_NODE_767201_length_242_cov_0.911243_g756028_i0 | PRJNA1148190 | 767201 | 242 | 0.911243 | 2.20520806 | Solumvirus sp. | 2487773 | Viruses | Viruses | 74.3 | 1.79e-13 | NR | AYV86388.1 | 2487773 | g756028 | i0 | 43.8 | 0.90495867768595 | 73 | 37 | 90.5 | 1 | 1 | 219 | 151 | 219 | AYV86388.1 MAG: class II apurinic/apyrimidinic(AP)-endonuclease [Solumvirus sp.] | diamond | 219 | 74.3 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 26881249 | 26881249 | PRJNA1148190_P_NODE_290881_length_324_cov_0.920319_g279710_i0 | PRJNA1148190 | 290881 | 324 | 0.920319 | 2.98183356 | Pithovirus LCPAC3 | 2506593 | Viruses | Viruses | 141 | 4.59e-39 | NR | QBK91403.1 | 2506593 | g279710 | i0 | 55.1 | 0.990740740740741 | 107 | 47 | 98.1 | 1 | 324 | 7 | 96 | 202 | QBK91403.1 MAG: 5' nucleotidase, partial [Pithovirus LCPAC302] | diamond | 321 | 141 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC302 | |||||||
| 27639454 | 27639454 | PRJNA1148190_P_NODE_10204_length_3217_cov_19.753181_g1654_i4 | PRJNA1148190 | 10204 | 3217 | 19.753181 | 635.45983277 | Pithovirus LCPAC3 | 2506594 | Viruses | Viruses | 107 | 2.3100000000000003e-21 | NR | QBK91826.1 | 2506594 | g1654 | i4 | 31.9 | 0.245259558594964 | 263 | 159 | 23.6 | 11 | 2202 | 1444 | 33 | 285 | QBK91826.1 MAG: class 3 lipase [Pithovirus LCPAC304] | diamond | 789 | 107 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC304 | |||||||
| 27765995 | 27765995 | PRJNA1148190_P_NODE_216484_length_364_cov_1.323024_g205314_i0 | PRJNA1148190 | 216484 | 364 | 1.323024 | 4.81580736 | Pithovirus LCPAC3 | 2506593 | Viruses | Viruses | 113 | 2.25e-26 | NR | QBK91462.1 | 2506593 | g205314 | i0 | 41.6 | 1.03021978021978 | 125 | 68 | 98.9 | 1 | 3 | 362 | 1025 | 1149 | QBK91462.1 MAG: DNA polymerase elongation subunit family B [Pithovirus LCPAC302] | diamond | 375 | 113 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC302 | |||||||
| 27987916 | 27987916 | PRJNA1148190_P_NODE_9365_length_3458_cov_5.146529_g4740_i0 | PRJNA1148190 | 9365 | 3458 | 5.146529 | 177.96697282 | Cedratvirus A11 | 1903266 | Viruses | Viruses | 52 | 0.0167 | NR | YP_009329287.1 | 1903266 | g4740 | i0 | 37 | 0.0633314054366686 | 73 | 40 | 6.1 | 3 | 2926 | 2717 | 92 | 161 | YP_009329287.1 Ankyrin repeat-containing domain [Cedratvirus A11] | diamond | 219 | 52 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus aljazairmassiliense | ||||||
| 28207495 | 28207495 | PRJNA1148190_P_NODE_12966_length_2653_cov_21.581395_g300_i36 | PRJNA1148190 | 12966 | 2653 | 21.581395 | 572.55440935 | Solumvirus sp. | 2487773 | Viruses | Viruses | 92 | 1.95e-17 | NR | AYV86205.1 | 2487773 | g300 | i36 | 51.9 | 0.0893328307576329 | 79 | 38 | 8.9 | 0 | 592 | 828 | 52 | 130 | AYV86205.1 MAG: hypothetical protein Solumvirus2_12 [Solumvirus sp.] | diamond | 237 | 92 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 28208577 | 28208577 | PRJNA1148190_P_NODE_749866_length_243_cov_0.905882_g738693_i0 | PRJNA1148190 | 749866 | 243 | 0.905882 | 2.20129326 | Solivirus sp. | 2487772 | Viruses | Viruses | 50.8 | 5.16e-5 | NR | AYV85864.1 | 2487772 | g738693 | i0 | 49.2 | 0.802469135802469 | 65 | 23 | 77.8 | 2 | 3 | 191 | 165 | 221 | AYV85864.1 MAG: hypothetical protein Solivirus1_21 [Solivirus sp.] | diamond | 195 | 50.8 | 1 | Viruses | Pithoviruses | Solivirus sp. | |||||||
| 28271353 | 28271353 | PRJNA1148190_P_NODE_562186_length_254_cov_3.248619_g551013_i0 | PRJNA1148190 | 562186 | 254 | 3.248619 | 8.25149226 | Pithovirus LCPAC1 | 2506587 | Viruses | Viruses | 48.1 | 5.41e-5 | NR | QBK90301.1 | 2506587 | g551013 | i0 | 36.8 | 0.673228346456693 | 57 | 36 | 67.3 | 0 | 83 | 253 | 2 | 58 | QBK90301.1 MAG: hypothetical protein LCPAC102_02140 [Pithovirus LCPAC102] | diamond | 171 | 48.1 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC102 | |||||||
| 28398280 | 28398280 | PRJNA1148190_P_NODE_95986_length_547_cov_1.928270_g84837_i0 | PRJNA1148190 | 95986 | 547 | 1.92827 | 10.5476369 | Pithovirus LCPAC4 | 2506597 | Viruses | Viruses | 183 | 1.54e-54 | NR | QBK93533.1 | 2506597 | g84837 | i0 | 50.5 | 1.0091407678245 | 184 | 85 | 99.8 | 2 | 547 | 2 | 74 | 253 | QBK93533.1 MAG: uncharacterized protein LCPAC404_02370 [Pithovirus LCPAC404] | diamond | 552 | 183 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC404 | |||||||
| 28587936 | 28587936 | PRJNA1148190_P_NODE_9947_length_3288_cov_18.099844_g1654_i3 | PRJNA1148190 | 9947 | 3288 | 18.099844 | 595.12287072 | Pithovirus LCPAC3 | 2506594 | Viruses | Viruses | 107 | 2.3700000000000003e-21 | NR | QBK91826.1 | 2506594 | g1654 | i3 | 31.9 | 0.239963503649635 | 263 | 159 | 23.1 | 11 | 2280 | 1522 | 33 | 285 | QBK91826.1 MAG: class 3 lipase [Pithovirus LCPAC304] | diamond | 789 | 107 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC304 | |||||||
| 28682524 | 28682524 | PRJNA1148190_P_NODE_72067_length_654_cov_1.679862_g60975_i0 | PRJNA1148190 | 72067 | 654 | 1.679862 | 10.98629748 | Pithovirus LCPAC3 | 2506594 | Viruses | Viruses | 98.6 | 1.11e-21 | NR | QBK91948.1 | 2506594 | g60975 | i0 | 38.2 | 0.81651376146789 | 178 | 80 | 81.2 | 4 | 652 | 122 | 31 | 179 | QBK91948.1 MAG: hypothetical protein LCPAC304_02900 [Pithovirus LCPAC304] | diamond | 534 | 98.6 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC304 | |||||||
| 31714603 | 31714603 | PRJNA1148190_P_NODE_3737_length_6855_cov_20.185638_g300_i18 | PRJNA1148190 | 3737 | 6855 | 20.185638 | 1383.7254849 | Solumvirus sp. | 2487773 | Viruses | Viruses | 91.7 | 7.42e-17 | NR | AYV86205.1 | 2487773 | g300 | i18 | 51.9 | 0.0695842450765864 | 79 | 38 | 3.5 | 0 | 4794 | 5030 | 52 | 130 | AYV86205.1 MAG: hypothetical protein Solumvirus2_12 [Solumvirus sp.] | diamond | 477 | 91.7 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 31967559 | 31967559 | PRJNA1148190_P_NODE_3738_length_6855_cov_19.861103_g300_i19 | PRJNA1148190 | 3738 | 6855 | 19.861103 | 1361.47861065 | Solumvirus sp. | 2487773 | Viruses | Viruses | 92.4 | 4e-17 | NR | AYV86205.1 | 2487773 | g300 | i19 | 51.9 | 0.0695842450765864 | 79 | 38 | 3.5 | 0 | 4794 | 5030 | 52 | 130 | AYV86205.1 MAG: hypothetical protein Solumvirus2_12 [Solumvirus sp.] | diamond | 477 | 92.4 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 32031797 | 32031797 | PRJNA1148190_P_NODE_8278_length_3811_cov_18.365436_g300_i23 | PRJNA1148190 | 8278 | 3811 | 18.365436 | 699.90676596 | Solumvirus sp. | 2487773 | Viruses | Viruses | 66.6 | 2e-8 | NR | AYV86205.1 | 2487773 | g300 | i23 | 50.8 | 0.0464445027551824 | 59 | 29 | 4.6 | 0 | 179 | 3 | 52 | 110 | AYV86205.1 MAG: hypothetical protein Solumvirus2_12 [Solumvirus sp.] | diamond | 177 | 66.6 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 32062981 | 32062981 | PRJNA1148190_P_NODE_646278_length_248_cov_0.880000_g635105_i0 | PRJNA1148190 | 646278 | 248 | 0.88 | 2.1824 | Pithovirus LCPAC3 | 2506594 | Viruses | Viruses | 60.1 | 3.13e-8 | NR | QBK92355.1 | 2506594 | g635105 | i0 | 42.3 | 0.943548387096774 | 78 | 20 | 94.4 | 1 | 15 | 248 | 300 | 352 | QBK92355.1 MAG: DEAD-like helicase family protein [Pithovirus LCPAC304] | diamond | 234 | 60.1 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC304 | |||||||
| 32094973 | 32094973 | PRJNA1148190_P_NODE_8318_length_3798_cov_3.718389_g4112_i0 | PRJNA1148190 | 8318 | 3798 | 3.718389 | 141.22441422 | Pithovirus LCPAC3 | 2506593 | Viruses | Viruses | 363 | 2.43e-112 | NR | QBK91403.1 | 2506593 | g4112 | i0 | 62.1 | 0.206161137440758 | 261 | 98 | 20.5 | 1 | 639 | 1418 | 2 | 262 | QBK91403.1 MAG: 5' nucleotidase, partial [Pithovirus LCPAC302] | diamond | 783 | 363 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC302 | |||||||
| 32789377 | 32789377 | PRJNA1148190_P_NODE_555420_length_256_cov_1.295082_g544247_i0 | PRJNA1148190 | 555420 | 256 | 1.295082 | 3.31540992 | Pithovirus sibericum | 1450746 | Viruses | Viruses | 76.6 | 5.24e-14 | NR | YP_009001040.1 | 1450746 | g544247 | i0 | 44.3 | 0.92578125 | 79 | 44 | 92.6 | 0 | 255 | 19 | 911 | 989 | YP_009001040.1 DNA topoisomerase II [Pithovirus sibericum] | diamond | 237 | 76.6 | 1 | Viruses | Pithoviruses | Alphapithovirus | Alphapithovirus sibericum |
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);;