contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA235310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1642198 | 1642198 | PRJNA235310_P_NODE_6382_length_162_cov_0.920354_g6356_i0 | PRJNA235310 | 6382 | 162 | 0.920354 | 1.49097348 | Ferruginibacter sp. | 1940288 | Bacteria | Bacteria | 103 | 1.28e-24 | NR | MEO5968007.1 | 1940288 | g6356 | i0 | 94.4 | 1 | 54 | 3 | 100 | 0 | 1 | 162 | 99 | 152 | MEO5968007.1 Na+/H+ antiporter NhaA [Ferruginibacter sp.] | diamond | 162 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter sp. | |
| 6745045 | 6745045 | PRJNA235310_P_NODE_4326_length_180_cov_1.190840_g4300_i0 | PRJNA235310 | 4326 | 180 | 1.19084 | 2.143512 | FCB group | 1783270 | Bacteria | Bacteria | 108 | 3.8800000000000006e-27 | NR | MEQ8535529.1 | 2038411 | g4300 | i0 | 83.1 | 2.93333333333333 | 59 | 10 | 98.3 | 0 | 178 | 2 | 108 | 166 | MEQ8535529.1 type I glyceraldehyde-3-phosphate dehydrogenase [Imperialibacter sp.] | diamond | 528 | 109 | 0.990825688073395 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flammeovirgaceae | Imperialibacter | Imperialibacter sp. | |
| 26838840 | 26838840 | PRJNA235310_P_NODE_2841_length_227_cov_0.910112_g2815_i0 | PRJNA235310 | 2841 | 227 | 0.910112 | 2.06595424 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 109 | 1.92e-26 | NR | MBS1518142.1 | 1898104 | g2815 | i0 | 68.9 | 17.7092511013216 | 74 | 23 | 97.8 | 0 | 5 | 226 | 241 | 314 | MBS1518142.1 tryptophan 2,3-dioxygenase [Bacteroidota bacterium] | diamond | 4020 | 110 | 0.990909090909091 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27073963 | 27073963 | PRJNA235310_P_NODE_5262_length_167_cov_0.881356_g5236_i0 | PRJNA235310 | 5262 | 167 | 0.881356 | 1.47186452 | Pedobacter sp. | 1411316 | Bacteria | Bacteria | 47 | 4.06e-4 | NR | RZK77798.1 | 1411316 | g5236 | i0 | 46 | 0.898203592814371 | 50 | 26 | 89.8 | 1 | 163 | 14 | 234 | 282 | RZK77798.1 MAG: hypothetical protein EOO85_07910, partial [Pedobacter sp.] | diamond | 150 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. | |
| 27629036 | 27629036 | PRJNA235310_P_NODE_4464_length_176_cov_1.622047_g4438_i0 | PRJNA235310 | 4464 | 176 | 1.622047 | 2.85480272 | Terrimonas | 296051 | Bacteria | Bacteria | 60.8 | 6.21e-9 | NR | MEM7104478.1 | 1898104 | g4438 | i0 | 71.8 | 1.43181818181818 | 39 | 11 | 66.5 | 0 | 10 | 126 | 114 | 152 | MEM7104478.1 Ig-like domain-containing protein [Bacteroidota bacterium] | diamond | 252 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27832053 | 27832053 | PRJNA235310_P_NODE_5284_length_167_cov_0.881356_g5258_i0 | PRJNA235310 | 5284 | 167 | 0.881356 | 1.47186452 | Flavobacterium beibuense F44-8 | 1406840 | Bacteria | Bacteria | 68.6 | 7.95e-13 | NR | KGO81188.1 | 1406840 | g5258 | i0 | 55.8 | 1.90419161676647 | 52 | 23 | 93.4 | 0 | 9 | 164 | 4 | 55 | KGO81188.1 hypothetical protein Q763_08895 [Flavobacterium beibuense F44-8] | diamond | 318 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium beibuense | |
| 27895140 | 27895140 | PRJNA235310_P_NODE_5_length_2296_cov_2.916333_g4_i0 | PRJNA235310 | 5 | 2296 | 2.916333 | 66.95900568 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 228 | 3.21e-58 | NR | MEM7104478.1 | 1898104 | g4 | i0 | 42.1 | 0.415505226480836 | 318 | 153 | 39.6 | 8 | 3 | 911 | 29 | 330 | MEM7104478.1 Ig-like domain-containing protein [Bacteroidota bacterium] | diamond | 954 | 228 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 28116170 | 28116170 | PRJNA235310_P_NODE_425_length_561_cov_2.462891_g401_i0 | PRJNA235310 | 425 | 561 | 2.462891 | 13.81681851 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 175 | 4.5e-50 | NR | MFO0468276.1 | 1898104 | g401 | i0 | 54.2 | 0.818181818181818 | 153 | 67 | 80.2 | 1 | 536 | 87 | 196 | 348 | MFO0468276.1 fatty acid desaturase [Bacteroidota bacterium] | diamond | 459 | 175 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 28418413 | 28418413 | PRJNA235310_P_NODE_866_length_426_cov_1.864721_g840_i0 | PRJNA235310 | 866 | 426 | 1.864721 | 7.94371146 | Bacteria | 2 | Bacteria | Bacteria | 68.6 | 2.32e-10 | NR | MDR3273682.1 | 1871037 | g840 | i0 | 53.6 | 1.1830985915493 | 56 | 26 | 39.4 | 0 | 252 | 419 | 4 | 59 | MDR3273682.1 4-hydroxybutyrate CoA-transferase [Flavobacteriaceae bacterium] | diamond | 504 | 68.9 | 0.995645863570392 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 29189947 | 29189947 | PRJNA235310_P_NODE_5929_length_164_cov_0.904348_g5903_i0 | PRJNA235310 | 5929 | 164 | 0.904348 | 1.48313072 | Siphonobacter sp. BAB-54 | 1869184 | Bacteria | Bacteria | 74.3 | 9.24e-14 | NR | WP_102200481.1 | 1864825 | g5903 | i0 | 75 | 1.6280487804878 | 44 | 11 | 80.5 | 0 | 8 | 139 | 904 | 947 | WP_102200481.1 TonB-dependent receptor [Siphonobacter sp. BAB-5405] | diamond | 267 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Siphonobacter | Siphonobacter sp. BAB-5405 | |
| 29207713 | 29207713 | PRJNA235310_P_NODE_5289_length_167_cov_0.881356_g5263_i0 | PRJNA235310 | 5289 | 167 | 0.881356 | 1.47186452 | Bacteria | 2 | Bacteria | Bacteria | 79 | 4.98e-17 | NR | MBA2611136.1 | 1898104 | g5263 | i0 | 67.3 | 14.8203592814371 | 55 | 18 | 98.8 | 0 | 2 | 166 | 14 | 68 | MBA2611136.1 MaoC family dehydratase [Bacteroidota bacterium] | diamond | 2475 | 79.7 | 0.991217063989962 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29347733 | 29347733 | PRJNA235310_P_NODE_6029_length_164_cov_0.904348_g6003_i0 | PRJNA235310 | 6029 | 164 | 0.904348 | 1.48313072 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 76.3 | 1.93e-14 | NR | MBC8416206.1 | 2030808 | g6003 | i0 | 61.1 | 1.97560975609756 | 54 | 21 | 98.8 | 0 | 162 | 1 | 460 | 513 | MBC8416206.1 NAD-dependent malic enzyme [Candidatus Cloacimonadota bacterium] | diamond | 324 | 76.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 30154686 | 30154686 | PRJNA235310_P_NODE_3872_length_192_cov_1.090909_g3846_i0 | PRJNA235310 | 3872 | 192 | 1.090909 | 2.09454528 | Bacteria | 2 | Bacteria | Bacteria | 44.3 | 0.00537 | NR | MEX2602740.1 | 1974203 | g3846 | i0 | 35.8 | 3.625 | 53 | 34 | 82.8 | 0 | 167 | 9 | 415 | 467 | MEX2602740.1 YCF48-related protein [Gracilimonas sp.] | diamond | 696 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 30610992 | 30610992 | PRJNA235310_P_NODE_533_length_521_cov_1.584746_g509_i0 | PRJNA235310 | 533 | 521 | 1.584746 | 8.25652666 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 50.1 | 0.00145 | NR | MCD4744995.1 | 2030927 | g509 | i0 | 31.4 | 1.08253358925144 | 188 | 94 | 97.9 | 8 | 514 | 5 | 288 | 458 | MCD4744995.1 hypothetical protein [Bacteroidales bacterium] | diamond | 564 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 31053744 | 31053744 | PRJNA235310_P_NODE_4215_length_183_cov_1.097015_g4189_i0 | PRJNA235310 | 4215 | 183 | 1.097015 | 2.00753745 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 76.6 | 1.72e-15 | NR | MCX7878859.1 | 2053306 | g4189 | i0 | 62.9 | 7.16393442622951 | 62 | 21 | 98.4 | 1 | 4 | 183 | 69 | 130 | MCX7878859.1 NAD(P)H-dependent oxidoreductase [Ignavibacteria bacterium] | diamond | 1311 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31210953 | 31210953 | PRJNA235310_P_NODE_3035_length_218_cov_1.230769_g3009_i0 | PRJNA235310 | 3035 | 218 | 1.230769 | 2.68307642 | Mesoflavibacter sp. CH_XMU14 | 1930902 | Bacteria | Bacteria | 109 | 2.5e-28 | NR | WP_336065623.1 | 3107766 | g3009 | i0 | 70.4 | 0.977064220183486 | 71 | 21 | 97.7 | 0 | 4 | 216 | 55 | 125 | WP_336065623.1 glycoside hydrolase family 19 protein [Mesoflavibacter sp. CH_XMU1404-2] | diamond | 213 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Mesoflavibacter | Mesoflavibacter sp. CH_XMU1404-2 | |
| 31482533 | 31482533 | PRJNA235310_P_NODE_2016_length_277_cov_1.824561_g1990_i0 | PRJNA235310 | 2016 | 277 | 1.824561 | 5.05403397 | Bacteroidota | 976 | Bacteria | Bacteria | 50.4 | 2.7e-5 | NR | WP_090338004.1 | 408657 | g1990 | i0 | 87 | 7.70036101083033 | 23 | 3 | 24.9 | 0 | 152 | 220 | 33 | 55 | WP_090338004.1 DUF1348 family protein [Dyadobacter koreensis] | diamond | 2133 | 50.8 | 0.992125984251969 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Dyadobacter | Dyadobacter koreensis | |
| 31577237 | 31577237 | PRJNA235310_P_NODE_56_length_1088_cov_4.425409_g44_i0 | PRJNA235310 | 56 | 1088 | 4.425409 | 48.14844992 | Winogradskyella | 286104 | Bacteria | Bacteria | 67.8 | 4.15e-8 | NR | WP_087491296.1 | 754417 | g44 | i0 | 33.7 | 1.09742647058824 | 199 | 97 | 53.2 | 8 | 665 | 87 | 1653 | 1822 | WP_087491296.1 Ig-like domain-containing protein, partial [Winogradskyella sp. PC-19] | diamond | 1194 | 67.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Winogradskyella | Winogradskyella sp. PC-19 | |
| 31717488 | 31717488 | PRJNA235310_P_NODE_2657_length_234_cov_1.686486_g2631_i0 | PRJNA235310 | 2657 | 234 | 1.686486 | 3.94637724 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 43.5 | 0.0173 | NR | HEX3007099.1 | 2030927 | g2631 | i0 | 31.3 | 0.82051282051282 | 64 | 44 | 82.1 | 0 | 206 | 15 | 262 | 325 | HEX3007099.1 right-handed parallel beta-helix repeat-containing protein [Bacteroidales bacterium] | diamond | 192 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 31766832 | 31766832 | PRJNA235310_P_NODE_17_length_1662_cov_8.960942_g11_i0 | PRJNA235310 | 17 | 1662 | 8.960942 | 148.93085604 | Candidatus Opimibacter | 2981997 | Bacteria | Bacteria | 118 | 1.2399999999999999e-23 | NR | HQW25704.1 | 2202734 | g11 | i0 | 40.5 | 1.61913357400722 | 190 | 97 | 32.9 | 7 | 672 | 127 | 833 | 1014 | HQW25704.1 HYR domain-containing protein [Saprospiraceae bacterium] | diamond | 2691 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 31843900 | 31843900 | PRJNA235310_P_NODE_3657_length_197_cov_1.405405_g3631_i0 | PRJNA235310 | 3657 | 197 | 1.405405 | 2.76864785 | uncultured Flavobacterium sp. | 165435 | Bacteria | Bacteria | 43.5 | 0.00579 | NR | WP_288981181.1 | 165435 | g3631 | i0 | 45 | 0.609137055837564 | 40 | 22 | 60.9 | 0 | 120 | 1 | 55 | 94 | WP_288981181.1 hypothetical protein [uncultured Flavobacterium sp.] | diamond | 120 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | uncultured Flavobacterium sp. | |
| 32033897 | 32033897 | PRJNA235310_P_NODE_4338_length_179_cov_2.307692_g4312_i0 | PRJNA235310 | 4338 | 179 | 2.307692 | 4.13076868 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 57.8 | 7.94e-8 | NR | MFN8303924.1 | 2202734 | g4312 | i0 | 59.6 | 1.67597765363128 | 47 | 19 | 78.8 | 0 | 155 | 15 | 692 | 738 | MFN8303924.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium] | diamond | 300 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae 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);;