contig_metadata
7 rows where bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16276456 | 16276456 | PRJNA986481_P_NODE_35553_length_274_cov_1.142222_g35028_i0 | PRJNA986481 | 35553 | 274 | 1.142222 | 3.12968828 | Acidianus sulfidivorans | 312539 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|1820310478|gb|CP029288.2| | 619593 | g35028 | i0 | 96.97 | 0.12043795620438 | 33 | 1 | 12 | 0 | 59 | 91 | 707439 | 707471 | Acidianus sulfidivorans JP7 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus sulfidivorans | ||
| 17551457 | 17551457 | PRJNA986481_P_NODE_35734_length_273_cov_1.718750_g35209_i0 | PRJNA986481 | 35734 | 273 | 1.71875 | 4.6921875 | Nitrosopumilus cobalaminigenes | 1470066 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|1869221159|gb|CP026993.1| | 1470066 | g35209 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 153 | 180 | 768244 | 768271 | Nitrosopumilus cobalaminigenes strain HCA1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus cobalaminigenes | ||
| 26646270 | 26646270 | PRJNA986481_P_NODE_38081_length_266_cov_0.930876_g37556_i0 | PRJNA986481 | 38081 | 266 | 0.930876 | 2.47613016 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 64.7 | 2.4e-10 | NR | MDG6912767.1 | 2026795 | g37556 | i0 | 58.3 | 0.541353383458647 | 48 | 19 | 53 | 1 | 126 | 266 | 98 | 145 | MDG6912767.1 amidase domain-containing protein [Nitrososphaerota archaeon] | diamond | 144 | 64.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28668768 | 28668768 | PRJNA986481_P_NODE_36647_length_269_cov_1.836364_g36122_i0 | PRJNA986481 | 36647 | 269 | 1.836364 | 4.93981916 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 43.5 | 0.0265 | NR | HEX9913285.1 | 3045160 | g36122 | i0 | 28.4 | 0.825278810408922 | 74 | 52 | 82.5 | 1 | 223 | 2 | 275 | 347 | HEX9913285.1 MBL fold metallo-hydrolase [Candidatus Bathyarchaeia archaeon] | diamond | 222 | 43.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28763242 | 28763242 | PRJNA986481_P_NODE_42127_length_261_cov_0.952830_g41602_i0 | PRJNA986481 | 42127 | 261 | 0.95283 | 2.4868863 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 46.2 | 7.86e-4 | NR | MFQ5573870.1 | 2202732 | g41602 | i0 | 35.3 | 0.781609195402299 | 68 | 34 | 78.2 | 1 | 204 | 1 | 42 | 99 | MFQ5573870.1 PHP domain-containing protein [Nitrosopumilaceae archaeon] | diamond | 204 | 46.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 30121043 | 30121043 | PRJNA986481_P_NODE_33412_length_283_cov_1.051282_g32887_i0 | PRJNA986481 | 33412 | 283 | 1.051282 | 2.97512806 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 72.4 | 1.87e-12 | NR | HLL60195.1 | 2109671 | g32887 | i0 | 53.1 | 3.42402826855124 | 81 | 34 | 85.9 | 1 | 279 | 37 | 214 | 290 | HLL60195.1 ATP-binding cassette domain-containing protein [Candidatus Nitrosocosmicus sp.] | diamond | 969 | 72.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 31100508 | 31100508 | PRJNA986481_P_NODE_31095_length_293_cov_1.704918_g30570_i0 | PRJNA986481 | 31095 | 293 | 1.704918 | 4.99540974 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 43.5 | 0.0331 | NR | MDA7495390.1 | 2024843 | g30570 | i0 | 43.1 | 0.522184300341297 | 51 | 28 | 52.2 | 1 | 221 | 69 | 265 | 314 | MDA7495390.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 153 | 43.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus 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);;