contig_metadata
6 rows where bioproject = "PRJNA484127" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9376149 | 9376149 | PRJNA484127_P_NODE_15688_length_323_cov_1.248000_g15539_i0 | PRJNA484127 | 15688 | 323 | 1.248 | 4.03104 | Halobacterium litoreum | 2039234 | Archaea | Archaea | 52.8 | 0.03 | NTclustered | gi|2168234898|gb|CP089466.1| | 2039234 | g15539 | i0 | 100 | 0.086687306501548 | 28 | 0 | 9 | 0 | 174 | 201 | 1876998 | 1877025 | Halobacterium litoreum strain ZS-54-S2 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium litoreum | |
| 14477428 | 14477428 | PRJNA484127_P_NODE_8552_length_407_cov_1.209581_g8403_i0 | PRJNA484127 | 8552 | 407 | 1.209581 | 4.92299467 | Haloterrigena salinisoli | 3132747 | Archaea | Archaea | 54.7 | 0.011 | NTclustered | gi|2706837818|gb|CP149787.1| | 3132747 | g8403 | i0 | 90.244 | 0.179361179361179 | 41 | 4 | 10 | 0 | 231 | 271 | 511637 | 511597 | Haloterrigena salinisoli strain KLK7 chromosome, complete genome | blastn | 73 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena salinisoli | |
| 18300232 | 18300232 | PRJNA484127_P_NODE_34815_length_247_cov_0.896552_g34666_i0 | PRJNA484127 | 34815 | 247 | 0.896552 | 2.21448344 | Pyrococcus kukulkanii | 1609559 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|1001991447|gb|CP010835.1| | 1609559 | g34666 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 125 | 152 | 519895 | 519922 | Pyrococcus kukulkanii strain NCB100 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus kukulkanii | ||
| 26823272 | 26823272 | PRJNA484127_P_NODE_33521_length_248_cov_0.891429_g33372_i0 | PRJNA484127 | 33521 | 248 | 0.891429 | 2.21074392 | Methanocalculus sp. MSAO_Arc2 | 2293855 | Archaea | Archaea | 91.3 | 1.76e-19 | NR | WP_346865000.1 | 2293855 | g33372 | i0 | 58.8 | 1.86290322580645 | 80 | 29 | 96.8 | 1 | 5 | 244 | 81 | 156 | WP_346865000.1 TIGR04084 family radical SAM/SPASM domain-containing protein [Methanocalculus sp. MSAO_Arc2] | diamond | 462 | 91.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocalculaceae | Methanocalculus | Methanocalculus sp. MSAO_Arc2 | |
| 29696891 | 29696891 | PRJNA484127_P_NODE_39290_length_240_cov_2.886228_g39141_i0 | PRJNA484127 | 39290 | 240 | 2.886228 | 6.9269472 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 42.4 | 0.05 | NR | WP_048085055.1 | 2162 | g39141 | i0 | 41.9 | 0.5375 | 43 | 25 | 53.8 | 0 | 204 | 76 | 145 | 187 | WP_048085055.1 ABC-ATPase domain-containing protein [Methanobacterium formicicum] | diamond | 129 | 42.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 30329571 | 30329571 | PRJNA484127_P_NODE_20732_length_290_cov_4.903226_g20583_i0 | PRJNA484127 | 20732 | 290 | 4.903226 | 14.2193554 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 140 | 3.0600000000000004e-36 | NR | MEM2900767.1 | 1906666 | g20583 | i0 | 72.8 | 5.7 | 92 | 25 | 95.2 | 0 | 276 | 1 | 39 | 130 | MEM2900767.1 pyruvate, phosphate dikinase [Thermoplasmata archaeon] | diamond | 1653 | 140 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon |
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);;