contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3770542 | 3770542 | PRJNA799842_P_NODE_153983_length_248_cov_0.880000_g152410_i0 | PRJNA799842 | 153983 | 248 | 0.88 | 2.1824 | Methanothrix | 2222 | Archaea | Archaea | 149 | 1.33e-39 | NR | MDD2755312.1 | 90426 | g152410 | i0 | 92.7 | 12.8588709677419 | 82 | 6 | 99.2 | 0 | 247 | 2 | 500 | 581 | MDD2755312.1 formate dehydrogenase subunit alpha [Methanothrix sp.] | diamond | 3189 | 149 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 26610621 | 26610621 | PRJNA799842_P_NODE_108181_length_281_cov_1.341346_g106608_i0 | PRJNA799842 | 108181 | 281 | 1.341346 | 3.76918226 | Methanoregula sp. | 2052170 | Archaea | Archaea | 162 | 1.72e-49 | NR | HJX55558.1 | 2052170 | g106608 | i0 | 98.7 | 0.822064056939502 | 77 | 1 | 82.2 | 0 | 1 | 231 | 35 | 111 | HJX55558.1 thioredoxin family protein [Methanoregula sp.] | diamond | 231 | 162 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 26673826 | 26673826 | PRJNA799842_P_NODE_166781_length_245_cov_0.895349_g165208_i0 | PRJNA799842 | 166781 | 245 | 0.895349 | 2.19360505 | Methanothrix sp. | 90426 | Archaea | Archaea | 157 | 5.16e-46 | NR | HOV52868.1 | 90426 | g165208 | i0 | 92.3 | 0.955102040816327 | 78 | 6 | 95.5 | 0 | 245 | 12 | 177 | 254 | HOV52868.1 XkdF-like putative serine protease domain-containing protein [Methanothrix sp.] | diamond | 234 | 157 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 26990486 | 26990486 | PRJNA799842_P_NODE_147442_length_249_cov_0.875000_g145869_i0 | PRJNA799842 | 147442 | 249 | 0.875 | 2.17875 | Methanosarcinaceae archaeon | 1945595 | Archaea | Archaea | 67.4 | 8.02e-11 | NR | MCG7852707.1 | 1945595 | g145869 | i0 | 41.2 | 1.02409638554217 | 85 | 42 | 97.6 | 2 | 244 | 2 | 312 | 392 | MCG7852707.1 recombinase family protein [Methanosarcinaceae archaeon] | diamond | 255 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcinaceae archaeon | ||
| 27211864 | 27211864 | PRJNA799842_P_NODE_167742_length_245_cov_0.895349_g166169_i0 | PRJNA799842 | 167742 | 245 | 0.895349 | 2.19360505 | Natronorubrum tibetense | 63128 | Archaea | Archaea | 40.8 | 0.0445 | NR | WP_027119216.1 | 63128 | g166169 | i0 | 37.5 | 0.587755102040816 | 48 | 30 | 58.8 | 0 | 198 | 55 | 28 | 75 | WP_027119216.1 hypothetical protein [Natronorubrum tibetense] | diamond | 144 | 40.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum tibetense | |
| 27243627 | 27243627 | PRJNA799842_P_NODE_148163_length_249_cov_0.875000_g146590_i0 | PRJNA799842 | 148163 | 249 | 0.875 | 2.17875 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 137 | 1.43e-38 | NR | MDM7913628.1 | 2595067 | g146590 | i0 | 81.7 | 1.97590361445783 | 82 | 15 | 98.8 | 0 | 4 | 249 | 2 | 83 | MDM7913628.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanotrichaceae archaeon] | diamond | 492 | 137 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 27527931 | 27527931 | PRJNA799842_P_NODE_179343_length_243_cov_0.905882_g177770_i0 | PRJNA799842 | 179343 | 243 | 0.905882 | 2.20129326 | Methanoregula sp. | 2052170 | Archaea | Archaea | 165 | 2.49e-49 | NR | HJX56264.1 | 2052170 | g177770 | i0 | 96.3 | 0.987654320987654 | 80 | 3 | 98.8 | 0 | 241 | 2 | 22 | 101 | HJX56264.1 glycosyltransferase [Methanoregula sp.] | diamond | 240 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 28348886 | 28348886 | PRJNA799842_P_NODE_177286_length_243_cov_0.905882_g175713_i0 | PRJNA799842 | 177286 | 243 | 0.905882 | 2.20129326 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 148 | 2.08e-43 | NR | MCJ7443917.1 | 2595067 | g175713 | i0 | 88.8 | 8.88888888888889 | 80 | 9 | 98.8 | 0 | 242 | 3 | 56 | 135 | MCJ7443917.1 30S ribosomal protein S7 [Methanotrichaceae archaeon] | diamond | 2160 | 148 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 28443814 | 28443814 | PRJNA799842_P_NODE_187546_length_241_cov_0.916667_g185973_i0 | PRJNA799842 | 187546 | 241 | 0.916667 | 2.20916747 | Methanoculleus bourgensis | 83986 | Archaea | Archaea | 43.9 | 0.00238 | NR | WP_062263040.1 | 83986 | g185973 | i0 | 73.1 | 0.647302904564315 | 26 | 7 | 32.4 | 0 | 163 | 240 | 1 | 26 | WP_062263040.1 hypothetical protein [Methanoculleus bourgensis] | diamond | 156 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus bourgensis | |
| 28506815 | 28506815 | PRJNA799842_P_NODE_163667_length_246_cov_0.890173_g162094_i0 | PRJNA799842 | 163667 | 246 | 0.890173 | 2.18982558 | Methanoregula sp. | 2052170 | Archaea | Archaea | 69.3 | 1.39e-12 | NR | HJX55893.1 | 2052170 | g162094 | i0 | 97.3 | 0.451219512195122 | 37 | 1 | 45.1 | 0 | 244 | 134 | 20 | 56 | HJX55893.1 HEAT repeat domain-containing protein [Methanoregula sp.] | diamond | 111 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 28538563 | 28538563 | PRJNA799842_P_NODE_138387_length_251_cov_0.865169_g136814_i0 | PRJNA799842 | 138387 | 251 | 0.865169 | 2.17157419 | Candidatus Methanoperedenaceae archaeon GB5 | 2072416 | Archaea | Archaea | 92 | 8.41e-20 | NR | CAD7780153.1 | 2691038 | g136814 | i0 | 54.2 | 0.99203187250996006 | 83 | 38 | 99.2 | 0 | 250 | 2 | 122 | 204 | CAD7780153.1 MAG: D-inositol-3-phosphate glycosyltransferase [Candidatus Methanoperedenaceae archaeon GB50] | diamond | 249 | 92 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedenaceae archaeon GB50 | ||
| 28894537 | 28894537 | PRJNA799842_P_NODE_88128_length_309_cov_0.936441_g86555_i0 | PRJNA799842 | 88128 | 309 | 0.936441 | 2.89360269 | Methanothrix | 2222 | Archaea | Archaea | 162 | 4.8e-45 | NR | MCX6677994.1 | 90426 | g86555 | i0 | 76.5 | 6.93203883495146 | 102 | 24 | 99 | 0 | 2 | 307 | 166 | 267 | MCX6677994.1 alternate F1F0 ATPase, F1 subunit alpha [Methanothrix sp.] | diamond | 2142 | 162 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 29106775 | 29106775 | PRJNA799842_P_NODE_142848_length_250_cov_0.870056_g141275_i0 | PRJNA799842 | 142848 | 250 | 0.870056 | 2.17514 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 128 | 2.86e-36 | NR | MCX9028946.1 | 2032688 | g141275 | i0 | 69.9 | 3.96 | 83 | 25 | 99.6 | 0 | 2 | 250 | 27 | 109 | MCX9028946.1 circadian clock KaiB family protein [Candidatus Methanoperedens sp.] | diamond | 990 | 128 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29611541 | 29611541 | PRJNA799842_P_NODE_143250_length_250_cov_0.870056_g141677_i0 | PRJNA799842 | 143250 | 250 | 0.870056 | 2.17514 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 73.6 | 5.8e-13 | NR | NJD78151.1 | 2032688 | g141677 | i0 | 60.7 | 1.404 | 56 | 22 | 67.2 | 0 | 58 | 225 | 636 | 691 | NJD78151.1 hypothetical protein [Candidatus Methanoperedens sp.] | diamond | 351 | 73.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29927879 | 29927879 | PRJNA799842_P_NODE_91851_length_303_cov_0.921739_g90278_i0 | PRJNA799842 | 91851 | 303 | 0.921739 | 2.79286917 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 112 | 1.62e-29 | NR | MDD1679371.1 | 2184052 | g90278 | i0 | 87.5 | 0.554455445544555 | 56 | 7 | 55.4 | 0 | 287 | 120 | 72 | 127 | MDD1679371.1 rubredoxin [Methanomicrobiales archaeon] | diamond | 168 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 30022588 | 30022588 | PRJNA799842_P_NODE_146851_length_249_cov_0.875000_g145278_i0 | PRJNA799842 | 146851 | 249 | 0.875 | 2.17875 | Methanosaeta sp. PtaB.Bin | 90426 | Archaea | Archaea | 83.2 | 2.42e-16 | NR | OPX80448.1 | 1811685 | g145278 | i0 | 83 | 0.566265060240964 | 47 | 8 | 56.6 | 0 | 1 | 141 | 382 | 428 | OPX80448.1 MAG: hypothetical protein A4E45_00068 [Methanosaeta sp. PtaB.Bin039] | diamond | 141 | 83.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaB.Bin039 | |
| 30180315 | 30180315 | PRJNA799842_P_NODE_177072_length_243_cov_0.905882_g175499_i0 | PRJNA799842 | 177072 | 243 | 0.905882 | 2.20129326 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 50.1 | 9.47e-5 | NR | RCV65819.1 | 2056316 | g175499 | i0 | 45.3 | 0.654320987654321 | 53 | 29 | 65.4 | 0 | 241 | 83 | 89 | 141 | RCV65819.1 hypothetical protein C5S53_01845, partial [Candidatus Methanophagales archaeon] | diamond | 159 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 30275471 | 30275471 | PRJNA799842_P_NODE_164632_length_246_cov_0.890173_g163059_i0 | PRJNA799842 | 164632 | 246 | 0.890173 | 2.18982558 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 140 | 1.64e-36 | NR | HWR98763.1 | 2032688 | g163059 | i0 | 80.2 | 1.97560975609756 | 81 | 16 | 98.8 | 0 | 244 | 2 | 632 | 712 | HWR98763.1 hypothetical protein [Candidatus Methanoperedens sp.] | diamond | 486 | 140 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 30275472 | 30275472 | PRJNA799842_P_NODE_167972_length_245_cov_0.895349_g166399_i0 | PRJNA799842 | 167972 | 245 | 0.895349 | 2.19360505 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 103 | 1.58e-24 | NR | MDD1758019.1 | 2595067 | g166399 | i0 | 63 | 0.991836734693878 | 81 | 30 | 99.2 | 0 | 3 | 245 | 152 | 232 | MDD1758019.1 heme o synthase [Methanotrichaceae archaeon] | diamond | 243 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 30347891 | 30347891 | PRJNA799842_P_NODE_147092_length_249_cov_0.875000_g145519_i0 | PRJNA799842 | 147092 | 249 | 0.875 | 2.17875 | Halalkalicoccus | 332246 | Archaea | Archaea | 114 | 1.11e-27 | NR | MEM4780257.1 | 1973143 | g145519 | i0 | 76.9 | 2.92771084337349 | 65 | 15 | 78.3 | 0 | 1 | 195 | 147 | 211 | MEM4780257.1 polysaccharide deacetylase family protein [Halalkalicoccus sp.] | diamond | 729 | 115 | 0.991304347826087 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus sp. | |
| 30370439 | 30370439 | PRJNA799842_P_NODE_179512_length_243_cov_0.905882_g177939_i0 | PRJNA799842 | 179512 | 243 | 0.905882 | 2.20129326 | Methanothrix sp. | 90426 | Archaea | Archaea | 94.7 | 1.49e-22 | NR | MCX6670009.1 | 90426 | g177939 | i0 | 59.7 | 0.950617283950617 | 77 | 29 | 92.6 | 1 | 229 | 5 | 27 | 103 | MCX6670009.1 hypothetical protein [Methanothrix sp.] | diamond | 231 | 94.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30685785 | 30685785 | PRJNA799842_P_NODE_158293_length_247_cov_0.885057_g156720_i0 | PRJNA799842 | 158293 | 247 | 0.885057 | 2.18609079 | Methanomicrobiales archaeon HGW-Methanomicrobiales-3 | 2013819 | Archaea | Archaea | 47 | 0.00116 | NR | PKL63611.1 | 2013819 | g156720 | i0 | 33.9 | 0.753036437246964 | 62 | 41 | 75.3 | 0 | 43 | 228 | 3 | 64 | PKL63611.1 MAG: hypothetical protein CVV32_12990 [Methanomicrobiales archaeon HGW-Methanomicrobiales-3] | diamond | 186 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon HGW-Methanomicrobiales-3 | |||
| 31065310 | 31065310 | PRJNA799842_P_NODE_147015_length_249_cov_0.875000_g145442_i0 | PRJNA799842 | 147015 | 249 | 0.875 | 2.17875 | Methanothrix sp. | 90426 | Archaea | Archaea | 67 | 1.11e-10 | NR | MCX6677411.1 | 90426 | g145442 | i0 | 66.7 | 7.55421686746988 | 42 | 14 | 50.6 | 0 | 2 | 127 | 629 | 670 | MCX6677411.1 ATP-binding protein [Methanothrix sp.] | diamond | 1881 | 67 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 31191112 | 31191112 | PRJNA799842_P_NODE_168155_length_245_cov_0.895349_g166582_i0 | PRJNA799842 | 168155 | 245 | 0.895349 | 2.19360505 | Methanoregula sp. | 2052170 | Archaea | Archaea | 130 | 1.08e-35 | NR | MDD1699783.1 | 2052170 | g166582 | i0 | 81.5 | 0.991836734693878 | 81 | 15 | 99.2 | 0 | 1 | 243 | 61 | 141 | MDD1699783.1 DUF1003 domain-containing protein [Methanoregula sp.] | diamond | 243 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 32117901 | 32117901 | PRJNA799842_P_NODE_171158_length_244_cov_0.900585_g169585_i0 | PRJNA799842 | 171158 | 244 | 0.900585 | 2.1974274 | Methanosarcinales | 94695 | Archaea | Archaea | 99.8 | 1.26e-22 | NR | WP_176964316.1 | 536044 | g169585 | i0 | 62.8 | 7.64754098360656 | 78 | 28 | 94.7 | 1 | 3 | 233 | 129 | 206 | WP_176964316.1 PQQ-dependent sugar dehydrogenase [Methanolobus zinderi] | diamond | 1866 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus zinderi | |
| 32140518 | 32140518 | PRJNA799842_P_NODE_172378_length_244_cov_0.900585_g170805_i0 | PRJNA799842 | 172378 | 244 | 0.900585 | 2.1974274 | Methanosaeta sp. PtaB.Bin | 90426 | Archaea | Archaea | 43.5 | 0.0202 | NR | OPX76912.1 | 1811684 | g170805 | i0 | 31.7 | 0.774590163934426 | 63 | 40 | 73.8 | 1 | 196 | 17 | 177 | 239 | OPX76912.1 MAG: hypothetical protein A4E44_00236 [Methanosaeta sp. PtaB.Bin018] | diamond | 189 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaB.Bin018 | |
| 32552040 | 32552040 | PRJNA799842_P_NODE_156839_length_247_cov_0.885057_g155266_i0 | PRJNA799842 | 156839 | 247 | 0.885057 | 2.18609079 | Methanothrix sp. | 90426 | Archaea | Archaea | 75.1 | 4.09e-14 | NR | HUM80544.1 | 90426 | g155266 | i0 | 77.1 | 0.582995951417004 | 48 | 11 | 58.3 | 0 | 246 | 103 | 90 | 137 | HUM80544.1 ParB/RepB/Spo0J family partition protein [Methanothrix sp.] | diamond | 144 | 75.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix 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);;