contig_metadata
8 rows where bioproject = "PRJNA724011", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9638881 | 9638881 | PRJNA724011_P_NODE_109348_length_241_cov_0.916667_g108325_i0 | PRJNA724011 | 109348 | 241 | 0.916667 | 2.20916747 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 146 | 7.88e-39 | NR | MBO7518297.1 | 66852 | g108325 | i0 | 82.3 | 5.91286307053942 | 79 | 14 | 98.3 | 0 | 241 | 5 | 436 | 514 | MBO7518297.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 1425 | 146 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27399963 | 27399963 | PRJNA724011_P_NODE_54963_length_346_cov_2.816850_g53940_i0 | PRJNA724011 | 54963 | 346 | 2.81685 | 9.746301 | Methanobacterium sp. | 2164 | Archaea | Archaea | 80.9 | 5.3e-15 | NR | MCE5214594.1 | 2164 | g53940 | i0 | 44.2 | 0.745664739884393 | 86 | 48 | 74.6 | 0 | 72 | 329 | 562 | 647 | MCE5214594.1 carboxypeptidase regulatory-like domain-containing protein [Methanobacterium sp.] | diamond | 258 | 80.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 27873388 | 27873388 | PRJNA724011_P_NODE_4325_length_1491_cov_3.806770_g3845_i0 | PRJNA724011 | 4325 | 1491 | 3.80677 | 56.7589407 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 52.4 | 0.00586 | NR | WP_292749283.1 | 66852 | g3845 | i0 | 28.7 | 0.27364185110664 | 136 | 84 | 24.7 | 3 | 1053 | 1421 | 268 | 403 | WP_292749283.1 C1 family peptidase [Methanobrevibacter sp.] | diamond | 408 | 52.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29462224 | 29462224 | PRJNA724011_P_NODE_77950_length_282_cov_1.105263_g76927_i0 | PRJNA724011 | 77950 | 282 | 1.105263 | 3.11684166 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 8.99e-4 | NR | WP_330039973.1 | 66852 | g76927 | i0 | 31.8 | 1.6595744680851101 | 88 | 46 | 83 | 3 | 1 | 234 | 158 | 241 | WP_330039973.1 potassium channel family protein [Methanobrevibacter sp.] | diamond | 468 | 48.1 | 0.993762993762994 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29778183 | 29778183 | PRJNA724011_P_NODE_82471_length_272_cov_1.547739_g81448_i0 | PRJNA724011 | 82471 | 272 | 1.547739 | 4.20985008 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 8.43e-6 | NR | WP_209731630.1 | 2188 | g81448 | i0 | 42.9 | 5.19485294117647 | 63 | 36 | 69.5 | 0 | 267 | 79 | 198 | 260 | WP_209731630.1 AAA domain-containing protein [Methanococcus voltae] | diamond | 1413 | 53.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae | |
| 31895807 | 31895807 | PRJNA724011_P_NODE_35177_length_458_cov_1.927273_g34158_i0 | PRJNA724011 | 35177 | 458 | 1.927273 | 8.82691034 | Methanosphaera | 2316 | Archaea | Archaea | 73.2 | 5.63e-12 | NR | WP_294967419.1 | 262501 | g34158 | i0 | 52.4 | 2.03711790393013 | 63 | 25 | 38.6 | 2 | 219 | 395 | 70 | 131 | WP_294967419.1 LicD family protein [uncultured Methanosphaera sp.] | diamond | 933 | 73.6 | 0.994565217391304 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | uncultured Methanosphaera sp. | |
| 32370616 | 32370616 | PRJNA724011_P_NODE_11599_length_914_cov_4.183115_g10729_i0 | PRJNA724011 | 11599 | 914 | 4.183115 | 38.2336711 | root | 1 | Root_unresolved | Root_unresolved | 102 | 9.04e-22 | NR | MDR3292372.1 | 66852 | g10729 | i0 | 32.3 | 3.85339168490153 | 235 | 133 | 69.9 | 7 | 50 | 688 | 10 | 240 | MDR3292372.1 aquaporin family protein [Methanobrevibacter sp.] | diamond | 3522 | 102 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32896234 | 32896234 | PRJNA724011_P_NODE_84020_length_269_cov_1.571429_g82997_i0 | PRJNA724011 | 84020 | 269 | 1.571429 | 4.22714401 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 60.1 | 4.06e-8 | NR | WP_295723618.1 | 253161 | g82997 | i0 | 39.5 | 3.37918215613383 | 76 | 42 | 84.8 | 2 | 2 | 229 | 775 | 846 | WP_295723618.1 cyclic nucleotide-binding serine/threonine-protein kinase [uncultured Methanobrevibacter sp.] | diamond | 909 | 60.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured 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);;