contig_metadata
11 rows where bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18397263 | 18397263 | PRJNA561212_P_NODE_19255_length_259_cov_1.209677_g19044_i0 | PRJNA561212 | 19255 | 259 | 1.209677 | 3.13306343 | Natrialba magadii | 13769 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|289529249|gb|CP001932.1| | 547559 | g19044 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 24 | 51 | 3672109 | 3672082 | Natrialba magadii ATCC 43099, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba magadii | |
| 20947434 | 20947434 | PRJNA561212_P_NODE_13977_length_299_cov_1.274336_g13766_i0 | PRJNA561212 | 13977 | 299 | 1.274336 | 3.81026464 | Methanolobus sp. ZRKC2 | 3125783 | Archaea | Archaea | 78.7 | 4.59e-10 | NTclustered | gi|2708450131|gb|CP146980.1| | 3125783 | g13766 | i0 | 90.164 | 0.204013377926421 | 61 | 4 | 20 | 2 | 240 | 299 | 639879 | 639820 | Methanolobus sp. ZRKC2 chromosome, complete genome | blastn | 61 | 78.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. ZRKC2 | |
| 26681416 | 26681416 | PRJNA561212_P_NODE_5301_length_480_cov_1.454545_g5090_i0 | PRJNA561212 | 5301 | 480 | 1.454545 | 6.981816 | Methanobacteriati | 3366610 | Archaea | Archaea | 196 | 1.8500000000000002e-59 | NR | MBH33411.1 | 2026739 | g5090 | i0 | 65.6 | 13.49375 | 151 | 47 | 94.4 | 1 | 466 | 14 | 45 | 190 | MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 6477 | 196 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28387811 | 28387811 | PRJNA561212_P_NODE_16746_length_277_cov_1.308824_g16535_i0 | PRJNA561212 | 16746 | 277 | 1.308824 | 3.62544248 | Methanobacteriati | 3366610 | Archaea | Archaea | 54.7 | 3.63e-6 | NR | MAV02704.1 | 2026739 | g16535 | i0 | 46.3 | 8.29602888086643 | 54 | 29 | 58.5 | 0 | 19 | 180 | 38 | 91 | MAV02704.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 2298 | 54.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28689924 | 28689924 | PRJNA561212_P_NODE_13487_length_304_cov_1.896104_g13276_i0 | PRJNA561212 | 13487 | 304 | 1.896104 | 5.76415616 | Candidatus Methanoxibalbensis ujae | 2977099 | Archaea | Archaea | 59.7 | 8.96e-8 | NR | MCW3136373.1 | 2977099 | g13276 | i0 | 36.7 | 0.888157894736842 | 90 | 52 | 88.8 | 2 | 279 | 10 | 962 | 1046 | MCW3136373.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Methanoxibalbensis ujae] | diamond | 270 | 59.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanospirareceae | Candidatus Methanoxibalbensis | Candidatus Methanoxibalbensis ujae | |
| 29321110 | 29321110 | PRJNA561212_P_NODE_18649_length_263_cov_1.515789_g18438_i0 | PRJNA561212 | 18649 | 263 | 1.515789 | 3.98652507 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 57 | 4.69e-7 | NR | MBU38768.1 | 2026739 | g18438 | i0 | 51.9 | 0.593155893536122 | 52 | 24 | 59.3 | 1 | 10 | 165 | 856 | 906 | MBU38768.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 156 | 57 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29321129 | 29321129 | PRJNA561212_P_NODE_9689_length_354_cov_1.270463_g9478_i0 | PRJNA561212 | 9689 | 354 | 1.270463 | 4.49743902 | Methanobacterium sp. | 2164 | Archaea | Archaea | 67.8 | 2.05e-10 | NR | MCE5214616.1 | 2164 | g9478 | i0 | 35.6 | 6.05084745762712 | 101 | 59 | 85.6 | 2 | 40 | 342 | 70 | 164 | MCE5214616.1 translation elongation factor EF-1 subunit alpha [Methanobacterium sp.] | diamond | 2142 | 67.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29731387 | 29731387 | PRJNA561212_P_NODE_4730_length_510_cov_1.093822_g4521_i0 | PRJNA561212 | 4730 | 510 | 1.093822 | 5.5784922 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 177 | 5.279999999999999e-52 | NR | MBU04005.1 | 2026739 | g4521 | i0 | 54.3 | 14.4647058823529 | 164 | 72 | 96.5 | 1 | 14 | 505 | 36 | 196 | MBU04005.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 7377 | 177 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29808585 | 29808585 | PRJNA561212_P_NODE_4871_length_501_cov_2.023364_g4661_i0 | PRJNA561212 | 4871 | 501 | 2.023364 | 10.13705364 | root | 1 | Root_unresolved | Root_unresolved | 106 | 1.67e-24 | NR | MEA3199455.1 | 1906666 | g4661 | i0 | 46.7 | 4.31736526946108 | 120 | 63 | 71.9 | 1 | 363 | 4 | 3 | 121 | MEA3199455.1 3-hydroxybutyryl-CoA dehydrogenase [Thermoplasmata archaeon] | diamond | 2163 | 106 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30963918 | 30963918 | PRJNA561212_P_NODE_5034_length_493_cov_1.795238_g4823_i0 | PRJNA561212 | 5034 | 493 | 1.795238 | 8.85052334 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 194 | 1.48e-60 | NR | HJM77902.1 | 2670411 | g4823 | i0 | 78.8 | 2.15415821501014 | 118 | 25 | 71.8 | 0 | 354 | 1 | 5 | 122 | HJM77902.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Candidatus Thalassarchaeaceae archaeon] | diamond | 1062 | 194 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 31831230 | 31831230 | PRJNA561212_P_NODE_19557_length_257_cov_1.179348_g19346_i0 | PRJNA561212 | 19557 | 257 | 1.179348 | 3.03092436 | Archaea | 2157 | Archaea | Archaea | 60.5 | 2.63e-8 | NR | MDP6889438.1 | 2670411 | g19346 | i0 | 44.1 | 1.37743190661479 | 59 | 28 | 68.9 | 1 | 80 | 256 | 53 | 106 | MDP6889438.1 putative Ig domain-containing protein [Candidatus Thalassarchaeaceae archaeon] | diamond | 354 | 60.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon |
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);;