contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26644457 | 26644457 | PRJNA914897_P_NODE_2381_length_1256_cov_1.918850_g2169_i0 | PRJNA914897 | 2381 | 1256 | 1.91885 | 24.100756 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 52.4 | 0.00429 | NR | WP_292749283.1 | 66852 | g2169 | i0 | 28.7 | 0.32484076433121 | 136 | 84 | 29.4 | 3 | 430 | 62 | 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. | |
| 28982736 | 28982736 | PRJNA914897_P_NODE_27928_length_303_cov_1.339130_g27504_i0 | PRJNA914897 | 27928 | 303 | 1.33913 | 4.0575639 | Methanothermobacter marburgensis | 145263 | Archaea | Archaea | 52 | 4.32e-5 | NR | WP_013295055.1 | 145263 | g27504 | i0 | 38.9 | 6.05940594059406 | 72 | 42 | 71.3 | 1 | 88 | 303 | 338 | 407 | WP_013295055.1 IGHMBP2 family helicase [Methanothermobacter marburgensis] | diamond | 1836 | 52 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanothermobacter | Methanothermobacter marburgensis | |
| 29361435 | 29361435 | PRJNA914897_P_NODE_23729_length_338_cov_1.528302_g23305_i0 | PRJNA914897 | 23729 | 338 | 1.528302 | 5.16566076 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 60.5 | 7.03e-8 | NR | WP_292800363.1 | 66852 | g23305 | i0 | 41.1 | 1.29585798816568 | 73 | 38 | 61.2 | 2 | 1 | 207 | 922 | 993 | WP_292800363.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 438 | 60.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30687931 | 30687931 | PRJNA914897_P_NODE_34893_length_260_cov_1.235294_g34469_i0 | PRJNA914897 | 34893 | 260 | 1.235294 | 3.2117644 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 43.5 | 0.0105 | NR | WP_345895079.1 | 66852 | g34469 | i0 | 36.4 | 0.888461538461538 | 77 | 42 | 86.5 | 3 | 20 | 244 | 56 | 127 | WP_345895079.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 231 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31390864 | 31390864 | PRJNA914897_P_NODE_5076_length_888_cov_2.592638_g4734_i0 | PRJNA914897 | 5076 | 888 | 2.592638 | 23.02262544 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 2.38e-6 | NR | MBO7518105.1 | 66852 | g4734 | i0 | 47.4 | 1.05743243243243 | 57 | 29 | 18.9 | 1 | 519 | 686 | 415 | 471 | MBO7518105.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 939 | 60.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31446642 | 31446642 | PRJNA914897_P_NODE_31036_length_282_cov_2.014354_g30612_i0 | PRJNA914897 | 31036 | 282 | 2.014354 | 5.68047828 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 42.7 | 0.018 | NR | WP_296881009.1 | 253161 | g30612 | i0 | 37.1 | 0.659574468085106 | 62 | 39 | 66 | 0 | 237 | 52 | 42 | 103 | WP_296881009.1 hypothetical protein [uncultured Methanobrevibacter sp.] | diamond | 186 | 42.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 32529852 | 32529852 | PRJNA914897_P_NODE_10379_length_583_cov_1.650980_g9962_i0 | PRJNA914897 | 10379 | 583 | 1.65098 | 9.6252134 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 3.99e-16 | NR | MDR3292372.1 | 66852 | g9962 | i0 | 33.5 | 3.89536878216123 | 194 | 109 | 91.6 | 6 | 536 | 3 | 10 | 199 | MDR3292372.1 aquaporin family protein [Methanobrevibacter sp.] | diamond | 2271 | 85.5 | 0.990643274853801 | 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);;