contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18387254 | 18387254 | PRJNA556992_P_NODE_973715_length_233_cov_3.331250_g971525_i0 | PRJNA556992 | 973715 | 233 | 3.33125 | 7.7618125 | Methanobrevibacter woesei | 190976 | Archaea | Archaea | 152 | 6.73e-41 | NR | WP_346674977.1 | 190976 | g971525 | i0 | 100 | 0.991416309012876 | 77 | 0 | 99.1 | 0 | 3 | 233 | 23 | 99 | WP_346674977.1 glycosyltransferase family 2 protein [Methanobrevibacter woesei] | diamond | 231 | 152 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter woesei | |
| 22208457 | 22208457 | PRJNA556992_P_NODE_651538_length_255_cov_1.115385_g649349_i0 | PRJNA556992 | 651538 | 255 | 1.115385 | 2.84423175 | Methanobrevibacter | 2172 | Archaea | Archaea | 103 | 8.769999999999999e-25 | NR | WP_083234819.1 | 2172 | g649349 | i0 | 92.9 | 1.31764705882353 | 56 | 4 | 65.9 | 0 | 255 | 88 | 232 | 287 | WP_083234819.1 MULTISPECIES: succinate--CoA ligase subunit alpha [Methanobrevibacter] | diamond | 336 | 103 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | ||
| 26603451 | 26603451 | PRJNA556992_P_NODE_425061_length_274_cov_1.870647_g422872_i0 | PRJNA556992 | 425061 | 274 | 1.870647 | 5.12557278 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 67.8 | 8.23e-11 | NR | MBO7716606.1 | 66852 | g422872 | i0 | 41.3 | 0.875912408759124 | 80 | 47 | 87.6 | 0 | 242 | 3 | 442 | 521 | MBO7716606.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 240 | 67.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28468545 | 28468545 | PRJNA556992_P_NODE_883406_length_241_cov_4.875000_g881216_i0 | PRJNA556992 | 883406 | 241 | 4.875 | 11.74875 | Methanobacterium sp. | 2164 | Archaea | Archaea | 144 | 7.63e-40 | NR | HEY0196223.1 | 2164 | g881216 | i0 | 94.9 | 1.96680497925311 | 79 | 4 | 98.3 | 0 | 239 | 3 | 197 | 275 | HEY0196223.1 glycosyltransferase family 2 protein [Methanobacterium sp.] | diamond | 474 | 144 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 28545918 | 28545918 | PRJNA556992_P_NODE_979107_length_232_cov_6.729560_g976917_i0 | PRJNA556992 | 979107 | 232 | 6.72956 | 15.6125792 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 7.9e-4 | NR | WP_281774102.1 | 2162 | g976917 | i0 | 44.4 | 6.23275862068965 | 63 | 28 | 81.5 | 2 | 231 | 43 | 2252 | 2307 | WP_281774102.1 DUF3344 domain-containing protein, partial [Methanobacterium formicicum] | diamond | 1446 | 47.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 28657914 | 28657914 | PRJNA556992_P_NODE_881327_length_242_cov_0.905325_g879137_i0 | PRJNA556992 | 881327 | 242 | 0.905325 | 2.1908865 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 146 | 4.9799999999999997e-39 | NR | WP_405323806.1 | 66852 | g879137 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 242 | 3 | 30 | 109 | WP_405323806.1 right-handed parallel beta-helix repeat-containing protein [Methanobrevibacter sp.] | diamond | 240 | 146 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29005044 | 29005044 | PRJNA556992_P_NODE_1031448_length_227_cov_3.480519_g1029258_i0 | PRJNA556992 | 1031448 | 227 | 3.480519 | 7.90077813 | Methanofervidicoccus sp. A16 | 2607662 | Archaea | Archaea | 114 | 1.66e-28 | NR | WP_148120023.1 | 2607662 | g1029258 | i0 | 73 | 3.91189427312775 | 74 | 20 | 97.8 | 0 | 223 | 2 | 230 | 303 | WP_148120023.1 GDP-mannose 4,6-dehydratase [Methanofervidicoccus sp. A16] | diamond | 888 | 114 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanofervidicoccus | Methanofervidicoccus sp. A16 | ||
| 29005102 | 29005102 | PRJNA556992_P_NODE_1120748_length_208_cov_4.511111_g1118557_i0 | PRJNA556992 | 1120748 | 208 | 4.511111 | 9.38311088 | Methanobacterium sp. PtaU1.Bin | 2164 | Archaea | Archaea | 98.6 | 1.32e-24 | NR | OPY24548.1 | 1811675 | g1118557 | i0 | 95.7 | 0.663461538461538 | 46 | 2 | 66.3 | 0 | 69 | 206 | 1 | 46 | OPY24548.1 MAG: Superoxide reductase [Methanobacterium sp. PtaU1.Bin097] | diamond | 138 | 98.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. PtaU1.Bin097 | |
| 29257297 | 29257297 | PRJNA556992_P_NODE_528149_length_265_cov_1.317708_g525960_i0 | PRJNA556992 | 528149 | 265 | 1.317708 | 3.4919262 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 181 | 3.2999999999999994e-56 | NR | WP_407463451.1 | 66852 | g525960 | i0 | 98.9 | 2.98867924528302 | 88 | 1 | 99.6 | 0 | 265 | 2 | 53 | 140 | WP_407463451.1 FAD-binding protein, partial [Methanobrevibacter sp.] | diamond | 792 | 181 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29335011 | 29335011 | PRJNA556992_P_NODE_655069_length_254_cov_3.425414_g652880_i0 | PRJNA556992 | 655069 | 254 | 3.425414 | 8.70055156 | Methanobacteriaceae | 2159 | Archaea | Archaea | 156 | 6.329999999999999e-46 | NR | MBR6023592.1 | 66852 | g652880 | i0 | 88.1 | 7.93700787401575 | 84 | 10 | 99.2 | 0 | 254 | 3 | 91 | 174 | MBR6023592.1 AMP-binding protein [Methanobrevibacter sp.] | diamond | 2016 | 156 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29415431 | 29415431 | PRJNA556992_P_NODE_863149_length_242_cov_5.857988_g860959_i0 | PRJNA556992 | 863149 | 242 | 5.857988 | 14.17633096 | Methanobacterium sp. | 2164 | Archaea | Archaea | 56.6 | 4.65e-7 | NR | MEN6294173.1 | 2164 | g860959 | i0 | 37.3 | 0.830578512396694 | 67 | 42 | 83.1 | 0 | 240 | 40 | 174 | 240 | MEN6294173.1 hypothetical protein [Methanobacterium sp.] | diamond | 201 | 56.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29857150 | 29857150 | PRJNA556992_P_NODE_1110571_length_210_cov_5.532847_g1108380_i0 | PRJNA556992 | 1110571 | 210 | 5.532847 | 11.6189787 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 90.9 | 2.7e-19 | NR | MBR1610416.1 | 66852 | g1108380 | i0 | 58.8 | 0.971428571428571 | 68 | 28 | 97.1 | 0 | 210 | 7 | 469 | 536 | MBR1610416.1 polysaccharide deacetylase family protein [Methanobrevibacter sp.] | diamond | 204 | 90.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30773653 | 30773653 | PRJNA556992_P_NODE_235314_length_310_cov_3.080169_g233126_i0 | PRJNA556992 | 235314 | 310 | 3.080169 | 9.5485239 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 99.4 | 1.11e-21 | NR | WP_295614222.1 | 253161 | g233126 | i0 | 100 | 2.37096774193548 | 49 | 0 | 47.4 | 0 | 308 | 162 | 2044 | 2092 | WP_295614222.1 AMP-binding protein, partial [uncultured Methanobrevibacter sp.] | diamond | 735 | 99.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 31135202 | 31135202 | PRJNA556992_P_NODE_547875_length_263_cov_2.073684_g545686_i0 | PRJNA556992 | 547875 | 263 | 2.073684 | 5.45378892 | Methanobrevibacter | 2172 | Archaea | Archaea | 115 | 7.700000000000001e-28 | NR | WP_292787076.1 | 66852 | g545686 | i0 | 94.8 | 1.32319391634981 | 58 | 3 | 66.2 | 0 | 176 | 3 | 1 | 58 | WP_292787076.1 ABC transporter ATP-binding protein [Methanobrevibacter sp.] | diamond | 348 | 116 | 0.991379310344828 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31753560 | 31753560 | PRJNA556992_P_NODE_329277_length_285_cov_1.122642_g327088_i0 | PRJNA556992 | 329277 | 285 | 1.122642 | 3.1995297 | Methanobacteriales archaeon HGW-Methanobacteriales-1 | 2013815 | Archaea | Archaea | 48.9 | 4.27e-4 | NR | PKL67475.1 | 2013815 | g327088 | i0 | 41.2 | 3.38947368421053 | 85 | 47 | 86.3 | 2 | 249 | 4 | 1 | 85 | PKL67475.1 MAG: hypothetical protein CVV28_06355 [Methanobacteriales archaeon HGW-Methanobacteriales-1] | diamond | 966 | 48.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriales archaeon HGW-Methanobacteriales-1 | |||
| 32355175 | 32355175 | PRJNA556992_P_NODE_661059_length_254_cov_1.701657_g658870_i0 | PRJNA556992 | 661059 | 254 | 1.701657 | 4.32220878 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 162 | 4.52e-49 | NR | WP_292788576.1 | 66852 | g658870 | i0 | 98.8 | 0.992125984251969 | 84 | 1 | 99.2 | 0 | 3 | 254 | 76 | 159 | WP_292788576.1 SseB family protein [Methanobrevibacter sp.] | diamond | 252 | 162 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32828423 | 32828423 | PRJNA556992_P_NODE_851600_length_243_cov_2.229412_g849410_i0 | PRJNA556992 | 851600 | 243 | 2.229412 | 5.41747116 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 55.5 | 1.21e-6 | NR | MBO7714342.1 | 66852 | g849410 | i0 | 40.8 | 0.938271604938272 | 76 | 45 | 93.8 | 0 | 232 | 5 | 122 | 197 | MBO7714342.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 228 | 55.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32828487 | 32828487 | PRJNA556992_P_NODE_952940_length_235_cov_3.808642_g950750_i0 | PRJNA556992 | 952940 | 235 | 3.808642 | 8.9503087 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 50.1 | 7.13e-5 | NR | MBQ6629504.1 | 66852 | g950750 | i0 | 43.4 | 0.676595744680851 | 53 | 30 | 67.7 | 0 | 7 | 165 | 191 | 243 | MBQ6629504.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 159 | 50.1 | 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);;