contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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. | |
| 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 | |
| 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. | |
| 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 | |
| 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 | ||
| 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);;