contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1020854" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18013162 | 18013162 | PRJNA1020854_S_NODE_7735_length_532_cov_1177.351889_g5096_i0 | PRJNA1020854 | 7735 | 532 | 1177.351889 | 6263.51204948 | Archaea | 2157 | Archaea | Archaea | 125 | 2.28e-30 | NR | MEM0326648.1 | 2184738 | g5096 | i0 | 62.2 | 1.1109022556391 | 98 | 36 | 54.7 | 1 | 106 | 396 | 331 | 428 | MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] | diamond | 591 | 125 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 27351242 | 27351242 | PRJNA1020854_S_NODE_26483_length_204_cov_5.365714_g23719_i0 | PRJNA1020854 | 26483 | 204 | 5.365714 | 10.94605656 | Caldisphaera sp. | 2060322 | Archaea | Archaea | 100 | 4.34e-25 | NR | PMP88171.1 | 2060322 | g23719 | i0 | 76.7 | 0.882352941176471 | 60 | 14 | 88.2 | 0 | 200 | 21 | 11 | 70 | PMP88171.1 MAG: hypothetical protein C0172_03270 [Caldisphaera sp.] | diamond | 180 | 100 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Acidilobales | Caldisphaeraceae | Caldisphaera | Caldisphaera sp. | ||
| 28045591 | 28045591 | PRJNA1020854_S_NODE_41505_length_154_cov_2.912000_g38741_i0 | PRJNA1020854 | 41505 | 154 | 2.912 | 4.48448 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 76.6 | 1.24e-14 | NR | MDT7864924.1 | 2056631 | g38741 | i0 | 76.5 | 0.993506493506494 | 51 | 12 | 99.4 | 0 | 2 | 154 | 459 | 509 | MDT7864924.1 hypothetical protein [Thermoproteota archaeon] | diamond | 153 | 76.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28582533 | 28582533 | PRJNA1020854_S_NODE_39387_length_159_cov_2.692308_g36623_i0 | PRJNA1020854 | 39387 | 159 | 2.692308 | 4.28076972 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 89 | 4.58e-19 | NR | MDT7864683.1 | 2056631 | g36623 | i0 | 93.3 | 0.849056603773585 | 45 | 3 | 84.9 | 0 | 25 | 159 | 1 | 45 | MDT7864683.1 hypothetical protein [Thermoproteota archaeon] | diamond | 135 | 89 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28866527 | 28866527 | PRJNA1020854_S_NODE_28948_length_193_cov_3.158537_g26184_i0 | PRJNA1020854 | 28948 | 193 | 3.158537 | 6.09597641 | Candidatus Brockarchaeota archaeon | 2815303 | Archaea | Archaea | 77.8 | 9.3e-16 | NR | MBO3757533.1 | 2815303 | g26184 | i0 | 96.9 | 0.994818652849741 | 64 | 2 | 99.5 | 0 | 2 | 193 | 109 | 172 | MBO3757533.1 hypothetical protein [Candidatus Brockarchaeota archaeon] | diamond | 192 | 77.8 | 1 | Archaea | Thermoproteati | Candidatus Brockarchaeota | Candidatus Brockarchaeota archaeon | ||||||
| 30445803 | 30445803 | PRJNA1020854_S_NODE_33493_length_176_cov_2.360544_g30729_i0 | PRJNA1020854 | 33493 | 176 | 2.360544 | 4.15455744 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 75.5 | 4.08e-14 | NR | MEM3368530.1 | 2056631 | g30729 | i0 | 86 | 0.732954545454545 | 43 | 6 | 73.3 | 0 | 175 | 47 | 80 | 122 | MEM3368530.1 hypothetical protein [Thermoproteota archaeon] | diamond | 129 | 75.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30698346 | 30698346 | PRJNA1020854_S_NODE_31054_length_184_cov_9.690323_g28290_i0 | PRJNA1020854 | 31054 | 184 | 9.690323 | 17.83019432 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 100 | 1.7e-23 | NR | MDT7864687.1 | 2056631 | g28290 | i0 | 97.9 | 0.766304347826087 | 47 | 1 | 76.6 | 0 | 24 | 164 | 278 | 324 | MDT7864687.1 ribonucleotide-diphosphate reductase subunit beta [Thermoproteota archaeon] | diamond | 141 | 100 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31804810 | 31804810 | PRJNA1020854_S_NODE_24017_length_218_cov_5.439153_g21253_i0 | PRJNA1020854 | 24017 | 218 | 5.439153 | 11.85735354 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 101 | 1.4199999999999999e-25 | NR | MDT7864681.1 | 2056631 | g21253 | i0 | 89.5 | 0.784403669724771 | 57 | 6 | 78.4 | 0 | 1 | 171 | 8 | 64 | MDT7864681.1 hypothetical protein [Thermoproteota archaeon] | diamond | 171 | 101 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon |
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);;