contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 727430 | 727430 | PRJNA752278_P_NODE_41261_length_285_cov_3.089623_g41058_i0 | PRJNA752278 | 41261 | 285 | 3.089623 | 8.80542555 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 329 | 1.09e-85 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g41058 | i0 | 87.633 | 9.88070175438597 | 283 | 35 | 99 | 0 | 3 | 285 | 2196015 | 2196297 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 2816 | 329 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 727815 | 727815 | PRJNA752278_P_NODE_62041_length_266_cov_1.310881_g61838_i0 | PRJNA752278 | 62041 | 266 | 1.310881 | 3.48694346 | Halarchaeum sp. CBA1220 | 1853682 | Archaea | Archaea | 128 | 3.93e-25 | NTclustered | gi|1864269003|gb|CP054707.1| | 1853682 | g61838 | i0 | 89.899 | 1.04135338345865 | 99 | 10 | 37 | 0 | 166 | 264 | 760604 | 760702 | Halarchaeum sp. CBA1220 chromosome, complete genome | blastn | 277 | 128 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halarchaeum | Halarchaeum sp. CBA1220 | |
| 5028915 | 5028915 | PRJNA752278_P_NODE_15424_length_389_cov_1.541139_g15221_i0 | PRJNA752278 | 15424 | 389 | 1.541139 | 5.99503071 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 7.99e-4 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g15221 | i0 | 100 | 5.59383033419023 | 31 | 0 | 8 | 0 | 105 | 135 | 906802 | 906772 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 2176 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 8381578 | 8381578 | PRJNA752278_P_NODE_85647_length_248_cov_0.880000_g85444_i0 | PRJNA752278 | 85647 | 248 | 0.88 | 2.1824 | Salinirubellus salinus | 1364945 | Archaea | Archaea | 237 | 5.77e-58 | NTclustered | gi|2297614754|gb|CP104003.1| | 1364945 | g85444 | i0 | 85.778 | 36.3790322580645 | 225 | 30 | 90 | 2 | 25 | 248 | 560745 | 560522 | Salinirubellus salinus strain ZS-35-S2 chromosome, complete genome | blastn | 9022 | 237 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus salinus | |
| 9655239 | 9655239 | PRJNA752278_P_NODE_105188_length_241_cov_0.916667_g104985_i0 | PRJNA752278 | 105188 | 241 | 0.916667 | 2.20916747 | Halorientalis litorea | 2931977 | Archaea | Archaea | 274 | 4.2499999999999997e-69 | NTclustered | gi|2225350816|gb|CP095482.1| | 2931977 | g104985 | i0 | 87.395 | 99.4564315352697 | 238 | 30 | 99 | 0 | 1 | 238 | 1205195 | 1205432 | Halorientalis litorea strain ZY14 chromosome, complete genome | blastn | 23969 | 274 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis litorea | |
| 9655983 | 9655983 | PRJNA752278_P_NODE_42248_length_284_cov_2.824645_g42045_i0 | PRJNA752278 | 42248 | 284 | 2.824645 | 8.0219918 | Halobellus inordinatus | 1126236 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2279714123|gb|CP101825.1| | 1126236 | g42045 | i0 | 100 | 0.102112676056338 | 29 | 0 | 10 | 0 | 172 | 200 | 1001867 | 1001895 | Halobellus inordinatus strain DSM 26177 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus inordinatus | |
| 11404827 | 11404827 | PRJNA752278_P_NODE_52469_length_275_cov_1.287129_g52266_i0 | PRJNA752278 | 52469 | 275 | 1.287129 | 3.53960475 | Methanosarcina | 2207 | Archaea | Archaea | 503 | 5.809999999999998e-138 | NTclustered | gi|410699094|gb|JX560180.1| | 2209 | g52266 | i0 | 99.636 | 115.185454545455 | 275 | 1 | 100 | 0 | 1 | 275 | 281 | 555 | Methanosarcina mazei strain KOR-6 16S ribosomal RNA gene, partial sequence | blastn | 31676 | 503 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 14757176 | 14757176 | PRJNA752278_P_NODE_84712_length_248_cov_2.057143_g84509_i0 | PRJNA752278 | 84712 | 248 | 2.057143 | 5.10171464 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 139 | 1.67e-28 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g84509 | i0 | 78.138 | 20.7701612903226 | 247 | 34 | 99 | 11 | 2 | 248 | 1282840 | 1283066 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 5151 | 139 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 15229408 | 15229408 | PRJNA752278_P_NODE_36192_length_290_cov_2.944700_g35989_i0 | PRJNA752278 | 36192 | 290 | 2.9447 | 8.53963 | Halobacteriales | 2235 | Archaea | Archaea | 67.6 | 9.59e-7 | NTclustered | gi|1336549475|gb|CP026309.1| | 755307 | g35989 | i0 | 97.436 | 1.62068965517241 | 39 | 1 | 13 | 0 | 246 | 284 | 2365683 | 2365721 | Salinigranum rubrum strain GX10 chromosome, complete genome | blastn | 470 | 67.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 24954625 | 24954625 | PRJNA752278_P_NODE_74740_length_253_cov_2.516667_g74537_i0 | PRJNA752278 | 74740 | 253 | 2.516667 | 6.36716751 | Halalkaliarchaeum sp. AArc-CO | 2866381 | Archaea | Archaea | 71.3 | 6.34e-8 | NTclustered | gi|2295229904|gb|CP087723.1| | 2866381 | g74537 | i0 | 92 | 9.11462450592885 | 50 | 4 | 20 | 0 | 17 | 66 | 2814536 | 2814487 | Halalkaliarchaeum sp. AArc-CO chromosome, complete genome | blastn | 2306 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halalkaliarchaeum | Halalkaliarchaeum sp. AArc-CO |
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);;