contig_metadata
26 rows where bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3212824 | 3212824 | PRJNA682078_P_NODE_279663_length_242_cov_2.621302_g277886_i0 | PRJNA682078 | 279663 | 242 | 2.621302 | 6.34355084 | Haloquadratum walsbyi | 293091 | Archaea | Archaea | 261 | 3.33e-65 | NTclustered | gi|334353260|emb|FR746099.1| | 768065 | g277886 | i0 | 88.732 | 15.0371900826446 | 213 | 24 | 88 | 0 | 29 | 241 | 284065 | 283853 | Haloquadratum walsbyi C23 complete genome | blastn | 3639 | 261 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloquadratum | Haloquadratum walsbyi | |
| 3724985 | 3724985 | PRJNA682078_P_NODE_254023_length_246_cov_1.508671_g252246_i0 | PRJNA682078 | 254023 | 246 | 1.508671 | 3.71133066 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|216917|dbj|D12983.1|PYWPOL | 2261 | g252246 | i0 | 100 | 7.95934959349593 | 246 | 0 | 100 | 0 | 1 | 246 | 447 | 692 | Pyrococcus furiosus pol gene for DNA polymerase, complete cds | blastn | 1958 | 455 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 6278194 | 6278194 | PRJNA682078_P_NODE_73105_length_404_cov_2.211480_g71330_i0 | PRJNA682078 | 73105 | 404 | 2.21148 | 8.9343792 | root | 1 | Root_unresolved | Root_unresolved | 747 | 0 | NTclustered | gi|216917|dbj|D12983.1|PYWPOL | 2261 | g71330 | i0 | 100 | 6 | 404 | 0 | 100 | 0 | 1 | 404 | 1606 | 1203 | Pyrococcus furiosus pol gene for DNA polymerase, complete cds | blastn | 2424 | 747 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 7552423 | 7552423 | PRJNA682078_P_NODE_97526_length_355_cov_2.081560_g95750_i0 | PRJNA682078 | 97526 | 355 | 2.08156 | 7.389538 | root | 1 | Root_unresolved | Root_unresolved | 645 | 1.2099999999999996e-180 | NTclustered | gi|436492|gb|U00707.1|PSU00707 | 33866 | g95750 | i0 | 99.437 | 11.6901408450704 | 355 | 2 | 100 | 0 | 1 | 355 | 1120 | 766 | Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds | blastn | 4150 | 645 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus sp. | ||
| 14689090 | 14689090 | PRJNA682078_P_NODE_202572_length_261_cov_2.026596_g200795_i0 | PRJNA682078 | 202572 | 261 | 2.026596 | 5.28941556 | root | 1 | Root_unresolved | Root_unresolved | 55.5 | 1.22e-7 | NR | MCX9024633.1 | 2032688 | g200795 | i0 | 73.3 | 2.06896551724138 | 30 | 8 | 34.5 | 0 | 259 | 170 | 66 | 95 | MCX9024633.1 HNH endonuclease signature motif containing protein [Candidatus Methanoperedens sp.] | diamond | 540 | 55.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 16475401 | 16475401 | PRJNA682078_P_NODE_199073_length_263_cov_2.257895_g197296_i0 | PRJNA682078 | 199073 | 263 | 2.257895 | 5.93826385 | root | 1 | Root_unresolved | Root_unresolved | 486 | 5.5499999999999986e-133 | NTclustered | gi|216917|dbj|D12983.1|PYWPOL | 2261 | g197296 | i0 | 100 | 6 | 263 | 0 | 100 | 0 | 1 | 263 | 958 | 696 | Pyrococcus furiosus pol gene for DNA polymerase, complete cds | blastn | 1578 | 486 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 18509696 | 18509696 | PRJNA682078_P_NODE_101355_length_349_cov_4.764493_g99579_i0 | PRJNA682078 | 101355 | 349 | 4.764493 | 16.62808057 | Methanobrevibacter ruminantium | 83816 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|288541968|gb|CP001719.1| | 634498 | g99579 | i0 | 100 | 0.0859598853868195 | 30 | 0 | 9 | 0 | 285 | 314 | 1575289 | 1575260 | Methanobrevibacter ruminantium M1, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter ruminantium | |
| 21060528 | 21060528 | PRJNA682078_P_NODE_118777_length_327_cov_1.011811_g117000_i0 | PRJNA682078 | 118777 | 327 | 1.011811 | 3.30862197 | Halorubrum ruber | 2982524 | Archaea | Archaea | 132 | 3.84e-26 | NTclustered | gi|2031421124|gb|CP073695.1| | 2982524 | g117000 | i0 | 85.714 | 1.02752293577982 | 126 | 16 | 38 | 2 | 1 | 125 | 1524454 | 1524330 | Halorubrum ruber strain MBLA0099 chromosome, complete genome | blastn | 336 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum ruber | |
| 21575350 | 21575350 | PRJNA682078_P_NODE_246537_length_247_cov_2.178161_g244760_i0 | PRJNA682078 | 246537 | 247 | 2.178161 | 5.38005767 | Methanocella | 570266 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|634725790|tpe|HG985935.1| | 304371 | g244760 | i0 | 94.286 | 0.566801619433198 | 35 | 1 | 14 | 1 | 5 | 38 | 44 | 10 | TPA: Methanocella paludicola SANAE tRNA-Lys-CTT-1-1 gene | blastn | 140 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 21575616 | 21575616 | PRJNA682078_P_NODE_27457_length_651_cov_2.081315_g25739_i0 | PRJNA682078 | 27457 | 651 | 2.081315 | 13.54936065 | root | 1 | Root_unresolved | Root_unresolved | 1203 | 0 | NTclustered | gi|216917|dbj|D12983.1|PYWPOL | 2261 | g25739 | i0 | 100 | 6.41628264208909 | 651 | 0 | 100 | 0 | 1 | 651 | 1673 | 2323 | Pyrococcus furiosus pol gene for DNA polymerase, complete cds | blastn | 4177 | 1203 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 23612900 | 23612900 | PRJNA682078_P_NODE_199959_length_263_cov_1.315789_g198182_i0 | PRJNA682078 | 199959 | 263 | 1.315789 | 3.46052507 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 315 | 2.77e-81 | NTclustered | gi|805398754|gb|CP009526.1| | 1434109 | g198182 | i0 | 88.258 | 1.00380228136882 | 264 | 30 | 100 | 1 | 1 | 263 | 4349168 | 4348905 | Methanosarcina barkeri str. Wiesmoor, complete genome | blastn | 264 | 315 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 26797230 | 26797230 | PRJNA682078_P_NODE_201761_length_262_cov_1.259259_g199984_i0 | PRJNA682078 | 201761 | 262 | 1.259259 | 3.29925858 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 64.3 | 1.17e-9 | NR | HOT07308.1 | 2595067 | g199984 | i0 | 87.9 | 0.744274809160305 | 33 | 4 | 37.8 | 0 | 164 | 262 | 1 | 33 | HOT07308.1 FkbM family methyltransferase [Methanotrichaceae archaeon] | diamond | 195 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 27492908 | 27492908 | PRJNA682078_P_NODE_207723_length_258_cov_2.281081_g205946_i0 | PRJNA682078 | 207723 | 258 | 2.281081 | 5.88518898 | Haloarchaeobius litoreus | 755306 | Archaea | Archaea | 48.5 | 3.43e-4 | NR | WP_256398896.1 | 755306 | g205946 | i0 | 50 | 0.534883720930233 | 46 | 21 | 51.2 | 1 | 161 | 30 | 10 | 55 | WP_256398896.1 hypothetical protein [Haloarchaeobius litoreus] | diamond | 138 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius litoreus | |
| 27682687 | 27682687 | PRJNA682078_P_NODE_297544_length_228_cov_2.374194_g295767_i0 | PRJNA682078 | 297544 | 228 | 2.374194 | 5.41316232 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 60.8 | 1.28e-8 | NR | RZD43220.1 | 2026739 | g295767 | i0 | 40.3 | 2.07894736842105 | 77 | 39 | 92.1 | 1 | 227 | 18 | 2672 | 2748 | RZD43220.1 MAG: hypothetical protein CXT73_01170 [Methanobacteriota archaeon] | diamond | 474 | 60.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27714277 | 27714277 | PRJNA682078_P_NODE_121444_length_324_cov_0.808765_g119667_i0 | PRJNA682078 | 121444 | 324 | 0.808765 | 2.6203986 | Halobacteriales archaeon QS_5_7 | 1904752 | Archaea | Archaea | 43.5 | 0.0431 | NR | PSQ11283.1 | 1919180 | g119667 | i0 | 35.4 | 0.888888888888889 | 96 | 57 | 84.3 | 2 | 34 | 306 | 89 | 184 | PSQ11283.1 MAG: hypothetical protein BRC93_06035 [Halobacteriales archaeon QS_5_70_15] | diamond | 288 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QS_5_70_15 | |||
| 28092757 | 28092757 | PRJNA682078_P_NODE_293025_length_241_cov_0.863095_g291248_i0 | PRJNA682078 | 293025 | 241 | 0.863095 | 2.08005895 | Haloarcula | 2237 | Archaea | Archaea | 43.5 | 0.00443 | NR | WP_284009536.1 | 2237 | g291248 | i0 | 32.4 | 0.883817427385892 | 71 | 46 | 85.9 | 1 | 11 | 217 | 5 | 75 | WP_284009536.1 MULTISPECIES: hypothetical protein [Haloarcula] | diamond | 213 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | ||
| 28420397 | 28420397 | PRJNA682078_P_NODE_86926_length_374_cov_0.943522_g85151_i0 | PRJNA682078 | 86926 | 374 | 0.943522 | 3.52877228 | root | 1 | Root_unresolved | Root_unresolved | 142 | 1.35e-38 | NR | HET8689236.1 | 2213 | g85151 | i0 | 83.5 | 2.5427807486631 | 79 | 13 | 63.4 | 0 | 5 | 241 | 235 | 313 | HET8689236.1 hypothetical protein [Methanosarcina sp.] | diamond | 951 | 143 | 0.993006993006993 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28850309 | 28850309 | PRJNA682078_P_NODE_122468_length_322_cov_2.120482_g120691_i0 | PRJNA682078 | 122468 | 322 | 2.120482 | 6.8279520399999996 | Methanosarcina sp. | 2213 | Archaea | Archaea | 105 | 2.61e-26 | NR | HET8689243.1 | 2213 | g120691 | i0 | 64.9 | 0.68944099378882 | 74 | 26 | 68.9 | 0 | 3 | 224 | 91 | 164 | HET8689243.1 hypothetical protein [Methanosarcina sp.] | diamond | 222 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28945531 | 28945531 | PRJNA682078_P_NODE_210168_length_257_cov_1.576087_g208391_i0 | PRJNA682078 | 210168 | 257 | 1.576087 | 4.05054359 | Methanosarcina sp. | 2213 | Archaea | Archaea | 105 | 3.67e-27 | NR | HET8685164.1 | 2213 | g208391 | i0 | 57.6 | 0.992217898832685 | 85 | 36 | 99.2 | 0 | 255 | 1 | 9 | 93 | HET8685164.1 hypothetical protein [Methanosarcina sp.] | diamond | 255 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29134947 | 29134947 | PRJNA682078_P_NODE_194549_length_266_cov_1.502591_g192772_i0 | PRJNA682078 | 194549 | 266 | 1.502591 | 3.99689206 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 75.1 | 4.32e-14 | NR | MEA2034847.1 | 2026739 | g192772 | i0 | 54.8 | 0.699248120300752 | 62 | 28 | 69.9 | 0 | 5 | 190 | 73 | 134 | MEA2034847.1 VWA domain-containing protein [Methanobacteriota archaeon] | diamond | 186 | 75.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29797682 | 29797682 | PRJNA682078_P_NODE_281651_length_242_cov_0.911243_g279874_i0 | PRJNA682078 | 281651 | 242 | 0.911243 | 2.20520806 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 53.9 | 4.91e-7 | NR | HQJ88396.1 | 2485498 | g279874 | i0 | 61.4 | 1.42561983471074 | 57 | 18 | 65.7 | 1 | 82 | 240 | 1 | 57 | HQJ88396.1 hypothetical protein [Methanoregulaceae archaeon] | diamond | 345 | 53.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 29955757 | 29955757 | PRJNA682078_P_NODE_58551_length_449_cov_1.000000_g56778_i0 | PRJNA682078 | 58551 | 449 | 1 | 4.49 | Methanosarcina sp. | 2213 | Archaea | Archaea | 199 | 2.92e-58 | NR | HET8689240.1 | 2213 | g56778 | i0 | 74.4 | 1.73051224944321 | 129 | 33 | 86.2 | 0 | 446 | 60 | 315 | 443 | HET8689240.1 hypothetical protein [Methanosarcina sp.] | diamond | 777 | 199 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31030180 | 31030180 | PRJNA682078_P_NODE_195675_length_265_cov_2.130208_g193898_i0 | PRJNA682078 | 195675 | 265 | 2.130208 | 5.6450512 | Salinigranum rubrum | 755307 | Archaea | Archaea | 43.1 | 0.0238 | NR | WP_162562412.1 | 755307 | g193898 | i0 | 31.7 | 1.35849056603774 | 60 | 41 | 67.9 | 0 | 59 | 238 | 118 | 177 | WP_162562412.1 hypothetical protein [Salinigranum rubrum] | diamond | 360 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 31946860 | 31946860 | PRJNA682078_P_NODE_253077_length_246_cov_2.421965_g251300_i0 | PRJNA682078 | 253077 | 246 | 2.421965 | 5.9580339 | Methanosarcina sp. | 2213 | Archaea | Archaea | 80.5 | 2.01e-15 | NR | HET8689294.1 | 2213 | g251300 | i0 | 68.2 | 0.536585365853659 | 44 | 14 | 53.7 | 0 | 246 | 115 | 561 | 604 | HET8689294.1 hypothetical protein [Methanosarcina sp.] | diamond | 132 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32705633 | 32705633 | PRJNA682078_P_NODE_275660_length_243_cov_0.905882_g273883_i0 | PRJNA682078 | 275660 | 243 | 0.905882 | 2.20129326 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 42.4 | 0.0471 | NR | MEK6838767.1 | 2806419 | g273883 | i0 | 42.9 | 1.20987654320988 | 49 | 27 | 59.3 | 1 | 4 | 147 | 86 | 134 | MEK6838767.1 MFS transporter [Thermoplasmatota archaeon] | diamond | 294 | 42.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32737351 | 32737351 | PRJNA682078_P_NODE_111660_length_335_cov_3.167939_g109883_i0 | PRJNA682078 | 111660 | 335 | 3.167939 | 10.61259565 | Methanosarcina sp. | 2213 | Archaea | Archaea | 79 | 2.16e-14 | NR | HET8689298.1 | 2213 | g109883 | i0 | 38 | 1.78208955223881 | 108 | 63 | 95.8 | 2 | 328 | 8 | 114 | 218 | HET8689298.1 hypothetical protein [Methanosarcina sp.] | diamond | 597 | 79 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina 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);;