contig_metadata
7 rows where bioproject = "PRJNA835051" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23778385 | 23778385 | PRJNA835051_S_NODE_38679_length_233_cov_47.389474_g38383_i0 | PRJNA835051 | 38679 | 233 | 47.389474 | 110.41747442 | Vulcanisaeta moutnovskia | 985052 | Archaea | Archaea | 52.8 | 0.021 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g38383 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 76 | 103 | 336127 | 336100 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 27086320 | 27086320 | PRJNA835051_S_NODE_50482_length_216_cov_1.907514_g50186_i0 | PRJNA835051 | 50482 | 216 | 1.907514 | 4.12023024 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 45.8 | 4.25e-4 | NR | HYP43214.1 | 2109671 | g50186 | i0 | 90.5 | 0.291666666666667 | 21 | 2 | 29.2 | 0 | 147 | 209 | 1 | 21 | HYP43214.1 hypothetical protein [Candidatus Nitrosocosmicus sp.] | diamond | 63 | 45.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 28191399 | 28191399 | PRJNA835051_S_NODE_117346_length_158_cov_1.634783_g117050_i0 | PRJNA835051 | 117346 | 158 | 1.634783 | 2.58295714 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 57 | 3.17e-9 | NR | RLI47031.1 | 2026714 | g117050 | i0 | 54 | 0.949367088607595 | 50 | 23 | 94.9 | 0 | 152 | 3 | 4 | 53 | RLI47031.1 MAG: hypothetical protein DRO61_08490 [Candidatus Bathyarchaeota archaeon] | diamond | 150 | 57 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29139137 | 29139137 | PRJNA835051_S_NODE_12509_length_308_cov_46.935849_g12213_i0 | PRJNA835051 | 12509 | 308 | 46.935849 | 144.56241492 | uncultured marine thaumarchaeote KM3_53_F | 1167203 | Archaea | Archaea | 55.8 | 3.66e-8 | NR | AIF11850.1 | 1456186 | g12213 | i0 | 75 | 0.350649350649351 | 36 | 9 | 35.1 | 0 | 193 | 300 | 1 | 36 | AIF11850.1 hypothetical protein, partial [uncultured marine thaumarchaeote KM3_53_F08] | diamond | 108 | 55.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | uncultured marine thaumarchaeote KM3_53_F08 | ||||||
| 30876095 | 30876095 | PRJNA835051_S_NODE_121974_length_155_cov_2.098214_g121678_i0 | PRJNA835051 | 121974 | 155 | 2.098214 | 3.2522317 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 43.1 | 0.00825 | NR | HYP42844.1 | 2109671 | g121678 | i0 | 86.4 | 0.425806451612903 | 22 | 3 | 42.6 | 0 | 71 | 6 | 432 | 453 | HYP42844.1 RNase H family protein [Candidatus Nitrosocosmicus sp.] | diamond | 66 | 43.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 30876099 | 30876099 | PRJNA835051_S_NODE_1754_length_546_cov_2.216700_g1478_i0 | PRJNA835051 | 1754 | 546 | 2.2167 | 12.103182 | Candidatus Marsarchaeota archaeon | 2823144 | Archaea | Archaea | 53.1 | 1.52e-4 | NR | MCL5423474.1 | 2823144 | g1478 | i0 | 24.6 | 2.14835164835165 | 126 | 93 | 68.1 | 2 | 443 | 72 | 2 | 127 | MCL5423474.1 hypothetical protein [Candidatus Marsarchaeota archaeon] | diamond | 1173 | 53.1 | 1 | Archaea | Thermoproteati | Candidatus Marsarchaeota | Candidatus Marsarchaeota archaeon | ||||||
| 32109405 | 32109405 | PRJNA835051_S_NODE_18878_length_280_cov_2.405063_g18582_i0 | PRJNA835051 | 18878 | 280 | 2.405063 | 6.7341764 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 43.9 | 0.0202 | NR | MER3602033.1 | 2026795 | g18582 | i0 | 39.7 | 0.835714285714286 | 78 | 44 | 80.4 | 1 | 33 | 257 | 119 | 196 | MER3602033.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 234 | 43.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota 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);;