contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1011833" and tax_clade = "FCB 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4829585 | 4829585 | PRJNA1011833_S_NODE_16124_length_301_cov_2.093023_g15704_i0 | PRJNA1011833 | 16124 | 301 | 2.093023 | 6.29999923 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 111 | 1.6300000000000002e-27 | NR | NLV37679.1 | 2030927 | g15704 | i0 | 58 | 0.877076411960133 | 88 | 37 | 87.7 | 0 | 3 | 266 | 166 | 253 | NLV37679.1 glucosamine-6-phosphate deaminase [Bacteroidales bacterium] | diamond | 264 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 26591213 | 26591213 | PRJNA1011833_S_NODE_33981_length_201_cov_1.177215_g33561_i0 | PRJNA1011833 | 33981 | 201 | 1.177215 | 2.36620215 | Flavipsychrobacter sp. | 2307286 | Bacteria | Bacteria | 42.4 | 0.0287 | NR | MCW3123626.1 | 2307286 | g33561 | i0 | 42.2 | 0.671641791044776 | 45 | 26 | 67.2 | 0 | 145 | 11 | 190 | 234 | MCW3123626.1 O-antigen ligase protein [Flavipsychrobacter sp.] | diamond | 135 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Flavipsychrobacter | Flavipsychrobacter sp. | |
| 27635099 | 27635099 | PRJNA1011833_S_NODE_16644_length_296_cov_4.750988_g16224_i0 | PRJNA1011833 | 16644 | 296 | 4.750988 | 14.06292448 | Flavobacteriaceae bacterium | 1871037 | Bacteria | Bacteria | 100 | 1.2800000000000001e-22 | NR | MDC0637698.1 | 1871037 | g16224 | i0 | 49.5 | 2.83783783783784 | 95 | 48 | 96.3 | 0 | 296 | 12 | 293 | 387 | MDC0637698.1 proline dehydrogenase family protein [Flavobacteriaceae bacterium] | diamond | 840 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 28140416 | 28140416 | PRJNA1011833_S_NODE_38085_length_189_cov_0.986301_g37665_i0 | PRJNA1011833 | 38085 | 189 | 0.986301 | 1.86410889 | Flavobacteriia bacterium | 2044941 | Bacteria | Bacteria | 42 | 0.0306 | NR | NBX38946.1 | 2044941 | g37665 | i0 | 50 | 0.857142857142857 | 54 | 25 | 84.1 | 2 | 3 | 161 | 172 | 224 | NBX38946.1 lycopene cyclase domain-containing protein [Flavobacteriia bacterium] | diamond | 162 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriia bacterium | ||||
| 29465863 | 29465863 | PRJNA1011833_S_NODE_10130_length_368_cov_8.286154_g9712_i0 | PRJNA1011833 | 10130 | 368 | 8.286154 | 30.49304672 | Roseivirga sp. | 1964215 | Bacteria | Bacteria | 51.6 | 1.1e-4 | NR | MFT6053375.1 | 1964215 | g9712 | i0 | 48 | 2.58423913043478 | 50 | 25 | 40.8 | 1 | 13 | 162 | 373 | 421 | MFT6053375.1 putative AlkP superfamily pyrophosphatase or phosphodiesterase [Roseivirga sp.] | diamond | 951 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Roseivirgaceae | Roseivirga | Roseivirga sp. | |
| 30224173 | 30224173 | PRJNA1011833_S_NODE_37712_length_190_cov_1.061224_g37292_i0 | PRJNA1011833 | 37712 | 190 | 1.061224 | 2.0163256 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 43.1 | 0.0139 | NR | KAA3622062.1 | 1898104 | g37292 | i0 | 41 | 0.615789473684211 | 39 | 23 | 61.6 | 0 | 5 | 121 | 734 | 772 | KAA3622062.1 MAG: hypothetical protein DWQ02_26710 [Bacteroidota bacterium] | diamond | 117 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30627236 | 30627236 | PRJNA1011833_S_NODE_20673_length_265_cov_1.824324_g20253_i0 | PRJNA1011833 | 20673 | 265 | 1.824324 | 4.8344586 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 1.2399999999999998e-29 | NR | MBL7850048.1 | 2099675 | g20253 | i0 | 66.3 | 4.77735849056604 | 80 | 27 | 90.6 | 0 | 241 | 2 | 857 | 936 | MBL7850048.1 aminomethyl-transferring glycine dehydrogenase [Cyclobacteriaceae bacterium] | diamond | 1266 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 31804579 | 31804579 | PRJNA1011833_S_NODE_1937_length_639_cov_52.954698_g1598_i0 | PRJNA1011833 | 1937 | 639 | 52.954698 | 338.38052022 | Candidatus Aegiribacteria sp. | 2528271 | Bacteria | Bacteria | 94.7 | 1.7400000000000003e-21 | NR | MFO8183585.1 | 2528271 | g1598 | i0 | 57.7 | 1.15023474178404 | 78 | 33 | 36.6 | 0 | 588 | 355 | 2 | 79 | MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.] | diamond | 735 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Aegiribacteria | Candidatus Aegiribacteria sp. | |||||
| 32839697 | 32839697 | PRJNA1011833_S_NODE_49560_length_164_cov_1.975207_g49140_i0 | PRJNA1011833 | 49560 | 164 | 1.975207 | 3.23933948 | Bacteria | 2 | Bacteria | Bacteria | 86.7 | 3.82e-18 | NR | WP_014224542.1 | 28112 | g49140 | i0 | 69.8 | 20.359756097561 | 53 | 16 | 97 | 0 | 159 | 1 | 84 | 136 | WP_014224542.1 adenosylhomocysteinase [Tannerella forsythia] | diamond | 3339 | 86.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Tannerellaceae | Tannerella | Tannerella forsythia |
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);;