contig_metadata
5 rows where bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26895866 | 26895866 | PRJNA796753_P_NODE_26821_length_290_cov_2.723502_g26509_i0 | PRJNA796753 | 26821 | 290 | 2.723502 | 7.8981558 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 44.7 | 0.00286 | NR | MCD6509504.1 | 2250277 | g26509 | i0 | 47.1 | 2.18275862068965 | 51 | 25 | 50.7 | 1 | 151 | 5 | 8 | 58 | MCD6509504.1 single-stranded DNA-binding protein [Thermoprotei archaeon] | diamond | 633 | 44.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 26927275 | 26927275 | PRJNA796753_P_NODE_14462_length_374_cov_1.013289_g14150_i0 | PRJNA796753 | 14462 | 374 | 1.013289 | 3.78970086 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 77 | 1.53e-13 | NR | MDE1816823.1 | 2026795 | g14150 | i0 | 66.7 | 0.457219251336898 | 57 | 19 | 45.7 | 0 | 204 | 374 | 299 | 355 | MDE1816823.1 reverse transcriptase family protein [Nitrososphaerota archaeon] | diamond | 171 | 77 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 26958736 | 26958736 | PRJNA796753_P_NODE_26762_length_291_cov_1.073394_g26450_i0 | PRJNA796753 | 26762 | 291 | 1.073394 | 3.12357654 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 47 | 0.0019 | NR | MEM2249321.1 | 3045160 | g26450 | i0 | 39.3 | 1.7319587628866 | 56 | 30 | 53.6 | 1 | 110 | 265 | 237 | 292 | MEM2249321.1 GNAT family N-acetyltransferase [Candidatus Bathyarchaeia archaeon] | diamond | 504 | 47 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28790650 | 28790650 | PRJNA796753_P_NODE_50887_length_243_cov_0.905882_g50575_i0 | PRJNA796753 | 50887 | 243 | 0.905882 | 2.20129326 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 50.1 | 9.3e-5 | NR | RLE48333.1 | 2250257 | g50575 | i0 | 39.7 | 0.777777777777778 | 63 | 37 | 77.8 | 1 | 19 | 207 | 105 | 166 | RLE48333.1 MAG: hypothetical protein DRJ31_07460 [Candidatus Methanomethylicota archaeon] | diamond | 189 | 50.1 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 32235536 | 32235536 | PRJNA796753_P_NODE_33938_length_267_cov_1.505155_g33626_i0 | PRJNA796753 | 33938 | 267 | 1.505155 | 4.01876385 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 43.1 | 0.035 | NR | HJS82439.1 | 1971748 | g33626 | i0 | 41.8 | 0.617977528089888 | 55 | 23 | 51.7 | 1 | 109 | 246 | 173 | 227 | HJS82439.1 hypothetical protein [Nitrososphaera sp.] | diamond | 165 | 43.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. |
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);;