contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25559797 | 25559797 | PRJNA1233465f_S_NODE_56857_length_303_cov_4.948819_g54577_i0 | PRJNA1233465 | 56857 | 303 | 4.948819 | 14.99492157 | Halogeometricum borinquense | 60847 | Archaea | Archaea | 58.4 | 6.07e-4 | NTclustered | gi|1810666233|gb|CP048739.1| | 60847 | g54577 | i0 | 97.059 | 1.36303630363036 | 34 | 1 | 11 | 0 | 141 | 174 | 812697 | 812730 | Halogeometricum borinquense strain wsp4 chromosome, complete genome | blastn | 413 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogeometricum | Halogeometricum borinquense | |
| 25672497 | 25672497 | PRJNA1233465b_S_NODE_123122_length_254_cov_61.921951_g121437_i0 | PRJNA1233465 | 123122 | 254 | 61.921951 | 157.28175554 | Methanosalsum zhilinae DSM 4 | 39669 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g121437 | i0 | 100 | 0.118110236220472 | 30 | 0 | 12 | 0 | 99 | 128 | 1665167 | 1665138 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 25685121 | 25685121 | PRJNA1233465e_S_NODE_45618_length_267_cov_4.605505_g44308_i0 | PRJNA1233465 | 45618 | 267 | 4.605505 | 12.29669835 | Methanosalsum zhilinae DSM 4 | 39669 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g44308 | i0 | 100 | 0.112359550561798 | 30 | 0 | 11 | 0 | 116 | 145 | 1665167 | 1665138 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 25687658 | 25687658 | PRJNA1233465f_S_NODE_110914_length_228_cov_6.770950_g108634_i0 | PRJNA1233465 | 110914 | 228 | 6.77095 | 15.437766 | Methanosalsum zhilinae DSM 4 | 39669 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g108634 | i0 | 100 | 0.131578947368421 | 30 | 0 | 13 | 0 | 88 | 117 | 1665167 | 1665138 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 25810342 | 25810342 | PRJNA1233465b_S_NODE_250635_length_190_cov_1.085106_g248950_i0 | PRJNA1233465 | 250635 | 190 | 1.085106 | 2.0617014 | Halobacterium sp. DL1 | 751944 | Archaea | Archaea | 145 | 2.6199999999999997e-30 | NTclustered | gi|573484043|gb|CP007060.1| | 751944 | g248950 | i0 | 88.889 | 72.9473684210526 | 117 | 13 | 64 | 0 | 72 | 188 | 1487658 | 1487774 | Halobacterium sp. DL1, complete genome | blastn | 13860 | 145 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. DL1 | |
| 25811721 | 25811721 | PRJNA1233465b_S_NODE_362963_length_162_cov_1.504425_g361278_i0 | PRJNA1233465 | 362963 | 162 | 1.504425 | 2.4371685 | Salinirubellus salinus | 1364945 | Archaea | Archaea | 71.3 | 3.72e-8 | NTclustered | gi|2297614754|gb|CP104003.1| | 1364945 | g361278 | i0 | 100 | 1.03086419753086 | 38 | 0 | 23 | 0 | 36 | 73 | 2448714 | 2448751 | Salinirubellus salinus strain ZS-35-S2 chromosome, complete genome | blastn | 167 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus salinus | |
| 25821098 | 25821098 | PRJNA1233465e_S_NODE_39331_length_285_cov_1.266949_g38021_i0 | PRJNA1233465 | 39331 | 285 | 1.266949 | 3.61080465 | Halogeometricum borinquense | 60847 | Archaea | Archaea | 58.4 | 5.66e-4 | NTclustered | gi|1810666233|gb|CP048739.1| | 60847 | g38021 | i0 | 97.059 | 1.44912280701754 | 34 | 1 | 12 | 0 | 30 | 63 | 812730 | 812697 | Halogeometricum borinquense strain wsp4 chromosome, complete genome | blastn | 413 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogeometricum | Halogeometricum borinquense | |
| 25946122 | 25946122 | PRJNA1233465b_S_NODE_217412_length_202_cov_1.333333_g215727_i0 | PRJNA1233465 | 217412 | 202 | 1.333333 | 2.69333266 | Halapricum desulfuricans | 2841257 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|1995635729|gb|CP064789.1| | 2841257 | g215727 | i0 | 96.97 | 0.326732673267327 | 33 | 0 | 16 | 1 | 7 | 38 | 2787879 | 2787911 | Halapricum desulfuricans strain HSR-Bgl chromosome, complete genome | blastn | 66 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum desulfuricans | |
| 25952625 | 25952625 | PRJNA1233465d_S_NODE_64484_length_218_cov_2.426036_g63373_i0 | PRJNA1233465 | 64484 | 218 | 2.426036 | 5.28875848 | Methanosalsum zhilinae DSM 4 | 39669 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g63373 | i0 | 100 | 0.137614678899083 | 30 | 0 | 14 | 0 | 106 | 135 | 1665138 | 1665167 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 26102444 | 26102444 | PRJNA1233465f_S_NODE_258733_length_162_cov_2.973451_g256453_i0 | PRJNA1233465 | 258733 | 162 | 2.973451 | 4.81699062 | uncultured Methanospirillum sp. | 262503 | Archaea | Archaea | 99 | 1.71e-16 | NTclustered | gi|2621706206|emb|OY764544.1| | 262503 | g256453 | i0 | 85.87 | 1.16049382716049 | 92 | 13 | 57 | 0 | 18 | 109 | 1042088 | 1041997 | MAG: uncultured Methanospirillum sp. isolate ae1c6b73-8e60-4006-a0f9-e2019dc13642 genome assembly, chromosome: 1 | blastn | 188 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | uncultured Methanospirillum sp. | |
| 26227697 | 26227697 | PRJNA1233465e_S_NODE_140798_length_168_cov_0.907563_g139488_i0 | PRJNA1233465 | 140798 | 168 | 0.907563 | 1.52470584 | Methanothrix sp. | 90426 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|2133325659|gb|CP086218.1| | 90426 | g139488 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 75 | 102 | 336622 | 336595 | MAG: Methanothrix sp. isolate MAG 280 chromosome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 26351885 | 26351885 | PRJNA1233465a_S_NODE_74591_length_255_cov_26.873786_g73317_i0 | PRJNA1233465 | 74591 | 255 | 26.873786 | 68.5281543 | Methanosalsum zhilinae DSM 4 | 39669 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g73317 | i0 | 100 | 0.117647058823529 | 30 | 0 | 12 | 0 | 127 | 156 | 1665138 | 1665167 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 26494104 | 26494104 | PRJNA1233465d_S_NODE_116896_length_171_cov_1.852459_g115785_i0 | PRJNA1233465 | 116896 | 171 | 1.852459 | 3.16770489 | Halogeometricum borinquense | 60847 | Archaea | Archaea | 58.4 | 3.08e-4 | NTclustered | gi|1810666233|gb|CP048739.1| | 60847 | g115785 | i0 | 97.059 | 0.39766081871345 | 34 | 1 | 20 | 0 | 96 | 129 | 812730 | 812697 | Halogeometricum borinquense strain wsp4 chromosome, complete genome | blastn | 68 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogeometricum | Halogeometricum borinquense |
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);;