contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_clade = "Stenosarchaea 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19736948 | 19736948 | PRJNA640143_S_NODE_5956_length_340_cov_54.112211_g5746_i0 | PRJNA640143 | 5956 | 340 | 54.112211 | 183.9815174 | root | 1 | Root_unresolved | Root_unresolved | 166 | 2.1999999999999997e-47 | NR | MDY0386670.1 | 1874737 | g5746 | i0 | 79 | 4.41176470588235 | 100 | 21 | 88.2 | 0 | 305 | 6 | 4 | 103 | MDY0386670.1 IS200/IS605 family element RNA-guided endonuclease TnpB [Methanolobus sp.] | diamond | 1500 | 167 | 0.994011976047904 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 27554711 | 27554711 | PRJNA640143_S_NODE_15284_length_223_cov_2.225806_g15074_i0 | PRJNA640143 | 15284 | 223 | 2.225806 | 4.96354738 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 128 | 2.1e-32 | NR | NMA31642.1 | 2099674 | g15074 | i0 | 74 | 0.982062780269058 | 73 | 19 | 98.2 | 0 | 221 | 3 | 231 | 303 | NMA31642.1 PHP domain-containing protein [Candidatus Methanofastidiosia archaeon] | diamond | 219 | 128 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 28641102 | 28641102 | PRJNA640143_S_NODE_4807_length_374_cov_2.765579_g4597_i0 | PRJNA640143 | 4807 | 374 | 2.765579 | 10.34326546 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.0301 | NR | MCX9085671.1 | 2032688 | g4597 | i0 | 57.6 | 0.497326203208556 | 33 | 14 | 26.5 | 0 | 374 | 276 | 304 | 336 | MCX9085671.1 tetratricopeptide repeat protein [Candidatus Methanoperedens sp.] | diamond | 186 | 45.1 | 0.991130820399113 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29670032 | 29670032 | PRJNA640143_S_NODE_17650_length_208_cov_4.315789_g17440_i0 | PRJNA640143 | 17650 | 208 | 4.315789 | 8.97684112 | Methanogenium sp. | 2196 | Archaea | Archaea | 83.6 | 3.89e-17 | NR | MFA5398591.1 | 2196 | g17440 | i0 | 56.1 | 0.951923076923077 | 66 | 29 | 95.2 | 0 | 5 | 202 | 186 | 251 | MFA5398591.1 hypothetical protein [Methanogenium sp.] | diamond | 198 | 83.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 30902546 | 30902546 | PRJNA640143_S_NODE_17954_length_206_cov_313.739645_g17744_i0 | PRJNA640143 | 17954 | 206 | 313.739645 | 646.3036687 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 59.3 | 8.92e-10 | NR | MEN6379726.1 | 2666341 | g17744 | i0 | 49.1 | 0.771844660194175 | 53 | 27 | 77.2 | 0 | 47 | 205 | 9 | 61 | MEN6379726.1 hypothetical protein [Methanofastidiosum sp.] | diamond | 159 | 59.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 32262666 | 32262666 | PRJNA640143_S_NODE_15698_length_220_cov_6.000000_g15488_i0 | PRJNA640143 | 15698 | 220 | 6 | 13.2 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 108 | 6.620000000000001e-26 | NR | HQK63031.1 | 2666341 | g15488 | i0 | 80.6 | 0.845454545454545 | 62 | 12 | 84.5 | 0 | 187 | 2 | 298 | 359 | HQK63031.1 transposase [Methanofastidiosum sp.] | diamond | 186 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum 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);;