contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23553991 | 23553991 | PRJNA630162_P_NODE_110979_length_179_cov_1.730769_g109456_i0 | PRJNA630162 | 110979 | 179 | 1.730769 | 3.09807651 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 112 | 7.160000000000001e-29 | NR | MDP3036012.1 | 2099680 | g109456 | i0 | 98.3 | 1.97765363128492 | 59 | 1 | 98.9 | 0 | 2 | 178 | 122 | 180 | MDP3036012.1 methyl-coenzyme M reductase subunit beta [Methanobacteriaceae archaeon] | diamond | 354 | 112 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 24828509 | 24828509 | PRJNA630162_P_NODE_40120_length_281_cov_1.021552_g38597_i0 | PRJNA630162 | 40120 | 281 | 1.021552 | 2.87056112 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 103 | 6.63e-24 | NR | HSO25705.1 | 2099680 | g38597 | i0 | 53.2 | 1.00355871886121 | 94 | 43 | 99.3 | 1 | 281 | 3 | 79 | 172 | HSO25705.1 hypothetical protein [Methanobacteriaceae archaeon] | diamond | 282 | 103 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 26859691 | 26859691 | PRJNA630162_P_NODE_90961_length_191_cov_1.767606_g89438_i0 | PRJNA630162 | 90961 | 191 | 1.767606 | 3.37612746 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 44.7 | 0.004 | NR | MBR5503518.1 | 66852 | g89438 | i0 | 45.5 | 0.691099476439791 | 44 | 22 | 69.1 | 1 | 11 | 142 | 50 | 91 | MBR5503518.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 132 | 44.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 26985704 | 26985704 | PRJNA630162_P_NODE_161822_length_162_cov_0.920354_g160299_i0 | PRJNA630162 | 161822 | 162 | 0.920354 | 1.49097348 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 49.7 | 4.36e-5 | NR | WP_407454888.1 | 66852 | g160299 | i0 | 56.3 | 0.888888888888889 | 48 | 20 | 88.9 | 1 | 149 | 6 | 130 | 176 | WP_407454888.1 right-handed parallel beta-helix repeat-containing protein [Methanobrevibacter sp.] | diamond | 144 | 49.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27807439 | 27807439 | PRJNA630162_P_NODE_140324_length_167_cov_0.881356_g138801_i0 | PRJNA630162 | 140324 | 167 | 0.881356 | 1.47186452 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 58.2 | 4.8e-8 | NR | MBR5504340.1 | 66852 | g138801 | i0 | 54.9 | 0.916167664670659 | 51 | 19 | 91.6 | 1 | 1 | 153 | 437 | 483 | MBR5504340.1 AAA family ATPase [Methanobrevibacter sp.] | diamond | 153 | 58.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27883031 | 27883031 | PRJNA630162_P_NODE_152025_length_164_cov_0.904348_g150502_i0 | PRJNA630162 | 152025 | 164 | 0.904348 | 1.48313072 | Methanobrevibacter | 2172 | Archaea | Archaea | 104 | 2.7e-27 | NR | WP_405310204.1 | 66852 | g150502 | i0 | 98.1 | 7.60975609756098 | 52 | 1 | 95.1 | 0 | 156 | 1 | 12 | 63 | WP_405310204.1 winged helix-turn-helix transcriptional regulator [Methanobrevibacter sp.] | diamond | 1248 | 104 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29448811 | 29448811 | PRJNA630162_P_NODE_161790_length_162_cov_0.920354_g160267_i0 | PRJNA630162 | 161790 | 162 | 0.920354 | 1.49097348 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 68.9 | 6.58e-12 | NR | MBX7076500.1 | 2099680 | g160267 | i0 | 56.9 | 0.944444444444444 | 51 | 22 | 94.4 | 0 | 155 | 3 | 336 | 386 | MBX7076500.1 elongation factor Tu [Methanobacteriaceae archaeon] | diamond | 153 | 68.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 30333864 | 30333864 | PRJNA630162_P_NODE_132272_length_169_cov_0.866667_g130749_i0 | PRJNA630162 | 132272 | 169 | 0.866667 | 1.46466723 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 97.8 | 9.86e-23 | NR | WP_296891192.1 | 253161 | g130749 | i0 | 96.4 | 2.92899408284024 | 55 | 2 | 97.6 | 0 | 169 | 5 | 245 | 299 | WP_296891192.1 Ig-like domain-containing protein, partial [uncultured Methanobrevibacter sp.] | diamond | 495 | 97.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 30491519 | 30491519 | PRJNA630162_P_NODE_156473_length_163_cov_0.912281_g154950_i0 | PRJNA630162 | 156473 | 163 | 0.912281 | 1.48701803 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 100 | 4.7399999999999997e-23 | NR | WP_296852426.1 | 253161 | g154950 | i0 | 98.1 | 1.91411042944785 | 52 | 1 | 95.7 | 0 | 158 | 3 | 37 | 88 | WP_296852426.1 helicase HerA-like domain-containing protein [uncultured Methanobrevibacter sp.] | diamond | 312 | 100 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 30807348 | 30807348 | PRJNA630162_P_NODE_103934_length_183_cov_1.910448_g102411_i0 | PRJNA630162 | 103934 | 183 | 1.910448 | 3.49611984 | Methanobrevibacter sp. UBA188 | 1915473 | Archaea | Archaea | 129 | 5.18e-33 | NR | WP_292881706.1 | 1915473 | g102411 | i0 | 100 | 0.967213114754098 | 59 | 0 | 96.7 | 0 | 2 | 178 | 525 | 583 | WP_292881706.1 PP2C family protein-serine/threonine phosphatase [Methanobrevibacter sp. UBA188] | diamond | 177 | 129 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. UBA188 | |
| 31755965 | 31755965 | PRJNA630162_P_NODE_85337_length_196_cov_0.993197_g83814_i0 | PRJNA630162 | 85337 | 196 | 0.993197 | 1.94666612 | Methanocaldococcus lauensis | 2546128 | Archaea | Archaea | 63.5 | 4.47e-10 | NR | CAB3287519.1 | 2546128 | g83814 | i0 | 55 | 0.918367346938776 | 60 | 23 | 85.7 | 1 | 175 | 8 | 112 | 171 | CAB3287519.1 protein of unknown function [Methanocaldococcus lauensis] | diamond | 180 | 63.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus lauensis | |
| 32294202 | 32294202 | PRJNA630162_P_NODE_82139_length_199_cov_1.646667_g80616_i0 | PRJNA630162 | 82139 | 199 | 1.646667 | 3.27686733 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 70.9 | 9.49e-14 | NR | MBO7211560.1 | 66852 | g80616 | i0 | 50.8 | 0.979899497487437 | 65 | 30 | 96.5 | 2 | 6 | 197 | 22 | 85 | MBO7211560.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 195 | 70.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32452136 | 32452136 | PRJNA630162_P_NODE_132539_length_169_cov_0.866667_g131016_i0 | PRJNA630162 | 132539 | 169 | 0.866667 | 1.46466723 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 94 | 1.26e-20 | NR | WP_405309801.1 | 66852 | g131016 | i0 | 80.4 | 2.98224852071006 | 56 | 9 | 99.4 | 1 | 1 | 168 | 1428 | 1481 | WP_405309801.1 beta strand repeat-containing protein, partial [Methanobrevibacter sp.] | diamond | 504 | 94 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32452159 | 32452159 | PRJNA630162_P_NODE_149019_length_165_cov_0.896552_g147496_i0 | PRJNA630162 | 149019 | 165 | 0.896552 | 1.4793108 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 107 | 3.7e-28 | NR | WP_292783638.1 | 66852 | g147496 | i0 | 94.3 | 4.81818181818182 | 53 | 3 | 96.4 | 0 | 163 | 5 | 67 | 119 | WP_292783638.1 nuclease [Methanobrevibacter sp.] | diamond | 795 | 107 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32483605 | 32483605 | PRJNA630162_P_NODE_113479_length_178_cov_1.255814_g111956_i0 | PRJNA630162 | 113479 | 178 | 1.255814 | 2.23534892 | Methanobrevibacter millerae | 230361 | Archaea | Archaea | 115 | 2.76e-28 | NR | WP_149731223.1 | 230361 | g111956 | i0 | 96.5 | 0.960674157303371 | 57 | 2 | 96.1 | 0 | 173 | 3 | 299 | 355 | WP_149731223.1 type I restriction-modification system subunit M [Methanobrevibacter millerae] | diamond | 171 | 115 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 32672676 | 32672676 | PRJNA630162_P_NODE_114500_length_177_cov_2.015625_g112977_i0 | PRJNA630162 | 114500 | 177 | 2.015625 | 3.56765625 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 109 | 5.08e-28 | NR | WP_405273466.1 | 66852 | g112977 | i0 | 96.3 | 1.83050847457627 | 54 | 2 | 91.5 | 0 | 164 | 3 | 108 | 161 | WP_405273466.1 4Fe-4S double cluster binding domain-containing protein [Methanobrevibacter sp.] | diamond | 324 | 109 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32704200 | 32704200 | PRJNA630162_P_NODE_152840_length_164_cov_0.904348_g151317_i0 | PRJNA630162 | 152840 | 164 | 0.904348 | 1.48313072 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 94.4 | 1.08e-21 | NR | WP_298501138.1 | 253161 | g151317 | i0 | 98.1 | 0.969512195121951 | 53 | 1 | 97 | 0 | 5 | 163 | 1 | 53 | WP_298501138.1 hypothetical protein [uncultured Methanobrevibacter sp.] | diamond | 159 | 94.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 32893079 | 32893079 | PRJNA630162_P_NODE_111200_length_179_cov_1.530769_g109677_i0 | PRJNA630162 | 111200 | 179 | 1.530769 | 2.74007651 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 90.5 | 2.24e-19 | NR | MBO7695876.1 | 66852 | g109677 | i0 | 66.1 | 1.9608938547486 | 59 | 20 | 98.9 | 0 | 1 | 177 | 386 | 444 | MBO7695876.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 351 | 90.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter 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);;