contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27366716 | 27366716 | PRJNA680334_S_NODE_94603_length_156_cov_3.642276_g94117_i0 | PRJNA680334 | 94603 | 156 | 3.642276 | 5.68195056 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 48.9 | 2.64e-5 | NR | HEY1052478.1 | 1965333 | g94117 | i0 | 91.7 | 0.461538461538462 | 24 | 2 | 46.2 | 0 | 154 | 83 | 122 | 145 | HEY1052478.1 hypothetical protein [Prosthecobacter sp.] | diamond | 72 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27934846 | 27934846 | PRJNA680334_S_NODE_47805_length_194_cov_5.894410_g47319_i0 | PRJNA680334 | 47805 | 194 | 5.89441 | 11.4351554 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 41.6 | 0.0238 | NR | MFT5409024.1 | 2026801 | g47319 | i0 | 37.5 | 0.865979381443299 | 56 | 35 | 86.6 | 0 | 15 | 182 | 16 | 71 | MFT5409024.1 Fe-S-cluster containining protein [Verrucomicrobiales bacterium] | diamond | 168 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28124293 | 28124293 | PRJNA680334_S_NODE_81265_length_164_cov_2.946565_g80779_i0 | PRJNA680334 | 81265 | 164 | 2.946565 | 4.8323666 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 51.6 | 2.89e-6 | NR | MBQ3143436.1 | 1872421 | g80779 | i0 | 49.1 | 0.969512195121951 | 53 | 23 | 89.6 | 1 | 17 | 163 | 65 | 117 | MBQ3143436.1 hypothetical protein [Akkermansia sp.] | diamond | 159 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29797512 | 29797512 | PRJNA680334_S_NODE_52211_length_189_cov_3.967949_g51725_i0 | PRJNA680334 | 52211 | 189 | 3.967949 | 7.49942361 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 43.1 | 0.0136 | NR | HAL05353.1 | 2026801 | g51725 | i0 | 38.5 | 3.3015873015873 | 52 | 24 | 71.4 | 2 | 55 | 189 | 4 | 54 | HAL05353.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 624 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30176656 | 30176656 | PRJNA680334_S_NODE_71432_length_171_cov_3.152174_g70946_i0 | PRJNA680334 | 71432 | 171 | 3.152174 | 5.39021754 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 50.4 | 2.67e-5 | NR | HEU5069142.1 | 2499141 | g70946 | i0 | 60 | 1.19298245614035 | 35 | 14 | 61.4 | 0 | 37 | 141 | 282 | 316 | HEU5069142.1 bile acid:sodium symporter family protein [Verrucomicrobiia bacterium] | diamond | 204 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30429875 | 30429875 | PRJNA680334_S_NODE_18673_length_260_cov_2.488987_g18187_i0 | PRJNA680334 | 18673 | 260 | 2.488987 | 6.4713662 | Brevifollis gellanilyticus | 748831 | Bacteria | Bacteria | 109 | 1.29e-25 | NR | WP_146854010.1 | 748831 | g18187 | i0 | 68.7 | 0.957692307692308 | 83 | 26 | 95.8 | 0 | 1 | 249 | 993 | 1075 | WP_146854010.1 FtsX-like permease family protein [Brevifollis gellanilyticus] | diamond | 249 | 109 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Brevifollis | Brevifollis gellanilyticus | |
| 30587341 | 30587341 | PRJNA680334_S_NODE_82173_length_163_cov_9.253846_g81687_i0 | PRJNA680334 | 82173 | 163 | 9.253846 | 15.08376898 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 80.9 | 2.06e-16 | NR | MBA3834005.1 | 2201154 | g81687 | i0 | 82.2 | 0.828220858895706 | 45 | 8 | 82.8 | 0 | 1 | 135 | 272 | 316 | MBA3834005.1 IS481 family transposase [Chthoniobacterales bacterium] | diamond | 135 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 31187466 | 31187466 | PRJNA680334_S_NODE_23235_length_243_cov_2.619048_g22749_i0 | PRJNA680334 | 23235 | 243 | 2.619048 | 6.36428664 | Terrimicrobium sacchariphilum | 690879 | Bacteria | Bacteria | 43.9 | 0.0142 | NR | WP_075080473.1 | 690879 | g22749 | i0 | 52.1 | 0.592592592592593 | 48 | 23 | 59.3 | 0 | 144 | 1 | 6 | 53 | WP_075080473.1 hypothetical protein [Terrimicrobium sacchariphilum] | diamond | 144 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sacchariphilum | |
| 31377695 | 31377695 | PRJNA680334_S_NODE_67836_length_174_cov_2.758865_g67350_i0 | PRJNA680334 | 67836 | 174 | 2.758865 | 4.8004251 | Candidatus Udaeobacter sp. | 2665650 | Bacteria | Bacteria | 57.4 | 9.75e-9 | NR | HEY2680206.1 | 2665650 | g67350 | i0 | 93.3 | 3.06896551724138 | 30 | 2 | 51.7 | 0 | 2 | 91 | 62 | 91 | HEY2680206.1 biotin/lipoyl-containing protein [Candidatus Udaeobacter sp.] | diamond | 534 | 57.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Candidatus Udaeobacter | Candidatus Udaeobacter sp. | |
| 31599152 | 31599152 | PRJNA680334_S_NODE_93016_length_157_cov_2.967742_g92530_i0 | PRJNA680334 | 93016 | 157 | 2.967742 | 4.65935494 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 94 | 2.1e-21 | NR | HEX7516570.1 | 2201154 | g92530 | i0 | 84.6 | 1.96815286624204 | 52 | 8 | 99.4 | 0 | 157 | 2 | 90 | 141 | HEX7516570.1 hypothetical protein [Chthoniobacterales bacterium] | diamond | 309 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32611173 | 32611173 | PRJNA680334_S_NODE_76040_length_168_cov_1.555556_g75554_i0 | PRJNA680334 | 76040 | 168 | 1.555556 | 2.61333408 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 91.7 | 6.55e-20 | NR | HXT84495.1 | 2499141 | g75554 | i0 | 93.5 | 0.821428571428571 | 46 | 3 | 82.1 | 0 | 31 | 168 | 86 | 131 | HXT84495.1 phosphopantothenoylcysteine decarboxylase [Verrucomicrobiia bacterium] | diamond | 138 | 91.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium |
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);;