contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118448 | 1118448 | PRJNA541476_P_NODE_40461_length_242_cov_0.887574_g40255_i0 | PRJNA541476 | 40461 | 242 | 0.887574 | 2.14792908 | Halobacteriales | 2235 | Archaea | Archaea | 431 | 2.4e-116 | NTclustered | gi|1041620905|dbj|AP017571.1| | 29284 | g40255 | i0 | 98.76 | 10 | 242 | 3 | 100 | 0 | 1 | 242 | 18765 | 18524 | Halorubrum trapanicum plasmid pCBA1232-02 DNA, complete genome, strain: CBA1232 | blastn | 2420 | 431 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 1784314 | 1784314 | PRJNA541476_P_NODE_31822_length_249_cov_0.886364_g31616_i0 | PRJNA541476 | 31822 | 249 | 0.886364 | 2.20704636 | Salinirarus marinus | 3068310 | Archaea | Archaea | 169 | 2.1399999999999996e-37 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g31616 | i0 | 83.799 | 2.85943775100402 | 179 | 27 | 71 | 2 | 72 | 249 | 11519 | 11696 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 712 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 1784322 | 1784322 | PRJNA541476_P_NODE_32062_length_249_cov_0.880682_g31856_i0 | PRJNA541476 | 32062 | 249 | 0.880682 | 2.19289818 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 268 | 2.06e-67 | NTclustered | gi|933677909|gb|CP011564.1| | 1604004 | g31856 | i0 | 87.288 | 11.7630522088353 | 236 | 29 | 95 | 1 | 13 | 248 | 1766287 | 1766521 | Halanaeroarchaeum sulfurireducens strain M27-SA2, complete genome | blastn | 2929 | 268 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 3059910 | 3059910 | PRJNA541476_P_NODE_35343_length_246_cov_0.890173_g35137_i0 | PRJNA541476 | 35343 | 246 | 0.890173 | 2.18982558 | Halospeciosus flavus | 3032283 | Archaea | Archaea | 244 | 3.42e-60 | NTclustered | gi|2490484842|gb|CP122312.1| | 3032283 | g35137 | i0 | 84.585 | 12.5528455284553 | 253 | 31 | 100 | 7 | 1 | 246 | 596811 | 596560 | Halospeciosus flavus strain XZGYJ-43 chromosome | blastn | 3088 | 244 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halospeciosus | Halospeciosus flavus | |
| 4336040 | 4336040 | PRJNA541476_P_NODE_37164_length_244_cov_0.912281_g36958_i0 | PRJNA541476 | 37164 | 244 | 0.912281 | 2.22596564 | Natronococcus occultus | 29288 | Archaea | Archaea | 228 | 3.409999999999999e-55 | NTclustered | gi|433671692|gb|CP003929.1| | 694430 | g36958 | i0 | 84.034 | 4.68032786885246 | 238 | 36 | 97 | 2 | 6 | 242 | 3621317 | 3621081 | Natronococcus occultus SP4, complete genome | blastn | 1142 | 228 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus occultus | |
| 4336140 | 4336140 | PRJNA541476_P_NODE_39784_length_242_cov_0.923077_g39578_i0 | PRJNA541476 | 39784 | 242 | 0.923077 | 2.23384634 | Salinibaculum marinum | 3131993 | Archaea | Archaea | 359 | 1.15e-94 | NTclustered | gi|2700494404|gb|CP147839.1| | 3131993 | g39578 | i0 | 93.388 | 2.50826446280992 | 242 | 16 | 100 | 0 | 1 | 242 | 37895 | 38136 | Salinibaculum marinum strain SYNS191 plasmid unnamed1, complete sequence | blastn | 607 | 359 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | Salinibaculum marinum | |
| 8161538 | 8161538 | PRJNA541476_P_NODE_26427_length_258_cov_1.556757_g26221_i0 | PRJNA541476 | 26427 | 258 | 1.556757 | 4.01643306 | Natrinema thermotolerans | 121872 | Archaea | Archaea | 298 | 2.73e-76 | NTclustered | gi|1621090060|gb|CP031304.1| | 121872 | g26221 | i0 | 91.981 | 5.75193798449612 | 212 | 17 | 82 | 0 | 47 | 258 | 946442 | 946653 | Natrinema thermotolerans strain A29 plasmid unnamed6, complete sequence | blastn | 1484 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema thermotolerans | |
| 9437118 | 9437118 | PRJNA541476_P_NODE_30588_length_250_cov_1.033898_g30382_i0 | PRJNA541476 | 30588 | 250 | 1.033898 | 2.584745 | Halolamina sp. CBA1230 | 1853690 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|1861362334|gb|CP054587.1| | 1853690 | g30382 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 25 | 52 | 2316153 | 2316126 | Halolamina sp. CBA1230 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. CBA1230 | |
| 11987539 | 11987539 | PRJNA541476_P_NODE_28330_length_253_cov_0.866667_g28124_i0 | PRJNA541476 | 28330 | 253 | 0.866667 | 2.19266751 | Halorussus vallis | 2953749 | Archaea | Archaea | 298 | 2.6699999999999998e-76 | NTclustered | gi|2263971171|gb|CP100004.1| | 2953749 | g28124 | i0 | 97.159 | 0.695652173913043 | 176 | 5 | 70 | 0 | 2 | 177 | 76013 | 76188 | Halorussus vallis strain XZYJT10 plasmid unnamed4, complete sequence | blastn | 176 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 14537399 | 14537399 | PRJNA541476_P_NODE_22272_length_273_cov_1.080000_g22066_i0 | PRJNA541476 | 22272 | 273 | 1.08 | 2.9484 | Haloferax volcanii | 2246 | Archaea | Archaea | 412 | 9.98e-111 | NTclustered | gi|2459776771|gb|CP104742.1| | 2246 | g22066 | i0 | 94.096 | 1.9047619047619 | 271 | 16 | 99 | 0 | 1 | 271 | 275805 | 275535 | Haloferax volcanii strain SVX82 plasmid pSVX82-1, complete sequence | blastn | 520 | 412 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 15811693 | 15811693 | PRJNA541476_P_NODE_31793_length_249_cov_0.886364_g31587_i0 | PRJNA541476 | 31793 | 249 | 0.886364 | 2.20704636 | Salinirarus marinus | 3068310 | Archaea | Archaea | 363 | 9.169999999999997e-96 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g31587 | i0 | 93.117 | 0.991967871485944 | 247 | 17 | 99 | 0 | 1 | 247 | 2444756 | 2444510 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 247 | 363 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 17085932 | 17085932 | PRJNA541476_P_NODE_14394_length_314_cov_1.290456_g14188_i0 | PRJNA541476 | 14394 | 314 | 1.290456 | 4.05203184 | Halobellus limi | 699433 | Archaea | Archaea | 69.4 | 2.92e-7 | NTclustered | gi|1621075116|gb|CP031311.1| | 699433 | g14188 | i0 | 87.302 | 5.4968152866242 | 63 | 5 | 19 | 2 | 252 | 311 | 1539057 | 1539119 | Halobellus limi strain CGMCC 1.10331 chromosome, complete genome | blastn | 1726 | 69.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi |
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);;