contig_metadata
6 rows where bioproject = "PRJNA432257" and tax_kingdom = "Promethearchaeati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1704634 | 1704634 | PRJNA432257_S_NODE_49102_length_232_cov_273.328205_g48721_i0 | PRJNA432257 | 49102 | 232 | 273.328205 | 634.1214356 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 52.8 | 0.021 | NTclustered | gi|2108345004|gb|CP070658.1| | 2053491 | g48721 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 167 | 194 | 1742594 | 1742621 | MAG: Candidatus Thorarchaeota archaeon isolate bin8 chromosome | blastn | 28 | 52.8 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 4256408 | 4256408 | PRJNA432257_S_NODE_28784_length_283_cov_12.016260_g28403_i0 | PRJNA432257 | 28784 | 283 | 12.01626 | 34.0060158 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 63.9 | 1.21e-5 | NTclustered | gi|2027294252|gb|MW958651.1| | 2053489 | g28403 | i0 | 97.297 | 0.130742049469965 | 37 | 1 | 13 | 0 | 213 | 249 | 1281 | 1245 | Promethearchaeota archaeon clone AB328_20_25 16S ribosomal RNA gene, partial sequence | blastn | 37 | 63.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29728100 | 29728100 | PRJNA432257_S_NODE_7830_length_445_cov_22.031863_g7509_i0 | PRJNA432257 | 7830 | 445 | 22.031863 | 98.04179035 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 46.6 | 0.00369 | NR | TFG99973.1 | 2053491 | g7509 | i0 | 66.7 | 0.202247191011236 | 30 | 10 | 20.2 | 0 | 416 | 327 | 88 | 117 | TFG99973.1 MAG: hypothetical protein E4H12_00855 [Candidatus Thorarchaeota archaeon] | diamond | 90 | 46.6 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 29759741 | 29759741 | PRJNA432257_S_NODE_101811_length_175_cov_1.130435_g101430_i0 | PRJNA432257 | 101811 | 175 | 1.130435 | 1.97826125 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 40.4 | 0.0155 | NR | HEY0087730.1 | 3067280 | g101430 | i0 | 37.5 | 0.822857142857143 | 48 | 29 | 82.3 | 1 | 163 | 20 | 17 | 63 | HEY0087730.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 144 | 40.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30549661 | 30549661 | PRJNA432257_S_NODE_68913_length_204_cov_316.485030_g68532_i0 | PRJNA432257 | 68913 | 204 | 316.48503 | 645.6294612 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 68.2 | 2.37e-11 | NR | TXT66099.1 | 2053489 | g68532 | i0 | 54.7 | 0.779411764705882 | 53 | 24 | 77.9 | 0 | 161 | 3 | 595 | 647 | TXT66099.1 MAG: putative DNA-directed DNA polymerase [Promethearchaeota archaeon] | diamond | 159 | 68.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30960531 | 30960531 | PRJNA432257_S_NODE_11174_length_393_cov_1.862360_g10806_i0 | PRJNA432257 | 11174 | 393 | 1.86236 | 7.3190748 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 104 | 8.92e-26 | NR | MEE9379655.1 | 3067280 | g10806 | i0 | 49.5 | 0.786259541984733 | 103 | 48 | 78.6 | 2 | 323 | 15 | 1 | 99 | MEE9379655.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 309 | 104 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia 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);;