contig_metadata
23 rows where analysis = "blastn" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 363482 | 363482 | PRJNA1262902_P_NODE_11701_length_242_cov_0.911243_g11659_i0 | PRJNA1262902 | 11701 | 242 | 0.911243 | 2.20520806 | Pithovirus LCDPAC02 | 2506601 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1588058210|gb|MK500300.1| | 2506601 | g11659 | i0 | 94.286 | 0.144628099173554 | 35 | 1 | 14 | 1 | 13 | 47 | 67448 | 67415 | MAG: Pithovirus LCDPAC02 genomic sequence | blastn | 35 | 52.8 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC02 | |||||||
| 748097 | 748097 | PRJNA772761_S_NODE_29761_length_285_cov_1.452830_g29701_i0 | PRJNA772761 | 29761 | 285 | 1.45283 | 4.1405655 | Pithovirus LCPAC202 | 2506592 | Viruses | Viruses | 73.1 | 2.02e-8 | NTclustered | gi|1588064638|gb|MK500511.1| | 2506592 | g29701 | i0 | 92.157 | 0.733333333333333 | 51 | 4 | 18 | 0 | 90 | 140 | 7196 | 7246 | MAG: Pithovirus LCPAC202 genomic sequence | blastn | 209 | 73.1 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC202 | |||||||
| 4394636 | 4394636 | PRJNA594101_S_NODE_32904_length_300_cov_1.726872_g32602_i0 | PRJNA594101 | 32904 | 300 | 1.726872 | 5.180616 | Pithovirus LCDPAC01 | 2506600 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|1588058088|gb|MK500295.1| | 2506600 | g32602 | i0 | 100 | 0.186666666666667 | 28 | 0 | 9 | 0 | 148 | 175 | 1296 | 1269 | MAG: Pithovirus LCDPAC01 genomic sequence | blastn | 56 | 52.8 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 4483448 | 4483448 | PRJNA681822_P_NODE_417804_length_248_cov_0.880000_g416315_i0 | PRJNA681822 | 417804 | 248 | 0.88 | 2.1824 | Pithovirus LCPAC302 | 2506593 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1588065187|gb|MK500554.1| | 2506593 | g416315 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 54 | 81 | 589 | 562 | MAG: Pithovirus LCPAC302 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC302 | |||||||
| 7278025 | 7278025 | PRJNA925434_P_NODE_32486_length_235_cov_2.302469_g32328_i0 | PRJNA925434 | 32486 | 235 | 2.302469 | 5.41080215 | Pithovirus LCDPAC01 | 2506600 | Viruses | Viruses | 145 | 3.38e-30 | NTclustered | gi|1588057981|gb|MK500285.1| | 2506600 | g32328 | i0 | 84.314 | 0.876595744680851 | 153 | 18 | 64 | 6 | 1 | 150 | 175 | 26 | MAG: Pithovirus LCDPAC01 genomic sequence | blastn | 206 | 145 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 9829607 | 9829607 | PRJNA927284_P_NODE_1328_length_650_cov_3.607085_g1180_i0 | PRJNA927284 | 1328 | 650 | 3.607085 | 23.4460525 | Pithovirus LCPAC102 | 2506587 | Viruses | Viruses | 73.1 | 4.96e-8 | NTclustered | gi|1588063743|gb|MK500471.1| | 2506587 | g1180 | i0 | 97.619 | 0.250769230769231 | 42 | 1 | 6 | 0 | 519 | 560 | 12795 | 12836 | MAG: Pithovirus LCPAC102 genomic sequence | blastn | 163 | 73.1 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC102 | |||||||
| 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. | |||||||
| 13172236 | 13172236 | PRJNA408129_S_NODE_33551_length_153_cov_2.336207_g33533_i0 | PRJNA408129 | 33551 | 153 | 2.336207 | 3.57439671 | Alphapithovirus sibericum | 3426242 | Viruses | Viruses | 233 | 4.17e-57 | NTclustered | gi|585299329|ref|NC_023423.1| | 1450746 | g33533 | i0 | 99.225 | 1.68627450980392 | 129 | 1 | 84 | 0 | 25 | 153 | 298932 | 298804 | Pithovirus sibericum isolate P1084-T, complete genome | blastn | 258 | 233 | 1 | Viruses | Pithoviruses | Alphapithovirus | Alphapithovirus sibericum | ||||||
| 13578605 | 13578605 | PRJNA834970_P_NODE_31791_length_246_cov_0.890173_g31760_i0 | PRJNA834970 | 31791 | 246 | 0.890173 | 2.18982558 | Pithovirus LCPAC101 | 2506586 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1588063306|gb|MK500443.1| | 2506586 | g31760 | i0 | 90.909 | 0.178861788617886 | 44 | 0 | 16 | 4 | 58 | 97 | 18925 | 18882 | MAG: Pithovirus LCPAC101 genomic sequence | blastn | 44 | 56.5 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 | |||||||
| 15786828 | 15786828 | PRJNA506002_S_NODE_61213_length_246_cov_0.890173_g60967_i0 | PRJNA506002 | 61213 | 246 | 0.890173 | 2.18982558 | Pithovirus LCDPAC02 | 2506601 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1588058287|gb|MK500301.1| | 2506601 | g60967 | i0 | 94.595 | 0.150406504065041 | 37 | 1 | 15 | 1 | 73 | 108 | 55583 | 55547 | MAG: Pithovirus LCDPAC02 genomic sequence | blastn | 37 | 56.5 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC02 | |||||||
| 18454294 | 18454294 | PRJNA630162_P_NODE_39755_length_282_cov_3.090129_g38232_i0 | PRJNA630162 | 39755 | 282 | 3.090129 | 8.71416378 | Pithovirus LCDPAC01 | 2506600 | Viruses | Viruses | 106 | 1.97e-18 | NTclustered | gi|1588057929|gb|MK500282.1| | 2506600 | g38232 | i0 | 87.097 | 2.35106382978723 | 93 | 12 | 46 | 0 | 178 | 270 | 17695 | 17787 | MAG: Pithovirus LCDPAC01 genomic sequence | blastn | 663 | 106 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 19634417 | 19634417 | PRJNA540466_S_NODE_7316_length_598_cov_2.516190_g6841_i0 | PRJNA540466 | 7316 | 598 | 2.51619 | 15.0468162 | Pithovirus LCPAC202 | 2506592 | Viruses | Viruses | 69.4 | 5.88e-7 | NTclustered | gi|1588064638|gb|MK500511.1| | 2506592 | g6841 | i0 | 87.302 | 0.474916387959866 | 63 | 5 | 10 | 2 | 323 | 382 | 7252 | 7190 | MAG: Pithovirus LCPAC202 genomic sequence | blastn | 284 | 69.4 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC202 | |||||||
| 21698237 | 21698237 | PRJEB14803_P_NODE_45478_length_154_cov_1.000000_g45012_i0 | PRJEB14803 | 45478 | 154 | 1 | 1.54 | Pithovirus LCPAC103 | 2506588 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1588063838|gb|MK500478.1| | 2506588 | g45012 | i0 | 96.875 | 0.207792207792208 | 32 | 1 | 21 | 0 | 5 | 36 | 5112 | 5143 | MAG: Pithovirus LCPAC103 genomic sequence | blastn | 32 | 54.7 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC103 | |||||||
| 23554951 | 23554951 | PRJNA630162_P_NODE_48699_length_253_cov_1.000000_g47176_i0 | PRJNA630162 | 48699 | 253 | 1 | 2.53 | Pithovirus LCDPAC01 | 2506600 | Viruses | Viruses | 117 | 8.03e-22 | NTclustered | gi|1588057929|gb|MK500282.1| | 2506600 | g47176 | i0 | 87.379 | 1.48221343873518 | 103 | 11 | 42 | 2 | 1 | 102 | 17683 | 17784 | MAG: Pithovirus LCDPAC01 genomic sequence | blastn | 375 | 117 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 24483322 | 24483322 | PRJNA1120060_P_NODE_2927280_length_243_cov_1.270588_g2909187_i0 | PRJNA1120060 | 2927280 | 243 | 1.270588 | 3.08752884 | Pithovirus LCPAC102 | 2506587 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1588063662|gb|MK500468.1| | 2506587 | g2909187 | i0 | 94.286 | 0.1440329218107 | 35 | 1 | 14 | 1 | 205 | 239 | 11189 | 11156 | MAG: Pithovirus LCPAC102 genomic sequence | blastn | 35 | 52.8 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC102 | |||||||
| 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 | |||||||
| 24584874 | 24584874 | PRJNA1249535_S_NODE_57980_length_452_cov_1.675462_g54615_i0 | PRJNA1249535 | 57980 | 452 | 1.675462 | 7.57308824 | Pithovirus LCPAC101 | 2506586 | Viruses | Viruses | 52.8 | 0.044 | NTclustered | gi|1588063546|gb|MK500461.1| | 2506586 | g54615 | i0 | 100 | 0.0619469026548673 | 28 | 0 | 6 | 0 | 226 | 253 | 566 | 593 | MAG: Pithovirus LCPAC101 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 | |||||||
| 25061132 | 25061132 | PRJNA849172_P_NODE_130380_length_220_cov_30.047619_g130020_i0 | PRJNA849172 | 130380 | 220 | 30.047619 | 66.1047618 | Pithovirus LCPAC001 | 2506585 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1588063028|gb|MK500429.1| | 2506585 | g130020 | i0 | 100 | 0.131818181818182 | 29 | 0 | 13 | 0 | 44 | 72 | 2356 | 2328 | MAG: Pithovirus LCPAC001 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC001 | |||||||
| 25947075 | 25947075 | PRJNA1233465b_S_NODE_291932_length_177_cov_1.593750_g290247_i0 | PRJNA1233465 | 291932 | 177 | 1.59375 | 2.8209375 | Brazilian cedratvirus IHUMI | 2126980 | Viruses | Viruses | 165 | 1.84e-36 | NTclustered | gi|1379008795|emb|LT994651.1| | 2126980 | g290247 | i0 | 87.261 | 0.88700564971751406 | 157 | 5 | 89 | 5 | 14 | 170 | 86675 | 86534 | Brazilian cedratvirus IHUMI strain IHUMI-27.7 genome assembly, chromosome: scaffold_1 | blastn | 157 | 165 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus brasiliense | ||||||
| 25948873 | 25948873 | PRJNA1233465b_S_NODE_82876_length_295_cov_1.028455_g81191_i0 | PRJNA1233465 | 82876 | 295 | 1.028455 | 3.03394225 | Brazilian cedratvirus IHUMI | 2126980 | Viruses | Viruses | 416 | 8.429999999999998e-112 | NTclustered | gi|1379008795|emb|LT994651.1| | 2126980 | g81191 | i0 | 92.44 | 0.986440677966102 | 291 | 22 | 99 | 0 | 3 | 293 | 69360 | 69650 | Brazilian cedratvirus IHUMI strain IHUMI-27.7 genome assembly, chromosome: scaffold_1 | blastn | 291 | 416 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus brasiliense | ||||||
| 26081637 | 26081637 | PRJNA1233465b_S_NODE_185133_length_216_cov_1.832335_g183448_i0 | PRJNA1233465 | 185133 | 216 | 1.832335 | 3.9578436 | Brazilian cedratvirus IHUMI | 2126980 | Viruses | Viruses | 137 | 5.119999999999999e-28 | NTclustered | gi|1379008795|emb|LT994651.1| | 2126980 | g183448 | i0 | 91.089 | 2.7037037037037 | 101 | 9 | 47 | 0 | 115 | 215 | 137743 | 137843 | Brazilian cedratvirus IHUMI strain IHUMI-27.7 genome assembly, chromosome: scaffold_1 | blastn | 584 | 137 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus brasiliense | ||||||
| 26352928 | 26352928 | PRJNA1233465b_S_NODE_127895_length_251_cov_1.514851_g126210_i0 | PRJNA1233465 | 127895 | 251 | 1.514851 | 3.80227601 | Cedratvirus A11 | 1903266 | Viruses | Viruses | 268 | 2.07e-67 | NTclustered | gi|1115260653|ref|NC_032108.1| | 1903266 | g126210 | i0 | 88.053 | 4.37848605577689 | 226 | 27 | 90 | 0 | 1 | 226 | 148478 | 148703 | Cedratvirus A11 genome assembly, complete genome: monopartite | blastn | 1099 | 268 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus aljazairmassiliense | ||||||
| 26493381 | 26493381 | PRJNA1233465b_S_NODE_91616_length_284_cov_2.378723_g89931_i0 | PRJNA1233465 | 91616 | 284 | 2.378723 | 6.75557332 | Cedratvirus borely | 3032482 | Viruses | Viruses | 388 | 1.7599999999999998e-103 | NTclustered | gi|2514762215|gb|OQ413575.1| | 3032482 | g89931 | i0 | 96.596 | 4.17957746478873 | 235 | 7 | 83 | 1 | 1 | 235 | 73057 | 72824 | Cedratvirus borely strain AA, complete genome | blastn | 1187 | 388 | 1 | Viruses | Pithoviruses | Cedratvirus borely |
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);;