contig_metadata
25 rows where bioproject = "PRJNA1145997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2840389 | 2840389 | PRJNA1145997_P_NODE_42323_length_253_cov_0.866667_g39704_i0 | PRJNA1145997 | 42323 | 253 | 0.866667 | 2.19266751 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 446 | 9.01e-121 | NTclustered | gi|2176096791|gb|CP090373.1| | 2904243 | g39704 | i0 | 98.419 | 6 | 253 | 4 | 100 | 0 | 1 | 253 | 68386 | 68638 | Halobaculum sp. CBA1158 plasmid pCBA1158-2, complete sequence | blastn | 1518 | 446 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 2840470 | 2840470 | PRJNA1145997_P_NODE_47223_length_245_cov_0.906977_g44604_i0 | PRJNA1145997 | 47223 | 245 | 0.906977 | 2.22209365 | Natronomonas gomsonensis | 1046043 | Archaea | Archaea | 176 | 1.26e-39 | NTclustered | gi|2273673090|gb|CP101323.1| | 1046043 | g44604 | i0 | 80.328 | 0.995918367346939 | 244 | 38 | 98 | 7 | 2 | 240 | 1766427 | 1766189 | Natronomonas gomsonensis strain KCTC 4088 chromosome, complete genome | blastn | 244 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas gomsonensis | |
| 4861509 | 4861509 | PRJNA1145997_P_NODE_29844_length_388_cov_1.485714_g27226_i0 | PRJNA1145997 | 29844 | 388 | 1.485714 | 5.76457032 | Thermococcus | 2263 | Archaea | Archaea | 250 | 4.72e-74 | NR | WP_167728776.1 | 163002 | g27226 | i0 | 100 | 7.91752577319588 | 128 | 0 | 99 | 0 | 386 | 3 | 1679 | 1806 | WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] | diamond | 3072 | 250 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9N3 | ||
| 6136386 | 6136386 | PRJNA1145997_P_NODE_46085_length_247_cov_0.896552_g43466_i0 | PRJNA1145997 | 46085 | 247 | 0.896552 | 2.21448344 | Haloferacaceae archaeon | 2080321 | Archaea | Archaea | 124 | 3.14e-33 | NR | MDR9412284.1 | 2080321 | g43466 | i0 | 66.7 | 0.983805668016194 | 81 | 27 | 98.4 | 0 | 3 | 245 | 131 | 211 | MDR9412284.1 thymidylate synthase [Haloferacaceae archaeon] | diamond | 243 | 124 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon | ||
| 6666856 | 6666856 | PRJNA1145997_P_NODE_15206_length_927_cov_17.114754_g13064_i0 | PRJNA1145997 | 15206 | 927 | 17.114754 | 158.65376958 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 1635 | 0 | NTclustered | gi|683509033|emb|LN515531.1| | 2162 | g13064 | i0 | 99.888 | 5.56850053937433 | 889 | 0 | 96 | 1 | 22 | 910 | 1213491 | 1214378 | Methanobacterium formicicum genome assembly, chromosome: chrI | blastn | 5162 | 1635 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 10493269 | 10493269 | PRJNA1145997_P_NODE_43929_length_250_cov_0.881356_g41310_i0 | PRJNA1145997 | 43929 | 250 | 0.881356 | 2.20339 | Halobacterium wangiae | 2902623 | Archaea | Archaea | 412 | 9.02e-111 | NTclustered | gi|2168769890|gb|CP089588.1| | 2902623 | g41310 | i0 | 96.4 | 102.748 | 250 | 9 | 100 | 0 | 1 | 250 | 2184963 | 2185212 | Halobacterium wangiae strain Gai3-17 chromosome, complete genome | blastn | 25687 | 412 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium wangiae | |
| 13042922 | 13042922 | PRJNA1145997_P_NODE_22471_length_606_cov_4.065666_g19867_i0 | PRJNA1145997 | 22471 | 606 | 4.065666 | 24.63793596 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 54.7 | 0.017 | NTclustered | gi|1434708495|gb|CP031148.1| | 1547898 | g19867 | i0 | 84.483 | 0.191419141914191 | 58 | 5 | 9 | 3 | 265 | 319 | 1138687 | 1138743 | Haloplanus rubicundus strain CBA1112 chromosome, complete genome | blastn | 116 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 20691124 | 20691124 | PRJNA1145997_P_NODE_44177_length_250_cov_0.881356_g41558_i0 | PRJNA1145997 | 44177 | 250 | 0.881356 | 2.20339 | Haloarcula montana | 3111776 | Archaea | Archaea | 110 | 1.32e-19 | NTclustered | gi|2648521790|gb|CP142027.1| | 3111776 | g41558 | i0 | 89.655 | 0.564 | 87 | 8 | 34 | 1 | 132 | 217 | 796808 | 796722 | Haloarcula sp. GH36 chromosome, complete genome | blastn | 141 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula montana | |
| 21966412 | 21966412 | PRJNA1145997_P_NODE_41798_length_255_cov_1.714286_g39179_i0 | PRJNA1145997 | 41798 | 255 | 1.714286 | 4.3714293 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 311 | 3.46e-80 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g39179 | i0 | 88.627 | 4.29803921568627 | 255 | 29 | 100 | 0 | 1 | 255 | 2653239 | 2653493 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 1096 | 311 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 21966417 | 21966417 | PRJNA1145997_P_NODE_42098_length_253_cov_2.344444_g39479_i0 | PRJNA1145997 | 42098 | 253 | 2.344444 | 5.93144332 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 207 | 4.63e-49 | NTclustered | gi|1082264851|gb|CP016070.1| | 1873524 | g39479 | i0 | 81.569 | 12.0869565217391 | 255 | 43 | 100 | 4 | 1 | 253 | 1517460 | 1517712 | Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome | blastn | 3058 | 207 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 24515362 | 24515362 | PRJNA1145997_P_NODE_37140_length_288_cov_1.088372_g34521_i0 | PRJNA1145997 | 37140 | 288 | 1.088372 | 3.13451136 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 416 | 8.2e-112 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g34521 | i0 | 92.708 | 37.03125 | 288 | 21 | 100 | 0 | 1 | 288 | 2473471 | 2473758 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 10665 | 416 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 26785888 | 26785888 | PRJNA1145997_P_NODE_38281_length_279_cov_1.208738_g35662_i0 | PRJNA1145997 | 38281 | 279 | 1.208738 | 3.37237902 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 157 | 5.62e-47 | NR | MCH7662100.1 | 2026739 | g35662 | i0 | 82.8 | 1 | 93 | 16 | 100 | 0 | 1 | 279 | 73 | 165 | MCH7662100.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 279 | 157 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29049096 | 29049096 | PRJNA1145997_P_NODE_42468_length_253_cov_0.866667_g39849_i0 | PRJNA1145997 | 42468 | 253 | 0.866667 | 2.19266751 | Halorubrum | 56688 | Archaea | Archaea | 159 | 5.78e-44 | NR | WP_394348709.1 | 413815 | g39849 | i0 | 90.5 | 7.92094861660079 | 84 | 8 | 99.6 | 0 | 2 | 253 | 77 | 160 | WP_394348709.1 transposase [Halorubrum cibi] | diamond | 2004 | 160 | 0.99375 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum cibi | |
| 29722827 | 29722827 | PRJNA1145997_P_NODE_43490_length_251_cov_0.876404_g40871_i0 | PRJNA1145997 | 43490 | 251 | 0.876404 | 2.19977404 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 165 | 2.54e-48 | NR | WP_007691804.1 | 332168 | g40871 | i0 | 97.6 | 0.99203187250996006 | 83 | 2 | 99.2 | 0 | 249 | 1 | 131 | 213 | WP_007691804.1 glycerophosphodiester phosphodiesterase [Halococcus hamelinensis] | diamond | 249 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 30228474 | 30228474 | PRJNA1145997_P_NODE_48872_length_242_cov_1.497041_g46253_i0 | PRJNA1145997 | 48872 | 242 | 1.497041 | 3.62283922 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 135 | 4.27e-38 | NR | WP_054519980.1 | 1604004 | g46253 | i0 | 83.8 | 1.98347107438017 | 80 | 13 | 99.2 | 0 | 1 | 240 | 89 | 168 | WP_054519980.1 RNA 2',3'-cyclic phosphodiesterase [Halanaeroarchaeum sulfurireducens] | diamond | 480 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 30607557 | 30607557 | PRJNA1145997_P_NODE_34093_length_320_cov_1.174089_g31474_i0 | PRJNA1145997 | 34093 | 320 | 1.174089 | 3.7570848 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 130 | 7.89e-35 | NR | MDZ7850960.1 | 1980530 | g31474 | i0 | 66.7 | 1.96875 | 105 | 35 | 98.4 | 0 | 315 | 1 | 1 | 105 | MDZ7850960.1 hypothetical protein [Halodesulfurarchaeum sp.] | diamond | 630 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 30786160 | 30786160 | PRJNA1145997_P_NODE_48394_length_243_cov_0.917647_g45775_i0 | PRJNA1145997 | 48394 | 243 | 0.917647 | 2.22988221 | Halobacteriales | 2235 | Archaea | Archaea | 73.6 | 3.83e-14 | NR | AHG05206.1 | 751944 | g45775 | i0 | 63 | 1.33333333333333 | 54 | 20 | 66.7 | 0 | 77 | 238 | 1 | 54 | AHG05206.1 hypothetical protein HALDL1_06220 [Halobacterium sp. DL1] | diamond | 324 | 73.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. DL1 | |
| 30955461 | 30955461 | PRJNA1145997_P_NODE_43494_length_251_cov_0.876404_g40875_i0 | PRJNA1145997 | 43494 | 251 | 0.876404 | 2.19977404 | Halanaeroarchaeum sp. | 1963275 | Archaea | Archaea | 162 | 3.8e-46 | NR | MFB6134688.1 | 1963275 | g40875 | i0 | 85.5 | 1.9840637450199201 | 83 | 12 | 99.2 | 0 | 249 | 1 | 75 | 157 | MFB6134688.1 NAD(P)/FAD-dependent oxidoreductase [Halanaeroarchaeum sp.] | diamond | 498 | 162 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 31366342 | 31366342 | PRJNA1145997_P_NODE_48056_length_244_cov_0.912281_g45437_i0 | PRJNA1145997 | 48056 | 244 | 0.912281 | 2.22596564 | Haloarcula pellucida | 1427151 | Archaea | Archaea | 84.3 | 3.24e-18 | NR | WP_189002074.1 | 1427151 | g45437 | i0 | 64.5 | 0.762295081967213 | 62 | 22 | 76.2 | 0 | 196 | 11 | 4 | 65 | WP_189002074.1 3'-5' exonuclease [Haloarcula pellucida] | diamond | 186 | 84.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula pellucida | |
| 31576556 | 31576556 | PRJNA1145997_P_NODE_48876_length_242_cov_1.479290_g46257_i0 | PRJNA1145997 | 48876 | 242 | 1.47929 | 3.5798818 | Methanothrix | 2222 | Archaea | Archaea | 135 | 5.259999999999998e-35 | NR | WP_276838039.1 | 2222 | g46257 | i0 | 83.8 | 2.97520661157025 | 80 | 13 | 99.2 | 0 | 241 | 2 | 307 | 386 | WP_276838039.1 MULTISPECIES: GmrSD restriction endonuclease domain-containing protein [Methanothrix] | diamond | 720 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | ||
| 32335962 | 32335962 | PRJNA1145997_P_NODE_43459_length_251_cov_0.876404_g40840_i0 | PRJNA1145997 | 43459 | 251 | 0.876404 | 2.19977404 | Haloarculaceae | 1963268 | Archaea | Archaea | 43.9 | 0.00449 | NR | WP_276413083.1 | 2237 | g40840 | i0 | 64.3 | 1.23107569721116 | 28 | 10 | 33.5 | 0 | 250 | 167 | 40 | 67 | WP_276413083.1 MULTISPECIES: DUF5615 family PIN-like protein [Haloarcula] | diamond | 309 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | ||
| 32442051 | 32442051 | PRJNA1145997_P_NODE_47559_length_244_cov_1.701754_g44940_i0 | PRJNA1145997 | 47559 | 244 | 1.701754 | 4.15227976 | Halopenitus sp. | 1979403 | Archaea | Archaea | 153 | 5.63e-41 | NR | MFB6236223.1 | 1979403 | g44940 | i0 | 98.7 | 0.922131147540984 | 75 | 1 | 92.2 | 0 | 15 | 239 | 1 | 75 | MFB6236223.1 ATP-binding protein [Halopenitus sp.] | diamond | 225 | 153 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. | |
| 32683032 | 32683032 | PRJNA1145997_P_NODE_48060_length_244_cov_0.912281_g45441_i0 | PRJNA1145997 | 48060 | 244 | 0.912281 | 2.22596564 | Halodesulfurarchaeum | 1980514 | Archaea | Archaea | 134 | 9.14e-36 | NR | MFB6149070.1 | 1904752 | g45441 | i0 | 81.3 | 2.93852459016393 | 80 | 15 | 98.4 | 0 | 242 | 3 | 200 | 279 | MFB6149070.1 MFS transporter [Halobacteriales archaeon] | diamond | 717 | 135 | 0.992592592592593 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 32694145 | 32694145 | PRJNA1145997_P_NODE_43360_length_251_cov_0.876404_g40741_i0 | PRJNA1145997 | 43360 | 251 | 0.876404 | 2.19977404 | Halobacterium sp. NMX12-1 | 3166650 | Archaea | Archaea | 81.6 | 8.43e-16 | NR | WP_353635661.1 | 3166650 | g40741 | i0 | 58 | 1.93625498007968 | 81 | 33 | 96.8 | 1 | 251 | 9 | 789 | 868 | WP_353635661.1 hypothetical protein [Halobacterium sp. NMX12-1] | diamond | 486 | 81.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. NMX12-1 | |
| 32788570 | 32788570 | PRJNA1145997_P_NODE_48860_length_242_cov_1.668639_g46241_i0 | PRJNA1145997 | 48860 | 242 | 1.668639 | 4.03810638 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 151 | 8.119999999999997e-42 | NR | WP_259518758.1 | 2866382 | g46241 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 240 | 1 | 211 | 290 | WP_259518758.1 ABC transporter substrate-binding protein [Halanaeroarchaeum sp. HSR-CO] | diamond | 240 | 151 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO |
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);;