contig_metadata
6 rows where bioproject = "PRJNA851399" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2114578 | 2114578 | PRJNA851399_P_NODE_14702_length_196_cov_1.639456_g14249_i0 | PRJNA851399 | 14702 | 196 | 1.639456 | 3.21333376 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 291 | 3.3e-74 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g14249 | i0 | 93.401 | 33.3673469387755 | 197 | 12 | 100 | 1 | 1 | 196 | 7798 | 7602 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 6540 | 291 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 7217238 | 7217238 | PRJNA851399_P_NODE_10066_length_249_cov_1.500000_g9613_i0 | PRJNA851399 | 10066 | 249 | 1.5 | 3.735 | Candidatus Nitrosocosmicus franklandianus | 1798806 | Archaea | Archaea | 339 | 1.5399999999999998e-88 | NTclustered | gi|1599533355|emb|LR216287.1| | 1798806 | g9613 | i0 | 91.498 | 62.7269076305221 | 247 | 19 | 99 | 2 | 3 | 249 | 1683 | 1439 | Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN | blastn | 15619 | 339 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus franklandianus | ||
| 11437802 | 11437802 | PRJNA851399_P_NODE_5769_length_405_cov_1.002809_g5317_i0 | PRJNA851399 | 5769 | 405 | 1.002809 | 4.06137645 | root | 1 | Root_unresolved | Root_unresolved | 743 | 0 | NTclustered | gi|955471768|gb|FJ968093.2| | 29281 | g5317 | i0 | 99.753 | 100 | 405 | 1 | 100 | 0 | 1 | 405 | 548 | 144 | Uncultured crenarchaeote clone Arch_AE_D06 16S ribosomal RNA (rrnA) gene, partial sequence | blastn | 40500 | 743 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 26770161 | 26770161 | PRJNA851399_P_NODE_39001_length_162_cov_0.893805_g38548_i0 | PRJNA851399 | 39001 | 162 | 0.893805 | 1.4479641 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 89.4 | 4.56e-19 | NR | HNU62018.1 | 2666341 | g38548 | i0 | 80.8 | 0.962962962962963 | 52 | 8 | 96.3 | 1 | 158 | 3 | 176 | 225 | HNU62018.1 DnaB-like helicase C-terminal domain-containing protein [Methanofastidiosum sp.] | diamond | 156 | 89.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 30884693 | 30884693 | PRJNA851399_P_NODE_24194_length_168_cov_1.714286_g23741_i0 | PRJNA851399 | 24194 | 168 | 1.714286 | 2.88000048 | Thermoproteati | 1783275 | Archaea | Archaea | 109 | 1.16e-26 | NR | TLX88064.1 | 2026795 | g23741 | i0 | 96.4 | 4.89285714285714 | 55 | 2 | 98.2 | 0 | 2 | 166 | 215 | 269 | TLX88064.1 MAG: TIGR00300 family protein [Nitrososphaerota archaeon] | diamond | 822 | 110 | 0.990909090909091 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 31666761 | 31666761 | PRJNA851399_P_NODE_33137_length_164_cov_0.886957_g32684_i0 | PRJNA851399 | 33137 | 164 | 0.886957 | 1.45460948 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 41.2 | 0.0455 | NR | RLI46151.1 | 2026714 | g32684 | i0 | 46.9 | 0.585365853658537 | 32 | 17 | 58.5 | 0 | 30 | 125 | 467 | 498 | RLI46151.1 MAG: glycosyl transferase [Candidatus Bathyarchaeota archaeon] | diamond | 96 | 41.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota 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);;