contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1126661" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27986306 | 27986306 | PRJNA1126661_P_NODE_62665_length_271_cov_6.196970_g62135_i0 | PRJNA1126661 | 62665 | 271 | 6.19697 | 16.7937887 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 86.7 | 1.36e-18 | NR | MEZ0269839.1 | 2169593 | g62135 | i0 | 80.4 | 1.01845018450184 | 46 | 8 | 49.8 | 1 | 137 | 271 | 1 | 46 | MEZ0269839.1 archaeal heat shock protein Hsp20 [Nitrososphaeraceae archaeon] | diamond | 276 | 86.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28901763 | 28901763 | PRJNA1126661_P_NODE_47188_length_298_cov_5.542222_g46659_i0 | PRJNA1126661 | 47188 | 298 | 5.542222 | 16.51582156 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 108 | 7.22e-25 | NR | MPZ06554.1 | 2169593 | g46659 | i0 | 90.9 | 1.74161073825503 | 55 | 5 | 55.4 | 0 | 296 | 132 | 669 | 723 | MPZ06554.1 DEAD/DEAH box helicase [Nitrososphaeraceae archaeon] | diamond | 519 | 108 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28996971 | 28996971 | PRJNA1126661_P_NODE_75868_length_238_cov_4.612121_g75338_i0 | PRJNA1126661 | 75868 | 238 | 4.612121 | 10.97684798 | Nitrosopumilales archaeon | 2026768 | Archaea | Archaea | 150 | 6.779999999999998e-42 | NR | TSA17869.1 | 2026768 | g75338 | i0 | 98.7 | 0.983193277310924 | 78 | 1 | 98.3 | 0 | 236 | 3 | 30 | 107 | TSA17869.1 MAG: alanine--glyoxylate aminotransferase family protein [Nitrosopumilales archaeon] | diamond | 234 | 150 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 29280663 | 29280663 | PRJNA1126661_P_NODE_29409_length_326_cov_2.675889_g28880_i0 | PRJNA1126661 | 29409 | 326 | 2.675889 | 8.72339814 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 68.2 | 1.16e-10 | NR | HEX9318228.1 | 2169593 | g28880 | i0 | 61.7 | 1.76687116564417 | 47 | 18 | 43.3 | 0 | 318 | 178 | 106 | 152 | HEX9318228.1 right-handed parallel beta-helix repeat-containing protein [Nitrososphaeraceae archaeon] | diamond | 576 | 68.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29312430 | 29312430 | PRJNA1126661_P_NODE_62049_length_273_cov_2.950000_g61519_i0 | PRJNA1126661 | 62049 | 273 | 2.95 | 8.0535 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 116 | 1.52e-29 | NR | HEX2305482.1 | 2169593 | g61519 | i0 | 67.9 | 2.89010989010989 | 84 | 27 | 92.3 | 0 | 253 | 2 | 29 | 112 | HEX2305482.1 metallophosphoesterase [Nitrososphaeraceae archaeon] | diamond | 789 | 116 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31081483 | 31081483 | PRJNA1126661_P_NODE_70955_length_251_cov_1.752809_g70425_i0 | PRJNA1126661 | 70955 | 251 | 1.752809 | 4.39955059 | Candidatus Nitrosocosmicus franklandus | 1826864 | Archaea | Archaea | 42 | 0.0411 | NR | WP_134485138.1 | 1798806 | g70425 | i0 | 95 | 0.525896414342629 | 20 | 1 | 23.9 | 0 | 249 | 190 | 133 | 152 | WP_134485138.1 universal stress protein [Candidatus Nitrosocosmicus franklandus] | diamond | 132 | 42 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus franklandianus | ||
| 31808722 | 31808722 | PRJNA1126661_P_NODE_43737_length_300_cov_4.422907_g43208_i0 | PRJNA1126661 | 43737 | 300 | 4.422907 | 13.268721 | Nitrosotalea sp. | 2833567 | Archaea | Archaea | 228 | 4.16e-71 | NR | MDC8451428.1 | 2833567 | g43208 | i0 | 99 | 1 | 100 | 1 | 100 | 0 | 1 | 300 | 338 | 437 | MDC8451428.1 ergothioneine biosynthesis protein EgtB [Nitrosotalea sp.] | diamond | 300 | 228 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea sp. | ||
| 32662307 | 32662307 | PRJNA1126661_P_NODE_46300_length_299_cov_3.398230_g45771_i0 | PRJNA1126661 | 46300 | 299 | 3.39823 | 10.1607077 | Sulfolobaceae archaeon | 2967306 | Archaea | Archaea | 80.1 | 2.24e-16 | NR | MEM0173287.1 | 2967306 | g45771 | i0 | 67.3 | 0.491638795986622 | 49 | 16 | 49.2 | 0 | 151 | 297 | 61 | 109 | MEM0173287.1 hypothetical protein [Sulfolobaceae archaeon] | diamond | 147 | 80.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobaceae 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);;