contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11106045 | 11106045 | PRJNA928559_P_NODE_143449_length_295_cov_1.405405_g141880_i0 | PRJNA928559 | 143449 | 295 | 1.405405 | 4.14594475 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 124 | 1.05e-33 | NR | NDB88989.1 | 2026795 | g141880 | i0 | 66.3 | 3.93559322033898 | 98 | 31 | 97.6 | 1 | 290 | 3 | 51 | 148 | NDB88989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 1161 | 124 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 26644778 | 26644778 | PRJNA928559_P_NODE_99201_length_358_cov_2.066667_g97632_i0 | PRJNA928559 | 99201 | 358 | 2.066667 | 7.39866786 | Saccharolobus caldissimus | 1702097 | Archaea | Archaea | 43.9 | 0.05 | NR | WP_229572040.1 | 1702097 | g97632 | i0 | 32.1 | 0.67877094972067 | 81 | 50 | 63.7 | 2 | 333 | 106 | 120 | 200 | WP_229572040.1 hypothetical protein [Saccharolobus caldissimus] | diamond | 243 | 43.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus caldissimus | ||
| 27119416 | 27119416 | PRJNA928559_P_NODE_95142_length_365_cov_2.794521_g93573_i0 | PRJNA928559 | 95142 | 365 | 2.794521 | 10.20000165 | Vulcanisaeta sp. | 2020871 | Archaea | Archaea | 77.4 | 9.7e-14 | NR | MFP3236626.1 | 2020871 | g93573 | i0 | 42.2 | 5.50684931506849 | 109 | 62 | 88.8 | 1 | 347 | 24 | 65 | 173 | MFP3236626.1 aspartate aminotransferase family protein [Vulcanisaeta sp.] | diamond | 2010 | 77.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta sp. | ||
| 28919436 | 28919436 | PRJNA928559_P_NODE_159428_length_278_cov_1.521951_g157859_i0 | PRJNA928559 | 159428 | 278 | 1.521951 | 4.23102378 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 41.2 | 0.0331 | NR | TBR07939.1 | 2507556 | g157859 | i0 | 50 | 0.366906474820144 | 34 | 17 | 36.7 | 0 | 144 | 245 | 41 | 74 | TBR07939.1 MAG: hypothetical protein EPO62_07445 [Candidatus Nitrosotenuis sp.] | diamond | 102 | 41.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 30277942 | 30277942 | PRJNA928559_P_NODE_188512_length_253_cov_0.866667_g186943_i0 | PRJNA928559 | 188512 | 253 | 0.866667 | 2.19266751 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 107 | 5.66e-25 | NR | WP_048188611.1 | 1603555 | g186943 | i0 | 69.8 | 4.04347826086957 | 86 | 21 | 98.4 | 3 | 252 | 4 | 1050 | 1133 | WP_048188611.1 beta strand repeat-containing protein [Candidatus Nitrosotenuis cloacae] | diamond | 1023 | 107 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 31446923 | 31446923 | PRJNA928559_P_NODE_210876_length_243_cov_2.294118_g209307_i0 | PRJNA928559 | 210876 | 243 | 2.294118 | 5.57470674 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 99.8 | 1.3e-23 | NR | RLE57769.1 | 2250277 | g209307 | i0 | 58.4 | 0.950617283950617 | 77 | 32 | 95.1 | 0 | 233 | 3 | 8 | 84 | RLE57769.1 MAG: proteasome endopeptidase complex, archaeal, alpha subunit [Thermoprotei archaeon] | diamond | 231 | 99.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei 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);;