contig_metadata
14 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;