contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2914927 | 2914927 | PRJNA168635_P_NODE_10523_length_254_cov_6.146341_g10108_i0 | PRJNA168635 | 10523 | 254 | 6.146341 | 15.61170614 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 455 | 1.5e-123 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g10108 | i0 | 99.206 | 114.224409448819 | 252 | 2 | 99 | 0 | 1 | 252 | 1231938 | 1231687 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 29013 | 455 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 6156947 | 6156947 | PRJNA168635_P_NODE_17605_length_191_cov_1.450704_g17189_i0 | PRJNA168635 | 17605 | 191 | 1.450704 | 2.77084464 | Halobacteriales | 2235 | Archaea | Archaea | 69.4 | 1.63e-7 | NTclustered | gi|222451341|gb|CP001365.1| | 416348 | g17189 | i0 | 89.474 | 0.895287958115183 | 57 | 3 | 28 | 1 | 1 | 54 | 1574733 | 1574677 | Halorubrum lacusprofundi ATCC 49239 chromosome 1, complete sequence | blastn | 171 | 69.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum lacusprofundi | |
| 6742052 | 6742052 | PRJNA168635_P_NODE_14406_length_212_cov_4.398773_g13990_i0 | PRJNA168635 | 14406 | 212 | 4.398773 | 9.32539876 | Methanothrix sp. | 90426 | Archaea | Archaea | 327 | 2.77e-85 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g13990 | i0 | 94.762 | 34.5518867924528 | 210 | 11 | 99 | 0 | 1 | 210 | 826609 | 826818 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 7325 | 327 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 7432161 | 7432161 | PRJNA168635_P_NODE_21966_length_176_cov_3.228346_g21550_i0 | PRJNA168635 | 21966 | 176 | 3.228346 | 5.68188896 | root | 1 | Root_unresolved | Root_unresolved | 309 | 7.98e-80 | NTclustered | gi|575790347|gb|KF697731.1| | 2162 | g21550 | i0 | 98.305 | 101.522727272727 | 177 | 2 | 100 | 1 | 1 | 176 | 670 | 846 | Methanobacterium sp. BRM9 16S ribosomal RNA gene, partial sequence | blastn | 17868 | 309 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 8017954 | 8017954 | PRJNA168635_P_NODE_32147_length_162_cov_0.920354_g31731_i0 | PRJNA168635 | 32147 | 162 | 0.920354 | 1.49097348 | Methanomassiliicoccaceae archaeon DOK | 1535962 | Archaea | Archaea | 300 | 4.36e-77 | NTclustered | gi|1799215713|gb|CP047880.1| | 1535962 | g31731 | i0 | 100 | 12.8456790123457 | 162 | 0 | 100 | 0 | 1 | 162 | 1503352 | 1503191 | Methanomassiliicoccaceae archaeon DOK chromosome, complete genome | blastn | 2081 | 300 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon DOK | |||
| 10568722 | 10568722 | PRJNA168635_P_NODE_34569_length_154_cov_3.428571_g34153_i0 | PRJNA168635 | 34569 | 154 | 3.428571 | 5.27999934 | Salinarchaeum sp. IM2453 | 2862870 | Archaea | Archaea | 82.4 | 1.61e-11 | NTclustered | gi|2082835402|gb|CP081183.1| | 2862870 | g34153 | i0 | 85.185 | 3.84415584415584 | 81 | 10 | 52 | 2 | 9 | 88 | 1215996 | 1216075 | Salinarchaeum sp. IM2453 chromosome, complete genome | blastn | 592 | 82.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum sp. IM2453 | |
| 11843331 | 11843331 | PRJNA168635_P_NODE_6590_length_330_cov_1.359431_g6179_i0 | PRJNA168635 | 6590 | 330 | 1.359431 | 4.4861223 | Haloprofundus salilacus | 2876190 | Archaea | Archaea | 442 | 1.5799999999999993e-119 | NTclustered | gi|2101339616|gb|CP083723.1| | 2876190 | g6179 | i0 | 91.589 | 179.824242424242 | 321 | 25 | 97 | 2 | 1 | 320 | 1068105 | 1068424 | Haloprofundus salilacus strain Gai1-5 chromosome unnamed1, complete sequence | blastn | 59342 | 442 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus salilacus | |
| 13807600 | 13807600 | PRJNA168635_P_NODE_18691_length_187_cov_1.420290_g18275_i0 | PRJNA168635 | 18691 | 187 | 1.42029 | 2.6559423 | Methanobacterium | 2160 | Archaea | Archaea | 213 | 6.94e-51 | NTclustered | gi|584298067|gb|KF882006.1| | 392018 | g18275 | i0 | 98.347 | 81.9732620320856 | 121 | 2 | 65 | 0 | 67 | 187 | 1065 | 945 | Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence | blastn | 15329 | 213 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alcaliphilum | |
| 16941669 | 16941669 | PRJNA168635_P_NODE_20034_length_182_cov_1.924812_g19618_i0 | PRJNA168635 | 20034 | 182 | 1.924812 | 3.50315784 | Methanomassiliicoccaceae archaeon DOK | 1535962 | Archaea | Archaea | 337 | 3.82e-88 | NTclustered | gi|1799215713|gb|CP047880.1| | 1535962 | g19618 | i0 | 100 | 69.3021978021978 | 182 | 0 | 100 | 0 | 1 | 182 | 1504448 | 1504267 | Methanomassiliicoccaceae archaeon DOK chromosome, complete genome | blastn | 12613 | 337 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon DOK | |||
| 16942016 | 16942016 | PRJNA168635_P_NODE_7994_length_298_cov_5030.787149_g7580_i0 | PRJNA168635 | 7994 | 298 | 5030.787149 | 14991.74570402 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 536 | 6.269999999999998e-148 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g7580 | i0 | 99.659 | 248.328859060403 | 293 | 1 | 98 | 0 | 1 | 293 | 3117413 | 3117121 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 74002 | 536 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 17631860 | 17631860 | PRJNA168635_P_NODE_19354_length_184_cov_4.214815_g18938_i0 | PRJNA168635 | 19354 | 184 | 4.214815 | 7.7552596 | Methanobacterium | 2160 | Archaea | Archaea | 285 | 1.42e-72 | NTclustered | gi|584298059|gb|KF881998.1| | 2161 | g18938 | i0 | 95.506 | 158.79347826087 | 178 | 8 | 97 | 0 | 7 | 184 | 1774 | 1951 | Methanobacterium bryantii strain M.o.H. 23S ribosomal RNA gene, partial sequence | blastn | 29218 | 285 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium bryantii | |
| 18216056 | 18216056 | PRJNA168635_P_NODE_1455_length_655_cov_2451.755776_g1120_i0 | PRJNA168635 | 1455 | 655 | 2451.755776 | 16059.0003328 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 658 | 0 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g1120 | i0 | 88.225 | 161.377099236641 | 586 | 23 | 88 | 23 | 1 | 575 | 3117296 | 3117846 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 105702 | 658 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 18905653 | 18905653 | PRJNA168635_P_NODE_19375_length_184_cov_3.481481_g18959_i0 | PRJNA168635 | 19375 | 184 | 3.481481 | 6.40592504 | Methanothrix | 2222 | Archaea | Archaea | 318 | 1.3999999999999995e-82 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g18959 | i0 | 97.826 | 60.304347826087 | 184 | 4 | 100 | 0 | 1 | 184 | 1755 | 1938 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 11096 | 318 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 19490379 | 19490379 | PRJNA168635_P_NODE_19076_length_185_cov_4.125000_g18660_i0 | PRJNA168635 | 19076 | 185 | 4.125 | 7.63125 | uncultured Methanolinea sp. | 521103 | Archaea | Archaea | 331 | 1.81e-86 | NTclustered | gi|310331053|gb|HQ049554.1| | 521103 | g18660 | i0 | 98.919 | 99.8648648648649 | 185 | 2 | 100 | 0 | 1 | 185 | 28 | 212 | Uncultured Methanolinea sp. clone F5OHPNU07IJ53S 16S ribosomal RNA gene, partial sequence | blastn | 18475 | 331 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanolinea | uncultured Methanolinea sp. | |
| 19490504 | 19490504 | PRJNA168635_P_NODE_27476_length_167_cov_0.881356_g27060_i0 | PRJNA168635 | 27476 | 167 | 0.881356 | 1.47186452 | Halarchaeum sp. CBA1220 | 1853682 | Archaea | Archaea | 54.7 | 0.004 | NTclustered | gi|1864269003|gb|CP054707.1| | 1853682 | g27060 | i0 | 96.875 | 0.191616766467066 | 32 | 1 | 19 | 0 | 105 | 136 | 120289 | 120320 | Halarchaeum sp. CBA1220 chromosome, complete genome | blastn | 32 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halarchaeum | Halarchaeum sp. CBA1220 | |
| 20766238 | 20766238 | PRJNA168635_P_NODE_3977_length_420_cov_7.816712_g3576_i0 | PRJNA168635 | 3977 | 420 | 7.816712 | 32.8301904 | Haloarcula hispanica | 51589 | Archaea | Archaea | 86.1 | 3.99e-12 | NTclustered | gi|772242000|gb|KP076307.1| | 51589 | g3576 | i0 | 83.505 | 20.802380952381 | 97 | 10 | 23 | 6 | 179 | 273 | 1283 | 1191 | Haloarcula hispanica strain RM-G12 16S ribosomal RNA gene, partial sequence | blastn | 8737 | 86.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula hispanica | |
| 22730941 | 22730941 | PRJNA168635_P_NODE_11838_length_238_cov_0.941799_g11422_i0 | PRJNA168635 | 11838 | 238 | 0.941799 | 2.24148162 | Methanobacterium | 2160 | Archaea | Archaea | 335 | 1.9e-87 | NTclustered | gi|584298058|gb|KF881997.1| | 256826 | g11422 | i0 | 92.05 | 147.453781512605 | 239 | 18 | 100 | 1 | 1 | 238 | 2135 | 2373 | Methanobacterium aarhusense strain H2-LR 23S ribosomal RNA gene, partial sequence | blastn | 35094 | 335 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium aarhusense | |
| 23316571 | 23316571 | PRJNA168635_P_NODE_21679_length_177_cov_1.921875_g21263_i0 | PRJNA168635 | 21679 | 177 | 1.921875 | 3.40171875 | Methanobacterium alcaliphilum | 392018 | Archaea | Archaea | 222 | 1.08e-53 | NTclustered | gi|584298067|gb|KF882006.1| | 392018 | g21263 | i0 | 89.326 | 108.576271186441 | 178 | 18 | 100 | 1 | 1 | 177 | 1197 | 1374 | Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence | blastn | 19218 | 222 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alcaliphilum | |
| 23316612 | 23316612 | PRJNA168635_P_NODE_24079_length_171_cov_2.295082_g23663_i0 | PRJNA168635 | 24079 | 171 | 2.295082 | 3.92459022 | Haloferacaceae archaeon | 2080321 | Archaea | Archaea | 189 | 1.0499999999999996e-43 | NTclustered | gi|2874253923|emb|OY970248.1| | 2080321 | g23663 | i0 | 87.654 | 173.894736842105 | 162 | 20 | 95 | 0 | 10 | 171 | 49887 | 50048 | MAG: Haloferacaceae archaeon isolate MFD01721.bin.c.6 genome assembly, chromosome: 1 | blastn | 29736 | 189 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon | ||
| 24590512 | 24590512 | PRJNA168635_P_NODE_11460_length_242_cov_2.036269_g11044_i0 | PRJNA168635 | 11460 | 242 | 2.036269 | 4.92777098 | uncultured euryarchaeote | 114243 | Archaea | Archaea | 361 | 3.19e-95 | NTclustered | gi|619321767|gb|KJ566504.1| | 114243 | g11044 | i0 | 93.443 | 96.8471074380165 | 244 | 14 | 100 | 1 | 1 | 242 | 199 | 442 | Uncultured euryarchaeote clone S2D01344af 16S ribosomal RNA gene, partial sequence | blastn | 23437 | 361 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured euryarchaeote | ||||||
| 24591026 | 24591026 | PRJNA168635_P_NODE_7680_length_304_cov_1120.807843_g7267_i0 | PRJNA168635 | 7680 | 304 | 1120.807843 | 3407.25584272 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 473 | 5.1e-129 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g7267 | i0 | 94.771 | 316.388157894737 | 306 | 12 | 100 | 4 | 1 | 304 | 3117478 | 3117175 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 96182 | 473 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. |
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);;