contig_metadata
12 rows where bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1385112 | 1385112 | PRJEB49404_P_NODE_500662_length_182_cov_0.769231_g486861_i0 | PRJEB49404 | 500662 | 182 | 0.769231 | 1.40000042 | Natrinema thermotolerans | 121872 | Archaea | Archaea | 80.5 | 7.1e-11 | NTclustered | gi|1621090060|gb|CP031304.1| | 121872 | g486861 | i0 | 82.292 | 56.7637362637363 | 96 | 13 | 85 | 4 | 43 | 136 | 953230 | 953323 | Natrinema thermotolerans strain A29 plasmid unnamed6, complete sequence | blastn | 10331 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema thermotolerans | |
| 5219383 | 5219383 | PRJEB49404_P_NODE_630705_length_154_cov_0.991304_g616904_i0 | PRJEB49404 | 630705 | 154 | 0.991304 | 1.52660816 | Salarchaeum japonicum | 555573 | Archaea | Archaea | 135 | 1.2200000000000002e-27 | NTclustered | gi|2124061129|gb|CP085324.1| | 555573 | g616904 | i0 | 82.692 | 2.93506493506493 | 156 | 23 | 100 | 4 | 1 | 154 | 191326 | 191479 | Salarchaeum japonicum strain JCM 16327 chromosome, complete genome | blastn | 452 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum japonicum | |
| 7368655 | 7368655 | PRJEB49404_P_NODE_541406_length_172_cov_0.902256_g527605_i0 | PRJEB49404 | 541406 | 172 | 0.902256 | 1.55188032 | root | 1 | Root_unresolved | Root_unresolved | 313 | 5.989999999999998e-81 | NTclustered | gi|373125855|gb|JN567036.1| | 29281 | g527605 | i0 | 99.419 | 102 | 172 | 1 | 100 | 0 | 1 | 172 | 538 | 709 | Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence | blastn | 17544 | 313 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 9028461 | 9028461 | PRJEB49404_P_NODE_303288_length_262_cov_1.103139_g289487_i0 | PRJEB49404 | 303288 | 262 | 1.103139 | 2.89022418 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 484 | 1.99e-132 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g289487 | i0 | 100 | 48.1106870229008 | 262 | 0 | 100 | 0 | 1 | 262 | 7082 | 6821 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 12605 | 484 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 21784783 | 21784783 | PRJEB49404_P_NODE_445578_length_198_cov_0.955975_g431777_i0 | PRJEB49404 | 445578 | 198 | 0.955975 | 1.8928305 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 344 | 2.53e-90 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g431777 | i0 | 97.99 | 18.6161616161616 | 199 | 3 | 100 | 1 | 1 | 198 | 6405 | 6603 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 3686 | 344 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 23067169 | 23067169 | PRJEB49404_P_NODE_592879_length_161_cov_1.008197_g579078_i0 | PRJEB49404 | 592879 | 161 | 1.008197 | 1.62319717 | Natronomonas | 63743 | Archaea | Archaea | 107 | 3.04e-28 | NR | WP_015408170.1 | 416273 | g579078 | i0 | 86.8 | 1.97515527950311 | 53 | 7 | 98.8 | 0 | 3 | 161 | 70 | 122 | WP_015408170.1 Rieske (2Fe-2S) protein [Natronomonas moolapensis] | diamond | 318 | 108 | 0.990740740740741 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 26653388 | 26653388 | PRJEB49404_P_NODE_597381_length_160_cov_1.347107_g583580_i0 | PRJEB49404 | 597381 | 160 | 1.347107 | 2.1553712 | Halorubrum laminariae | 1433523 | Archaea | Archaea | 103 | 1.7599999999999998e-24 | NR | WP_256418948.1 | 1433523 | g583580 | i0 | 96.2 | 0.99375 | 53 | 2 | 99.4 | 0 | 160 | 2 | 59 | 111 | WP_256418948.1 Cdc6/Cdc18 family protein [Halorubrum laminariae] | diamond | 159 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum laminariae | |
| 27191451 | 27191451 | PRJEB49404_P_NODE_651702_length_150_cov_1.405405_g637901_i0 | PRJEB49404 | 651702 | 150 | 1.405405 | 2.1081075 | Halonotius roseus | 2511997 | Archaea | Archaea | 77.4 | 1.93e-16 | NR | WP_142444172.1 | 2511997 | g637901 | i0 | 90.9 | 1.76 | 44 | 4 | 88 | 0 | 18 | 149 | 1 | 44 | WP_142444172.1 universal stress protein [Halonotius roseus] | diamond | 264 | 77.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius roseus | |
| 29300540 | 29300540 | PRJEB49404_P_NODE_354369_length_234_cov_1.323077_g340568_i0 | PRJEB49404 | 354369 | 234 | 1.323077 | 3.09600018 | root | 1 | Root_unresolved | Root_unresolved | 62.8 | 7.1e-10 | NR | MDG6937951.1 | 2026795 | g340568 | i0 | 72.5 | 1.56410256410256 | 40 | 11 | 51.3 | 0 | 115 | 234 | 89 | 128 | MDG6937951.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 366 | 62.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29875654 | 29875654 | PRJEB49404_P_NODE_430351_length_203_cov_1.000000_g416550_i0 | PRJEB49404 | 430351 | 203 | 1 | 2.03 | Halopenitus sp. H-Gu1 | 3242697 | Archaea | Archaea | 120 | 4.4599999999999996e-32 | NR | WP_373674591.1 | 3242697 | g416550 | i0 | 83.6 | 0.990147783251232 | 67 | 11 | 99 | 0 | 201 | 1 | 117 | 183 | WP_373674591.1 nitrous oxide reductase accessory protein NosL [Halopenitus sp. H-Gu1] | diamond | 201 | 120 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. H-Gu1 | |
| 30918372 | 30918372 | PRJEB49404_P_NODE_627794_length_154_cov_1.426087_g613993_i0 | PRJEB49404 | 627794 | 154 | 1.426087 | 2.19617398 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 55.8 | 2.64e-7 | NR | HVO78796.1 | 3045160 | g613993 | i0 | 59.2 | 1.92857142857143 | 49 | 19 | 95.5 | 1 | 147 | 1 | 7 | 54 | HVO78796.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Bathyarchaeia archaeon] | diamond | 297 | 55.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 32720373 | 32720373 | PRJEB49404_P_NODE_625180_length_155_cov_1.025862_g611379_i0 | PRJEB49404 | 625180 | 155 | 1.025862 | 1.5900861 | Natronomonas pharaonis | 2257 | Archaea | Archaea | 65.1 | 1.05e-10 | NR | WP_011323308.1 | 2257 | g611379 | i0 | 81.6 | 2.94193548387097 | 38 | 7 | 73.5 | 0 | 41 | 154 | 1 | 38 | WP_011323308.1 type II methionyl aminopeptidase [Natronomonas pharaonis] | diamond | 456 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas pharaonis |
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);;