contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1264536" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1638782 | 1638782 | PRJNA1264536_P_NODE_5442_length_243_cov_0.888235_g5368_i0 | PRJNA1264536 | 5442 | 243 | 0.888235 | 2.15841105 | Odoribacter sp. | 1965233 | Bacteria | Bacteria | 154 | 5.079999999999999e-43 | NR | MDE7074187.1 | 1965233 | g5368 | i0 | 90 | 3.95061728395062 | 80 | 8 | 98.8 | 0 | 241 | 2 | 86 | 165 | MDE7074187.1 IMP dehydrogenase [Odoribacter sp.] | diamond | 960 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Odoribacteraceae | Odoribacter | Odoribacter sp. | |
| 18215650 | 18215650 | PRJNA1264536_P_NODE_4595_length_251_cov_0.876404_g4521_i0 | PRJNA1264536 | 4595 | 251 | 0.876404 | 2.19977404 | Hanamia sp. | 2930256 | Bacteria | Bacteria | 166 | 2.81e-46 | NR | HXS57568.1 | 2930256 | g4521 | i0 | 90.4 | 3.9681274900398402 | 83 | 8 | 99.2 | 0 | 250 | 2 | 383 | 465 | HXS57568.1 alpha/beta hydrolase-fold protein [Hanamia sp.] | diamond | 996 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Hanamia | Hanamia sp. | |
| 27831957 | 27831957 | PRJNA1264536_P_NODE_5424_length_243_cov_0.917647_g5350_i0 | PRJNA1264536 | 5424 | 243 | 0.917647 | 2.22988221 | Bacteroides sp. | 29523 | Bacteria | Bacteria | 143 | 2.93e-38 | NR | MBP3669283.1 | 29523 | g5350 | i0 | 92.5 | 0.987654320987654 | 80 | 6 | 98.8 | 0 | 242 | 3 | 399 | 478 | MBP3669283.1 ComEC/Rec2 family competence protein [Bacteroides sp.] | diamond | 240 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides sp. | |
| 27989978 | 27989978 | PRJNA1264536_P_NODE_5305_length_244_cov_0.912281_g5231_i0 | PRJNA1264536 | 5305 | 244 | 0.912281 | 2.22596564 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 80.9 | 5.15e-16 | NR | MFO7844437.1 | 2030927 | g5231 | i0 | 48.1 | 0.995901639344262 | 81 | 42 | 99.6 | 0 | 2 | 244 | 199 | 279 | MFO7844437.1 hypothetical protein [Bacteroidales bacterium] | diamond | 243 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 29126804 | 29126804 | PRJNA1264536_P_NODE_5489_length_242_cov_0.923077_g5415_i0 | PRJNA1264536 | 5489 | 242 | 0.923077 | 2.23384634 | Salinivirgaceae bacterium | 2053305 | Bacteria | Bacteria | 50.4 | 4.87e-6 | NR | MFO7863651.1 | 2053305 | g5415 | i0 | 53.3 | 0.557851239669422 | 45 | 21 | 55.8 | 0 | 51 | 185 | 29 | 73 | MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium] | diamond | 135 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Salinivirgaceae | Salinivirgaceae bacterium | ||
| 30471043 | 30471043 | PRJNA1264536_P_NODE_5273_length_244_cov_0.912281_g5199_i0 | PRJNA1264536 | 5273 | 244 | 0.912281 | 2.22596564 | FCB group | 1783270 | Bacteria | Bacteria | 42.7 | 0.00533 | NR | WP_289539213.1 | 376804 | g5199 | i0 | 44.7 | 1.81967213114754 | 38 | 21 | 46.7 | 0 | 239 | 126 | 15 | 52 | WP_289539213.1 hypothetical protein [Phocaeicola barnesiae] | diamond | 444 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola barnesiae | |
| 30579187 | 30579187 | PRJNA1264536_P_NODE_5133_length_246_cov_0.809249_g5059_i0 | PRJNA1264536 | 5133 | 246 | 0.809249 | 1.99075254 | Salinivirgaceae bacterium | 2053305 | Bacteria | Bacteria | 50.8 | 3.69e-6 | NR | MFO7863651.1 | 2053305 | g5059 | i0 | 57.8 | 0.548780487804878 | 45 | 19 | 54.9 | 0 | 55 | 189 | 29 | 73 | MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium] | diamond | 135 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Salinivirgaceae | Salinivirgaceae bacterium | ||
| 31875409 | 31875409 | PRJNA1264536_P_NODE_3637_length_288_cov_1.381395_g3563_i0 | PRJNA1264536 | 3637 | 288 | 1.381395 | 3.9784176 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 68.9 | 1.24e-12 | NR | REK64910.1 | 1898104 | g3563 | i0 | 63.8 | 0.489583333333333 | 47 | 17 | 49 | 0 | 286 | 146 | 67 | 113 | REK64910.1 MAG: hypothetical protein DWQ49_01035, partial [Bacteroidota bacterium] | diamond | 141 | 68.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 32854914 | 32854914 | PRJNA1264536_P_NODE_4680_length_250_cov_0.881356_g4606_i0 | PRJNA1264536 | 4680 | 250 | 0.881356 | 2.20339 | Salinivirgaceae bacterium | 2053305 | Bacteria | Bacteria | 41.2 | 0.0218 | NR | MFO7863651.1 | 2053305 | g4606 | i0 | 81.8 | 0.264 | 22 | 4 | 26.4 | 0 | 3 | 68 | 52 | 73 | MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium] | diamond | 66 | 41.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Salinivirgaceae | Salinivirgaceae 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);;