contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26767444 | 26767444 | PRJNA725806_P_NODE_78141_length_215_cov_3.893258_g77840_i0 | PRJNA725806 | 78141 | 215 | 3.893258 | 8.3705047 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 73.9 | 1.63e-13 | NR | XNL98191.1 | 3394651 | g77840 | i0 | 76.9 | 0.544186046511628 | 39 | 9 | 54.4 | 0 | 137 | 21 | 11 | 49 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 117 | 73.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 27652696 | 27652696 | PRJNA725806_P_NODE_3924_length_469_cov_2.379630_g3655_i0 | PRJNA725806 | 3924 | 469 | 2.37963 | 11.1604647 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 180 | 6.42e-53 | NR | XNL98191.1 | 3394651 | g3655 | i0 | 67 | 0.735607675906183 | 115 | 38 | 73.6 | 0 | 378 | 34 | 119 | 233 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 345 | 180 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 28157966 | 28157966 | PRJNA725806_P_NODE_143885_length_171_cov_7.723881_g143583_i0 | PRJNA725806 | 143885 | 171 | 7.723881 | 13.20783651 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 52 | 7.27e-6 | NR | XNL98191.1 | 3394651 | g143583 | i0 | 54.5 | 1.47368421052632 | 33 | 15 | 57.9 | 0 | 53 | 151 | 270 | 302 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 252 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 28347159 | 28347159 | PRJNA725806_P_NODE_89126_length_205_cov_9.910714_g88824_i0 | PRJNA725806 | 89126 | 205 | 9.910714 | 20.3169637 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 44.3 | 0.00646 | NR | DBA46921.1 | 3115887 | g88824 | i0 | 61.3 | 0.878048780487805 | 31 | 12 | 45.4 | 0 | 5 | 97 | 381 | 411 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 180 | 44.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 29231369 | 29231369 | PRJNA725806_P_NODE_112689_length_188_cov_13.105960_g112387_i0 | PRJNA725806 | 112689 | 188 | 13.10596 | 24.6392048 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 63.9 | 4.98e-10 | NR | XNL98191.1 | 3394651 | g112387 | i0 | 52.9 | 0.813829787234043 | 51 | 22 | 78.2 | 1 | 148 | 2 | 270 | 320 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 153 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 29578324 | 29578324 | PRJNA725806_P_NODE_8610_length_389_cov_3.838068_g8325_i0 | PRJNA725806 | 8610 | 389 | 3.838068 | 14.93008452 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 65.9 | 1.39e-9 | NR | DBA48451.1 | 3115912 | g8325 | i0 | 52.1 | 0.370179948586118 | 48 | 23 | 37 | 0 | 162 | 19 | 6 | 53 | DBA48451.1 MAG TPA_asm: Hexon [Adintovirus homo3309] | diamond | 144 | 65.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 | |||
| 30020839 | 30020839 | PRJNA725806_P_NODE_138271_length_174_cov_4.204380_g137969_i0 | PRJNA725806 | 138271 | 174 | 4.20438 | 7.3156212 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 66.6 | 4.47e-11 | NR | XNL98191.1 | 3394651 | g137969 | i0 | 53.1 | 0.844827586206897 | 49 | 23 | 84.5 | 0 | 13 | 159 | 273 | 321 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 147 | 66.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 30368693 | 30368693 | PRJNA725806_P_NODE_8712_length_388_cov_2.444444_g8427_i0 | PRJNA725806 | 8712 | 388 | 2.444444 | 9.48444272 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 154 | 2.3299999999999993e-42 | NR | DBA46921.1 | 3115887 | g8427 | i0 | 58.9 | 1.91752577319588 | 124 | 51 | 95.9 | 0 | 1 | 372 | 262 | 385 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 744 | 154 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 30494749 | 30494749 | PRJNA725806_P_NODE_82833_length_211_cov_2.247126_g82532_i0 | PRJNA725806 | 82833 | 211 | 2.247126 | 4.74143586 | Cafeteria roenbergensis virus BV-PW1 | 693272 | Viruses | Viruses | 43.1 | 0.0173 | NR | YP_003969900.1 | 693272 | g82532 | i0 | 39.6 | 0.753554502369668 | 53 | 30 | 72.5 | 1 | 48 | 200 | 182 | 234 | YP_003969900.1 hypothetical protein crov268 [Cafeteria roenbergensis virus BV-PW1] | diamond | 159 | 43.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Rheavirus | Rheavirus sinusmexicani | ||
| 31980371 | 31980371 | PRJNA725806_P_NODE_111498_length_189_cov_5.940789_g111196_i0 | PRJNA725806 | 111498 | 189 | 5.940789 | 11.22809121 | Megastigmus wasp adintovirus | 2609859 | Viruses | Viruses | 45.1 | 0.00279 | NR | DAC81331.1 | 2609859 | g111196 | i0 | 57.1 | 0.555555555555556 | 35 | 15 | 55.6 | 0 | 182 | 78 | 232 | 266 | DAC81331.1 TPA_asm: PolB [Megastigmus wasp adintovirus] | diamond | 105 | 45.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Megastigmus wasp adintovirus | |||
| 32644286 | 32644286 | PRJNA725806_P_NODE_92120_length_203_cov_3.843373_g91818_i0 | PRJNA725806 | 92120 | 203 | 3.843373 | 7.80204719 | Adintovirus tuber11 | 3115950 | Viruses | Viruses | 61.2 | 6.03e-9 | NR | DBA47561.1 | 3115950 | g91818 | i0 | 52.3 | 1.71428571428571 | 65 | 26 | 91.6 | 2 | 187 | 2 | 285 | 347 | DBA47561.1 MAG TPA_asm: Adintoc3 [Adintovirus tuber11084] | diamond | 348 | 61.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus tuber11084 |
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);;