contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 839835 | 839835 | PRJNA853194_S_NODE_16701_length_482_cov_1.748166_g15612_i0 | PRJNA853194 | 16701 | 482 | 1.748166 | 8.42616012 | Chryseobacterium sp. E1 | 2853434 | Bacteria | Bacteria | 52.8 | 0.047 | NTclustered | gi|2065946897|gb|CP078104.1| | 2853434 | g15612 | i0 | 100 | 0.0580912863070539 | 28 | 0 | 6 | 0 | 156 | 183 | 502633 | 502660 | Chryseobacterium sp. E1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. E1 | |
| 840875 | 840875 | PRJNA853194_S_NODE_66841_length_268_cov_4.615385_g65750_i0 | PRJNA853194 | 66841 | 268 | 4.615385 | 12.3692318 | Candidatus Shikimatogenerans bostrichidophilus | 2943807 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2618221508|gb|CP104096.1| | 2943807 | g65750 | i0 | 96.875 | 0.119402985074627 | 32 | 0 | 12 | 1 | 87 | 117 | 32111 | 32142 | Candidatus Shikimatogenerans bostrichidophilus isolate Strain C chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Candidatus Shikimatogenerans | Candidatus Shikimatogenerans bostrichidophilus | ||
| 3391898 | 3391898 | PRJNA853194_S_NODE_84263_length_242_cov_1.508876_g83172_i0 | PRJNA853194 | 84263 | 242 | 1.508876 | 3.65147992 | Lutibacter sp. A64 | 2918526 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2201049089|gb|CP092487.1| | 2918526 | g83172 | i0 | 100 | 0.119834710743802 | 29 | 0 | 12 | 0 | 14 | 42 | 1098306 | 1098278 | Lutibacter sp. A64 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Lutibacter | Lutibacter sp. A64 | |
| 4668781 | 4668781 | PRJNA853194_S_NODE_39384_length_341_cov_1.585821_g38293_i0 | PRJNA853194 | 39384 | 341 | 1.585821 | 5.40764961 | Seonamhaeicola sp. ML3 | 2937786 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2235330891|gb|CP096884.1| | 2937786 | g38293 | i0 | 100 | 0.0879765395894428 | 30 | 0 | 9 | 0 | 185 | 214 | 61485 | 61514 | Seonamhaeicola sp. ML3 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Seonamhaeicola | Seonamhaeicola sp. ML3 | |
| 4669152 | 4669152 | PRJNA853194_S_NODE_58604_length_286_cov_1.061033_g57513_i0 | PRJNA853194 | 58604 | 286 | 1.061033 | 3.03455438 | Polaribacter dokdonensis | 326329 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2274417251|gb|CP101505.1| | 326329 | g57513 | i0 | 100 | 0.0979020979020979 | 28 | 0 | 10 | 0 | 185 | 212 | 326452 | 326479 | Polaribacter dokdonensis strain KCTC 12392 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Polaribacter | Polaribacter dokdonensis | |
| 5943072 | 5943072 | PRJNA853194_S_NODE_18245_length_464_cov_2.335038_g17155_i0 | PRJNA853194 | 18245 | 464 | 2.335038 | 10.83457632 | Bacteroides nordii | 291645 | Bacteria | Bacteria | 52.8 | 0.045 | NTclustered | gi|2093932526|gb|CP082886.1| | 291645 | g17155 | i0 | 100 | 0.0603448275862069 | 28 | 0 | 6 | 0 | 164 | 191 | 2119774 | 2119747 | Bacteroides nordii strain FDAARGOS_1461 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides nordii | |
| 5944081 | 5944081 | PRJNA853194_S_NODE_67185_length_268_cov_1.184615_g66094_i0 | PRJNA853194 | 67185 | 268 | 1.184615 | 3.1747682 | Salegentibacter sp. T436 | 1729720 | Bacteria | Bacteria | 444 | 3.46e-120 | NTclustered | gi|1127561907|gb|CP012872.1| | 1729720 | g66094 | i0 | 96.642 | 3.63432835820896 | 268 | 8 | 100 | 1 | 1 | 268 | 3346123 | 3346389 | Salegentibacter sp. T436 chromosome, complete genome | blastn | 974 | 444 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Salegentibacter | Salegentibacter sp. T436 | |
| 7218718 | 7218718 | PRJNA853194_S_NODE_51806_length_302_cov_2.449782_g50715_i0 | PRJNA853194 | 51806 | 302 | 2.449782 | 7.39834164 | Flavobacterium sp. CS20 | 2775246 | Bacteria | Bacteria | 52.8 | 0.028 | NTclustered | gi|2027300824|gb|CP073015.1| | 2775246 | g50715 | i0 | 96.875 | 0.105960264900662 | 32 | 0 | 10 | 1 | 193 | 223 | 770431 | 770400 | Flavobacterium sp. CS20 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. CS20 | |
| 8887516 | 8887516 | PRJNA853194_S_NODE_39967_length_339_cov_1.218045_g38876_i0 | PRJNA853194 | 39967 | 339 | 1.218045 | 4.12917255 | Flavobacterium | 237 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|1735479352|gb|CP031763.1| | 986 | g38876 | i0 | 100 | 0.595870206489675 | 29 | 0 | 9 | 0 | 64 | 92 | 5131337 | 5131365 | Flavobacterium johnsoniae strain FJ001 chromosome | blastn | 202 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium johnsoniae | |
| 9767939 | 9767939 | PRJNA853194_S_NODE_18968_length_457_cov_3.960938_g17878_i0 | PRJNA853194 | 18968 | 457 | 3.960938 | 18.10148666 | Prevotella jejuni | 1177574 | Bacteria | Bacteria | 52.8 | 0.044 | NTclustered | gi|2028869951|gb|CP072363.1| | 1177574 | g17878 | i0 | 100 | 0.12253829321663 | 28 | 0 | 6 | 0 | 25 | 52 | 882638 | 882665 | Prevotella jejuni strain F0697 chromosome 1, complete sequence | blastn | 56 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella jejuni | |
| 9768820 | 9768820 | PRJNA853194_S_NODE_60948_length_281_cov_1.000000_g59857_i0 | PRJNA853194 | 60948 | 281 | 1 | 2.81 | uncultured Bacteroidales bacterium | 194843 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2874253951|emb|OY970276.1| | 194843 | g59857 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 7 | 34 | 4538478 | 4538451 | MAG: uncultured Bacteroidales bacterium isolate MFD06435.bin.1.129 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | uncultured Bacteroidales bacterium | |||
| 9768965 | 9768965 | PRJNA853194_S_NODE_69048_length_264_cov_1.958115_g67957_i0 | PRJNA853194 | 69048 | 264 | 1.958115 | 5.1694236 | Candidatus Shikimatogenerans sp. AspAUS03 | 3158563 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2859865218|gb|CP157897.2| | 3158563 | g67957 | i0 | 94.595 | 0.140151515151515 | 37 | 1 | 14 | 1 | 229 | 264 | 58922 | 58886 | MAG: Candidatus Shikimatogenerans sp. AspAUS03 chromosome | blastn | 37 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Candidatus Shikimatogenerans | Candidatus Shikimatogenerans sp. AspAUS03 | ||
| 11044070 | 11044070 | PRJNA853194_S_NODE_4229_length_858_cov_59.298089_g3458_i0 | PRJNA853194 | 4229 | 858 | 59.298089 | 508.77760362 | Candidatus Karelsulcia muelleri | 336810 | Bacteria | Bacteria | 62.1 | 1.44e-4 | NTclustered | gi|2717309477|emb|OZ032149.1| | 336810 | g3458 | i0 | 97.222 | 0.041958041958042 | 36 | 1 | 4 | 0 | 677 | 712 | 226088 | 226053 | Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1 | blastn | 36 | 62.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Candidatus Karelsulcia | Candidatus Karelsulcia muelleri | ||
| 12319850 | 12319850 | PRJNA853194_S_NODE_52310_length_301_cov_1.539474_g51219_i0 | PRJNA853194 | 52310 | 301 | 1.539474 | 4.63381674 | Flavobacteriaceae bacterium | 1871037 | Bacteria | Bacteria | 52.8 | 0.028 | NTclustered | gi|1885860246|gb|CP046177.1| | 1871037 | g51219 | i0 | 100 | 0.186046511627907 | 28 | 0 | 9 | 0 | 43 | 70 | 3230728 | 3230755 | Flavobacteriaceae bacterium isolate MH-Pat-all_autometa_1-8 chromosome | blastn | 56 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 12319898 | 12319898 | PRJNA853194_S_NODE_55070_length_294_cov_1.325792_g53979_i0 | PRJNA853194 | 55070 | 294 | 1.325792 | 3.89782848 | Flavobacterium dauae | 1563479 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2557430891|gb|CP130821.1| | 1563479 | g53979 | i0 | 100 | 0.102040816326531 | 30 | 0 | 10 | 0 | 40 | 69 | 1161438 | 1161409 | Flavobacterium dauae strain TCH3-2 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium dauae | |
| 13594459 | 13594459 | PRJNA853194_S_NODE_58371_length_286_cov_1.896714_g57280_i0 | PRJNA853194 | 58371 | 286 | 1.896714 | 5.42460204 | Pontimicrobium sp. IMCC45349 | 3391574 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2894497685|gb|CP178208.1| | 3391574 | g57280 | i0 | 100 | 0.0979020979020979 | 28 | 0 | 10 | 0 | 255 | 282 | 902600 | 902573 | Pontimicrobium sp. IMCC45349 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Pontimicrobium | Pontimicrobium sp. IMCC45349 | |
| 14868726 | 14868726 | PRJNA853194_S_NODE_60812_length_281_cov_1.389423_g59721_i0 | PRJNA853194 | 60812 | 281 | 1.389423 | 3.90427863 | uncultured Chitinophagaceae bacterium | 866510 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2874253850|emb|OY969906.1| | 866510 | g59721 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 77 | 104 | 3609171 | 3609144 | MAG: uncultured Chitinophagaceae bacterium isolate MFD05502.bin.c.1 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | uncultured Chitinophagaceae bacterium | ||
| 18691511 | 18691511 | PRJNA853194_S_NODE_3235_length_962_cov_3.363330_g2564_i0 | PRJNA853194 | 3235 | 962 | 3.36333 | 32.3552346 | Chryseobacterium gambrini | 373672 | Bacteria | Bacteria | 54.7 | 0.027 | NTclustered | gi|2429070341|gb|CP115857.1| | 373672 | g2564 | i0 | 96.875 | 0.0665280665280665 | 32 | 1 | 3 | 0 | 751 | 782 | 2931749 | 2931780 | Chryseobacterium gambrini strain PL22-1A chromosome, complete genome | blastn | 64 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium gambrini | |
| 18691529 | 18691529 | PRJNA853194_S_NODE_33275_length_365_cov_5.287671_g32184_i0 | PRJNA853194 | 33275 | 365 | 5.287671 | 19.29999915 | Flavobacterium eburneipallidum | 3003263 | Bacteria | Bacteria | 54.7 | 0.01 | NTclustered | gi|2493280413|gb|CP114291.2| | 3003263 | g32184 | i0 | 100 | 0.30958904109589 | 29 | 0 | 8 | 0 | 336 | 364 | 1836619 | 1836591 | Flavobacterium eburneipallidum strain IMCC36793 chromosome, complete genome | blastn | 113 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium eburneipallidum | |
| 21242430 | 21242430 | PRJNA853194_S_NODE_41937_length_332_cov_1.691120_g40846_i0 | PRJNA853194 | 41937 | 332 | 1.69112 | 5.6145184 | Flavobacterium sp. CECT 9288 | 2845819 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|2152726014|emb|OU957226.1| | 2845819 | g40846 | i0 | 100 | 0.0873493975903614 | 29 | 0 | 9 | 0 | 43 | 71 | 2178900 | 2178928 | Flavobacterium sp. CECT 9288 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. CECT 9288 | |
| 22516958 | 22516958 | PRJNA853194_S_NODE_34398_length_360_cov_21.087108_g33307_i0 | PRJNA853194 | 34398 | 360 | 21.087108 | 75.9135888 | Thermoflavifilum sp. | 1968839 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|1919310413|gb|CP063141.1| | 1968839 | g33307 | i0 | 97.059 | 0.638888888888889 | 34 | 0 | 9 | 1 | 156 | 188 | 302605 | 302638 | Thermoflavifilum sp. isolate Bu77 chromosome | blastn | 230 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Thermoflavifilum | Thermoflavifilum sp. | |
| 22517402 | 22517402 | PRJNA853194_S_NODE_56638_length_290_cov_2.092166_g55547_i0 | PRJNA853194 | 56638 | 290 | 2.092166 | 6.0672814 | Christiangramia fulva | 2126553 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|1371467338|gb|CP028136.1| | 2126553 | g55547 | i0 | 94.286 | 0.120689655172414 | 35 | 1 | 12 | 1 | 67 | 101 | 3097217 | 3097184 | Christiangramia fulva strain SH35 chromosome, complete genome | blastn | 35 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Christiangramia | Christiangramia fulva |
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);;