contig_metadata
9 rows where bioproject = "PRJNA1255065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24586479 | 24586479 | PRJNA1255065_P_NODE_145900_length_163_cov_0.912281_g143672_i0 | PRJNA1255065 | 145900 | 163 | 0.912281 | 1.48701803 | Haloarcula sp. CBA1115 | 1592728 | Archaea | Archaea | 196 | 5.93e-46 | NTclustered | gi|749699433|gb|CP010529.1| | 1592728 | g143672 | i0 | 88.344 | 4.45398773006135 | 163 | 19 | 100 | 0 | 1 | 163 | 1673284 | 1673122 | Haloarcula sp. CBA1115, complete genome | blastn | 726 | 196 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula sp. CBA1115 | |
| 26661988 | 26661988 | PRJNA1255065_P_NODE_144861_length_163_cov_0.912281_g142633_i0 | PRJNA1255065 | 144861 | 163 | 0.912281 | 1.48701803 | Candidatus Nitrosocosmicus sp. SS | 2563600 | Archaea | Archaea | 104 | 3.770000000000001e-27 | NR | WP_149863215.1 | 2563600 | g142633 | i0 | 90.6 | 0.975460122699387 | 53 | 5 | 97.5 | 0 | 3 | 161 | 7 | 59 | WP_149863215.1 hypothetical protein [Candidatus Nitrosocosmicus sp. SS] | diamond | 159 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus agrestis | ||
| 26789120 | 26789120 | PRJNA1255065_P_NODE_146441_length_163_cov_0.912281_g144213_i0 | PRJNA1255065 | 146441 | 163 | 0.912281 | 1.48701803 | Natronococcus jeotgali | 413812 | Archaea | Archaea | 107 | 3.15e-26 | NR | WP_008423015.1 | 413812 | g144213 | i0 | 92.5 | 2.92638036809816 | 53 | 4 | 97.5 | 0 | 161 | 3 | 110 | 162 | WP_008423015.1 tartrate dehydrogenase [Natronococcus jeotgali] | diamond | 477 | 107 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus jeotgali | |
| 29000515 | 29000515 | PRJNA1255065_P_NODE_121548_length_167_cov_0.881356_g119320_i0 | PRJNA1255065 | 121548 | 167 | 0.881356 | 1.47186452 | Candidatus Nitrosocosmicus sp. SS | 2563600 | Archaea | Archaea | 99.4 | 6.079999999999999e-23 | NR | WP_149864399.1 | 2563600 | g119320 | i0 | 87 | 0.970059880239521 | 54 | 7 | 97 | 0 | 164 | 3 | 188 | 241 | WP_149864399.1 glycosyltransferase [Candidatus Nitrosocosmicus sp. SS] | diamond | 162 | 99.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus agrestis | ||
| 29979041 | 29979041 | PRJNA1255065_P_NODE_94251_length_181_cov_0.856061_g92023_i0 | PRJNA1255065 | 94251 | 181 | 0.856061 | 1.54947041 | archaeon | 1906665 | Archaea | Archaea | 50.1 | 1.05e-5 | NR | RYH28354.1 | 1906665 | g92023 | i0 | 61 | 0.679558011049724 | 41 | 16 | 68 | 0 | 181 | 59 | 57 | 97 | RYH28354.1 MAG: ABC-F family ATP-binding cassette domain-containing protein [archaeon] | diamond | 123 | 50.1 | 1 | Archaea | archaeon | ||||||||
| 30832070 | 30832070 | PRJNA1255065_P_NODE_98514_length_176_cov_0.889764_g96286_i0 | PRJNA1255065 | 98514 | 176 | 0.889764 | 1.56598464 | Halarchaeum nitratireducens | 489913 | Archaea | Archaea | 40.4 | 0.0252 | NR | WP_188880210.1 | 489913 | g96286 | i0 | 35.6 | 1.00568181818182 | 59 | 30 | 86.9 | 1 | 170 | 18 | 7 | 65 | WP_188880210.1 hypothetical protein [Halarchaeum nitratireducens] | diamond | 177 | 40.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halarchaeum | Halarchaeum nitratireducens | |
| 32033715 | 32033715 | PRJNA1255065_P_NODE_76298_length_207_cov_1.316456_g74070_i0 | PRJNA1255065 | 76298 | 207 | 1.316456 | 2.72506392 | Halobacterium sp. R2-5 | 2715751 | Archaea | Archaea | 42.4 | 0.0323 | NR | WP_167247438.1 | 2715751 | g74070 | i0 | 60.7 | 0.405797101449275 | 28 | 11 | 40.6 | 0 | 48 | 131 | 873 | 900 | WP_167247438.1 DEAD/DEAH box helicase [Halobacterium sp. R2-5] | diamond | 84 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. R2-5 | |
| 32540175 | 32540175 | PRJNA1255065_P_NODE_84959_length_193_cov_1.083333_g82731_i0 | PRJNA1255065 | 84959 | 193 | 1.083333 | 2.09083269 | archaeon | 1906665 | Archaea | Archaea | 79.3 | 1.66e-15 | NR | RYH20254.1 | 1906665 | g82731 | i0 | 60.3 | 0.979274611398964 | 63 | 25 | 97.9 | 0 | 3 | 191 | 229 | 291 | RYH20254.1 MAG: hypothetical protein EON65_24020 [archaeon] | diamond | 189 | 79.3 | 1 | Archaea | archaeon | ||||||||
| 32665915 | 32665915 | PRJNA1255065_P_NODE_108960_length_169_cov_0.866667_g106732_i0 | PRJNA1255065 | 108960 | 169 | 0.866667 | 1.46466723 | archaeon | 1906665 | Archaea | Archaea | 81.6 | 1.12e-16 | NR | RYG67299.1 | 1906665 | g106732 | i0 | 65.5 | 0.976331360946746 | 55 | 19 | 97.6 | 0 | 3 | 167 | 152 | 206 | RYG67299.1 MAG: hypothetical protein EON64_07745, partial [archaeon] | diamond | 165 | 81.6 | 1 | Archaea | 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);;