contig_metadata
13 rows where bioproject = "PRJNA565584", tax_clade = "Methanomada group" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12614534 | 12614534 | PRJNA565584_P_NODE_85750_length_321_cov_1.241935_g84598_i0 | PRJNA565584 | 85750 | 321 | 1.241935 | 3.98661135 | Archaea | 2157 | Archaea | Archaea | 69.4 | 2.99e-7 | NTclustered | gi|2874253858|emb|OY969914.1| | 176233 | g84598 | i0 | 84.722 | 47.1028037383178 | 72 | 7 | 22 | 4 | 219 | 288 | 2030610 | 2030679 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD02416.bin.1.248 genome assembly, chromosome: 1 | blastn | 15120 | 69.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 20957652 | 20957652 | PRJNA565584_P_NODE_163897_length_253_cov_1.505556_g162745_i0 | PRJNA565584 | 163897 | 253 | 1.505556 | 3.80905668 | Methanocaldococcus infernus | 67760 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|295433502|gb|CP002009.1| | 573063 | g162745 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 75 | 102 | 977082 | 977109 | Methanocaldococcus infernus ME, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus infernus | |
| 27427305 | 27427305 | PRJNA565584_P_NODE_45743_length_441_cov_2.103261_g44592_i0 | PRJNA565584 | 45743 | 441 | 2.103261 | 9.27538101 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 47.8 | 0.00413 | NR | MEE3325674.1 | 2666342 | g44592 | i0 | 53.8 | 0.26530612244898 | 39 | 15 | 26.5 | 1 | 323 | 439 | 67 | 102 | MEE3325674.1 phospholipid scramblase-related protein [Methanosphaera sp.] | diamond | 117 | 47.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 27566908 | 27566908 | PRJNA565584_P_NODE_34264_length_518_cov_1.507865_g33113_i0 | PRJNA565584 | 34264 | 518 | 1.507865 | 7.8107407 | root | 1 | Root_unresolved | Root_unresolved | 315 | 1.1599999999999999e-104 | NR | MBR0369318.1 | 66852 | g33113 | i0 | 88.4 | 1.99227799227799 | 172 | 20 | 99.6 | 0 | 517 | 2 | 132 | 303 | MBR0369318.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 1032 | 315 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27977433 | 27977433 | PRJNA565584_P_NODE_217605_length_237_cov_3.518293_g216453_i0 | PRJNA565584 | 217605 | 237 | 3.518293 | 8.33835441 | root | 1 | Root_unresolved | Root_unresolved | 102 | 5.78e-24 | NR | MBO6123194.1 | 66852 | g216453 | i0 | 57.1 | 25.5189873417722 | 77 | 33 | 97.5 | 0 | 5 | 235 | 11 | 87 | MBO6123194.1 glycosyltransferase family 2 protein [Methanobrevibacter sp.] | diamond | 6048 | 102 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29542474 | 29542474 | PRJNA565584_P_NODE_89730_length_313_cov_3.208333_g88578_i0 | PRJNA565584 | 89730 | 313 | 3.208333 | 10.04208229 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 43.5 | 0.0461 | NR | WP_330047862.1 | 66852 | g88578 | i0 | 27.6 | 1.00638977635783 | 105 | 72 | 96.8 | 2 | 10 | 312 | 217 | 321 | WP_330047862.1 bifunctional glycosyltransferase/CDP-glycerol:glycerophosphate glycerophosphotransferase [Methanobrevibacter sp.] | diamond | 315 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29763407 | 29763407 | PRJNA565584_P_NODE_70891_length_353_cov_1.189286_g69740_i0 | PRJNA565584 | 70891 | 353 | 1.189286 | 4.19817958 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 103 | 9.91e-24 | NR | MEE3444316.1 | 66852 | g69740 | i0 | 42.5 | 2.03966005665722 | 120 | 66 | 99.4 | 2 | 352 | 2 | 170 | 289 | MEE3444316.1 C1 family peptidase [Methanobrevibacter sp.] | diamond | 720 | 103 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30110934 | 30110934 | PRJNA565584_P_NODE_165392_length_252_cov_1.435754_g164240_i0 | PRJNA565584 | 165392 | 252 | 1.435754 | 3.61810008 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 139 | 1.72e-37 | NR | MEE3417719.1 | 2666342 | g164240 | i0 | 79.5 | 0.988095238095238 | 83 | 17 | 98.8 | 0 | 251 | 3 | 40 | 122 | MEE3417719.1 T4 RnlA family RNA ligase [Methanosphaera sp.] | diamond | 249 | 139 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 30142132 | 30142132 | PRJNA565584_P_NODE_107292_length_290_cov_1.179724_g106140_i0 | PRJNA565584 | 107292 | 290 | 1.179724 | 3.4211996 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 138 | 5.78e-37 | NR | MEE3417719.1 | 2666342 | g106140 | i0 | 69.8 | 0.993103448275862 | 96 | 29 | 99.3 | 0 | 1 | 288 | 186 | 281 | MEE3417719.1 T4 RnlA family RNA ligase [Methanosphaera sp.] | diamond | 288 | 138 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 31279992 | 31279992 | PRJNA565584_P_NODE_177255_length_249_cov_0.875000_g176103_i0 | PRJNA565584 | 177255 | 249 | 0.875 | 2.17875 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 45.4 | 0.00442 | NR | WP_296809049.1 | 253161 | g176103 | i0 | 46.8 | 0.566265060240964 | 47 | 25 | 56.6 | 0 | 30 | 170 | 173 | 219 | WP_296809049.1 hypothetical protein, partial [uncultured Methanobrevibacter sp.] | diamond | 141 | 45.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 31673229 | 31673229 | PRJNA565584_P_NODE_141137_length_268_cov_1.471795_g139985_i0 | PRJNA565584 | 141137 | 268 | 1.471795 | 3.9444106 | root | 1 | Root_unresolved | Root_unresolved | 82.8 | 3.29e-17 | NR | MBR3140274.1 | 66852 | g139985 | i0 | 51.6 | 3.85074626865672 | 93 | 38 | 96.3 | 3 | 258 | 1 | 17 | 109 | MBR3140274.1 class I SAM-dependent methyltransferase [Methanobrevibacter sp.] | diamond | 1032 | 83.6 | 0.990430622009569 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31691166 | 31691166 | PRJNA565584_P_NODE_105857_length_291_cov_1.394495_g104705_i0 | PRJNA565584 | 105857 | 291 | 1.394495 | 4.05798045 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 62.4 | 8.1e-9 | NR | WP_295614768.1 | 253161 | g104705 | i0 | 59.1 | 1.38144329896907 | 44 | 18 | 45.4 | 0 | 2 | 133 | 777 | 820 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 402 | 62.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 32734671 | 32734671 | PRJNA565584_P_NODE_152920_length_260_cov_1.780749_g151768_i0 | PRJNA565584 | 152920 | 260 | 1.780749 | 4.6299474 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 80.1 | 1.2e-17 | NR | MBR0369331.1 | 66852 | g151768 | i0 | 59.7 | 0.773076923076923 | 67 | 27 | 77.3 | 0 | 235 | 35 | 3 | 69 | MBR0369331.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 201 | 80.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);;