contig_metadata
19 rows where bioproject = "PRJNA908278" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7268534 | 7268534 | PRJNA908278_P_NODE_34026_length_242_cov_3.633136_g33923_i0 | PRJNA908278 | 34026 | 242 | 3.633136 | 8.79218912 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 231 | 2.6099999999999996e-56 | NTclustered | gi|1174571674|gb|KY684104.1| | 1977638 | g33923 | i0 | 84.1 | 137.570247933884 | 239 | 38 | 99 | 0 | 3 | 241 | 163444 | 163206 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence | blastn | 33292 | 231 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 7627177 | 7627177 | PRJNA908278_P_NODE_6826_length_451_cov_1.941799_g6723_i0 | PRJNA908278 | 6826 | 451 | 1.941799 | 8.75751349 | Prasinovirus | 181084 | Viruses | Viruses | 87.9 | 1.2e-12 | NTclustered | gi|2853279488|gb|PQ442268.1| | 3378364 | g6723 | i0 | 100 | 2.00886917960089 | 47 | 0 | 11 | 0 | 163 | 209 | 128840 | 128794 | Ostreococcus tauri virus 09-565, partial genome | blastn | 906 | 87.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Prasinovirus | Ostreococcus tauri virus 09-565 | ||
| 9818320 | 9818320 | PRJNA908278_P_NODE_6108_length_474_cov_15.047382_g6005_i0 | PRJNA908278 | 6108 | 474 | 15.047382 | 71.32459068 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 52.8 | 0.046 | NTclustered | gi|1512471777|gb|MK071987.1| | 2487775 | g6005 | i0 | 100 | 0.0590717299578059 | 28 | 0 | 6 | 0 | 207 | 234 | 37489 | 37462 | MAG: Terrestrivirus sp. clone Terrestrivirus_9 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 11093734 | 11093734 | PRJNA908278_P_NODE_10709_length_372_cov_1.454849_g10606_i0 | PRJNA908278 | 10709 | 372 | 1.454849 | 5.41203828 | Moumouvirus australiense | 3080759 | Viruses | Viruses | 62.1 | 5.88e-5 | NTclustered | gi|2500366567|ref|NC_075368.1| | 2109587 | g10606 | i0 | 91.111 | 0.120967741935484 | 45 | 4 | 12 | 0 | 156 | 200 | 466992 | 467036 | Moumouvirus australiensis isolate 10A, complete genome | blastn | 45 | 62.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus australiense | ||
| 22567537 | 22567537 | PRJNA908278_P_NODE_5878_length_484_cov_1.399027_g5775_i0 | PRJNA908278 | 5878 | 484 | 1.399027 | 6.77129068 | Chloriridovirus simulium1 | 3427924 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|589287691|ref|NC_023611.1| | 345585 | g5775 | i0 | 90.476 | 0.0867768595041322 | 42 | 4 | 9 | 0 | 117 | 158 | 177876 | 177835 | Invertebrate iridescent virus 30 complete genome | blastn | 42 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Chloriridovirus | Chloriridovirus simulium1 | ||
| 26834637 | 26834637 | PRJNA908278_P_NODE_3721_length_593_cov_2.115385_g3618_i0 | PRJNA908278 | 3721 | 593 | 2.115385 | 12.54423305 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 95.1 | 1.81e-20 | NR | AYV85215.1 | 2487771 | g3618 | i0 | 31.8 | 1.84148397976391 | 173 | 109 | 86.5 | 4 | 525 | 13 | 19 | 184 | AYV85215.1 MAG: START domain containing protein [Satyrvirus sp.] | diamond | 1092 | 95.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 27095049 | 27095049 | PRJNA908278_P_NODE_16242_length_314_cov_1.908714_g16139_i0 | PRJNA908278 | 16242 | 314 | 1.908714 | 5.99336196 | Mimiviridae | 549779 | Viruses | Viruses | 84 | 2.29e-17 | NR | ARF12537.1 | 1977640 | g16139 | i0 | 40.2 | 2.02547770700637 | 107 | 55 | 97.5 | 3 | 308 | 3 | 35 | 137 | ARF12537.1 hypothetical protein Klosneuvirus_6_99 [Klosneuvirus KNV1] | diamond | 636 | 84.3 | 0.99644128113879 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 27379782 | 27379782 | PRJNA908278_P_NODE_22263_length_275_cov_1.346535_g22160_i0 | PRJNA908278 | 22263 | 275 | 1.346535 | 3.70297125 | Mimiviridae | 549779 | Viruses | Viruses | 67.4 | 1.19e-10 | NR | YP_010841334.1 | 2811091 | g22160 | i0 | 47.4 | 5.08363636363636 | 76 | 34 | 79.6 | 3 | 223 | 5 | 1442 | 1514 | YP_010841334.1 putative serine/threonine-protein kinase [Cotonvirus japonicus] | diamond | 1398 | 67.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Cotonvirus | Cotonvirus japonicum | ||
| 27529946 | 27529946 | PRJNA908278_P_NODE_33503_length_243_cov_0.905882_g33400_i0 | PRJNA908278 | 33503 | 243 | 0.905882 | 2.20129326 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 83.6 | 1.55e-16 | NR | YP_010782648.1 | 2126985 | g33400 | i0 | 49.4 | 1 | 81 | 40 | 98.8 | 1 | 242 | 3 | 373 | 453 | YP_010782648.1 elongation factor 2 [Tupanvirus soda lake] | diamond | 243 | 83.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27782702 | 27782702 | PRJNA908278_P_NODE_35424_length_241_cov_0.916667_g35321_i0 | PRJNA908278 | 35424 | 241 | 0.916667 | 2.20916747 | Emiliania huxleyi virus 2 | 181208 | Viruses | Viruses | 120 | 5.799999999999999e-31 | NR | AET42571.1 | 181211 | g35321 | i0 | 68.4 | 1.96680497925311 | 79 | 25 | 98.3 | 0 | 239 | 3 | 151 | 229 | AET42571.1 fatty acid elongase [Emiliania huxleyi virus 202] | diamond | 474 | 120 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Coccolithovirus | Emiliania huxleyi virus 202 | ||
| 28224379 | 28224379 | PRJNA908278_P_NODE_26326_length_251_cov_1.297753_g26223_i0 | PRJNA908278 | 26326 | 251 | 1.297753 | 3.25736003 | European chub iridovirus | 2578140 | Viruses | Viruses | 51.6 | 2.14e-6 | NR | QCQ67839.1 | 2578140 | g26223 | i0 | 44.8 | 1.51792828685259 | 58 | 31 | 69.3 | 1 | 229 | 56 | 15 | 71 | QCQ67839.1 ubiquitin family protein [European chub iridovirus] | diamond | 381 | 51.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | European chub iridovirus | |||
| 28540564 | 28540564 | PRJNA908278_P_NODE_26027_length_253_cov_0.933333_g25924_i0 | PRJNA908278 | 26027 | 253 | 0.933333 | 2.36133249 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 78.6 | 1.05e-14 | NR | YP_010782648.1 | 2126985 | g25924 | i0 | 47 | 1.96837944664032 | 83 | 43 | 97.2 | 1 | 246 | 1 | 398 | 480 | YP_010782648.1 elongation factor 2 [Tupanvirus soda lake] | diamond | 498 | 78.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 29424184 | 29424184 | PRJNA908278_P_NODE_12109_length_354_cov_2.398577_g12006_i0 | PRJNA908278 | 12109 | 354 | 2.398577 | 8.49096258 | Megavirus haemonchus182742 | 3116716 | Viruses | Viruses | 87.8 | 2.15e-17 | NR | DBA45839.1 | 3116716 | g12006 | i0 | 54.4 | 0.669491525423729 | 79 | 35 | 66.9 | 1 | 109 | 345 | 21 | 98 | DBA45839.1 MAG TPA_asm: Kowoid2 [Megavirus haemonchus182742] | diamond | 237 | 87.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus haemonchus182742 | ||
| 29739890 | 29739890 | PRJNA908278_P_NODE_2850_length_667_cov_6.836700_g2747_i0 | PRJNA908278 | 2850 | 667 | 6.8367000000000004 | 45.600789 | Barrevirus sp. | 2487763 | Viruses | Viruses | 118 | 5.799999999999998e-29 | NR | AYV77273.1 | 2487763 | g2747 | i0 | 28.4 | 0.949025487256372 | 211 | 145 | 94 | 3 | 35 | 661 | 9 | 215 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 633 | 118 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 31351641 | 31351641 | PRJNA908278_P_NODE_14776_length_327_cov_1.212598_g14673_i0 | PRJNA908278 | 14776 | 327 | 1.212598 | 3.96519546 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 54.3 | 1.17e-6 | NR | QBK85646.1 | 2506602 | g14673 | i0 | 38.5 | 0.596330275229358 | 65 | 40 | 59.6 | 0 | 292 | 98 | 36 | 100 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 195 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 31984107 | 31984107 | PRJNA908278_P_NODE_22458_length_274_cov_1.144279_g22355_i0 | PRJNA908278 | 22458 | 274 | 1.144279 | 3.13532446 | Megavirus haemonchus182742 | 3116716 | Viruses | Viruses | 51.2 | 5.15e-5 | NR | DBA45825.1 | 3116716 | g22355 | i0 | 31.5 | 0.799270072992701 | 73 | 50 | 79.9 | 0 | 47 | 265 | 236 | 308 | DBA45825.1 MAG TPA_asm: Kowoid1 [Megavirus haemonchus182742] | diamond | 219 | 51.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus haemonchus182742 | ||
| 32679499 | 32679499 | PRJNA908278_P_NODE_2060_length_773_cov_2.760000_g1966_i0 | PRJNA908278 | 2060 | 773 | 2.76 | 21.3348 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 52 | 1.35e-4 | NR | QBK85646.1 | 2506602 | g1966 | i0 | 40 | 0.252263906856404 | 65 | 39 | 25.2 | 0 | 102 | 296 | 36 | 100 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 195 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 32711154 | 32711154 | PRJNA908278_P_NODE_15360_length_322_cov_1.236948_g15257_i0 | PRJNA908278 | 15360 | 322 | 1.236948 | 3.98297256 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 95.5 | 2.87e-20 | NR | AYV76311.1 | 2487775 | g15257 | i0 | 48.1 | 1.00621118012422 | 108 | 53 | 97.8 | 2 | 322 | 8 | 8 | 115 | AYV76311.1 MAG: hypothetical protein Terrestrivirus5_133 [Terrestrivirus sp.] | diamond | 324 | 95.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32900015 | 32900015 | PRJNA908278_P_NODE_16820_length_310_cov_1.299578_g16717_i0 | PRJNA908278 | 16820 | 310 | 1.299578 | 4.0286918 | Barrevirus sp. | 2487763 | Viruses | Viruses | 50.1 | 1.47e-4 | NR | AYV77273.1 | 2487763 | g16717 | i0 | 28.7 | 0.97741935483871 | 101 | 70 | 97.7 | 1 | 307 | 5 | 52 | 150 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 303 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus 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);;