contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26748802 | 26748802 | PRJEB673_P_NODE_9241_length_205_cov_1.141176_g8892_i0 | PRJEB673 | 9241 | 205 | 1.141176 | 2.3394108 | Adintovirus pavo15764 | 3115938 | Viruses | Viruses | 43.5 | 0.011 | NR | DBA50334.1 | 3115938 | g8892 | i0 | 45.5 | 0.64390243902439 | 44 | 24 | 64.4 | 0 | 164 | 33 | 214 | 257 | DBA50334.1 MAG TPA_asm: Penton [Adintovirus pavo15764] | diamond | 132 | 43.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus pavo15764 | |||
| 27160257 | 27160257 | PRJEB673_P_NODE_5322_length_387_cov_1.727273_g4973_i0 | PRJEB673 | 5322 | 387 | 1.727273 | 6.68454651 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 51.6 | 9.95e-5 | NR | DBA50496.1 | 3115894 | g4973 | i0 | 42.5 | 0.62015503875969 | 80 | 46 | 62 | 0 | 30 | 269 | 112 | 191 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 240 | 51.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28013469 | 28013469 | PRJEB673_P_NODE_8845_length_232_cov_1.086294_g8496_i0 | PRJEB673 | 8845 | 232 | 1.086294 | 2.52020208 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 49.3 | 1.33e-4 | NR | DBA50496.1 | 3115894 | g8496 | i0 | 68.8 | 0.413793103448276 | 32 | 10 | 41.4 | 0 | 229 | 134 | 177 | 208 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 96 | 49.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28992383 | 28992383 | PRJEB673_P_NODE_4828_length_418_cov_2.574413_g4480_i0 | PRJEB673 | 4828 | 418 | 2.574413 | 10.76104634 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 139 | 8.47e-38 | NR | DBA50496.1 | 3115894 | g4480 | i0 | 55.1 | 0.990430622009569 | 138 | 62 | 99 | 0 | 2 | 415 | 63 | 200 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 414 | 139 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 30287308 | 30287308 | PRJEB673_P_NODE_9452_length_196_cov_5.186335_g9103_i0 | PRJEB673 | 9452 | 196 | 5.186335 | 10.1652166 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 63.5 | 4.78e-10 | NR | DBA50496.1 | 3115894 | g9103 | i0 | 51.6 | 0.979591836734694 | 64 | 31 | 98 | 0 | 194 | 3 | 123 | 186 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 192 | 63.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 30855548 | 30855548 | PRJEB673_P_NODE_8874_length_229_cov_1.201031_g8525_i0 | PRJEB673 | 8874 | 229 | 1.201031 | 2.75036099 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 74.3 | 5.33e-14 | NR | DAC81394.1 | 2609864 | g8525 | i0 | 55.3 | 0.995633187772926 | 76 | 34 | 99.6 | 0 | 228 | 1 | 58 | 133 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 228 | 74.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31139565 | 31139565 | PRJEB673_P_NODE_3515_length_532_cov_2.076459_g3194_i0 | PRJEB673 | 3515 | 532 | 2.076459 | 11.04676188 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 176 | 1.09e-50 | NR | DAC81401.1 | 2609864 | g3194 | i0 | 67.1 | 0.806390977443609 | 143 | 47 | 80.6 | 0 | 102 | 530 | 1 | 143 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 429 | 176 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31899034 | 31899034 | PRJEB673_P_NODE_12357_length_154_cov_1.462185_g12008_i0 | PRJEB673 | 12357 | 154 | 1.462185 | 2.2517649 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 67 | 1.14e-11 | NR | DAC81394.1 | 2609864 | g12008 | i0 | 65.3 | 0.954545454545455 | 49 | 17 | 95.5 | 0 | 2 | 148 | 164 | 212 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 147 | 67 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32878312 | 32878312 | PRJEB673_P_NODE_11040_length_165_cov_3.907692_g10691_i0 | PRJEB673 | 11040 | 165 | 3.907692 | 6.4476918 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 52.4 | 7.05e-7 | NR | DAC81395.1 | 2609864 | g10691 | i0 | 62.3 | 0.963636363636364 | 53 | 20 | 96.4 | 0 | 161 | 3 | 1 | 53 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 159 | 52.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;