contig_metadata
13 rows where bioproject = "PRJNA1264536" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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. | |
| 8017293 | 8017293 | PRJNA1264536_P_NODE_4887_length_248_cov_0.891429_g4813_i0 | PRJNA1264536 | 4887 | 248 | 0.891429 | 2.21074392 | Aquirufa lenticrescens | 2696560 | Bacteria | Bacteria | 337 | 5.53e-88 | NTclustered | gi|2091518249|gb|CP049834.1| | 2696560 | g4813 | i0 | 91.429 | 1.97983870967742 | 245 | 21 | 99 | 0 | 2 | 246 | 758984 | 758740 | Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome | blastn | 491 | 337 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Aquirufa | Aquirufa lenticrescens | |
| 11257338 | 11257338 | PRJNA1264536_P_NODE_4449_length_252_cov_0.871508_g4375_i0 | PRJNA1264536 | 4449 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 460 | 3.2e-125 | NTclustered | gi|2625468065|gb|CP139161.1| | 817 | g4375 | i0 | 99.603 | 71.5833333333333 | 252 | 1 | 100 | 0 | 1 | 252 | 2622048 | 2622299 | Bacteroides fragilis strain ZY0804 chromosome, complete genome | blastn | 18039 | 460 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides fragilis | |
| 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. | |
| 20180109 | 20180109 | PRJNA1264536_P_NODE_5276_length_244_cov_0.912281_g5202_i0 | PRJNA1264536 | 5276 | 244 | 0.912281 | 2.22596564 | Odoribacter | 283168 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|1231719245|emb|LT906459.1| | 28118 | g5202 | i0 | 100 | 3 | 244 | 0 | 100 | 0 | 1 | 244 | 1541327 | 1541570 | Odoribacter splanchnicus strain NCTC10825 genome assembly, chromosome: 1 | blastn | 732 | 451 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Odoribacteraceae | Odoribacter | Odoribacter splanchnicus | |
| 22040590 | 22040590 | PRJNA1264536_P_NODE_5038_length_247_cov_0.885057_g4964_i0 | PRJNA1264536 | 5038 | 247 | 0.885057 | 2.18609079 | Myroides odoratimimus | 76832 | Bacteria | Bacteria | 451 | 1.88e-122 | NTclustered | gi|2868334726|gb|CP121791.1| | 76832 | g4964 | i0 | 99.595 | 8 | 247 | 1 | 100 | 0 | 1 | 247 | 44289 | 44535 | Myroides odoratimimus strain pgdne chromosome | blastn | 1976 | 451 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Myroides | Myroides odoratimimus | |
| 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);;