contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA753151" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2477365 | 2477365 | PRJNA753151_S_NODE_97282_length_286_cov_1.666667_g94992_i0 | PRJNA753151 | 97282 | 286 | 1.666667 | 4.76666762 | Mucilaginibacter | 423349 | Bacteria | Bacteria | 496 | 1.02e-135 | NTclustered | gi|1085785005|emb|LT629740.1| | 652787 | g94992 | i0 | 97.909 | 370.325174825175 | 287 | 4 | 100 | 2 | 1 | 286 | 4557803 | 4558088 | Mucilaginibacter mallensis strain MP1X4 genome assembly, chromosome: I | blastn | 105913 | 496 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter mallensis | |
| 4557880 | 4557880 | PRJNA753151_S_NODE_130244_length_253_cov_2.133333_g127954_i0 | PRJNA753151 | 130244 | 253 | 2.133333 | 5.39733249 | Mucilaginibacter sp. 14171R-50 | 2703789 | Bacteria | Bacteria | 351 | 2.02e-92 | NTclustered | gi|1804505538|gb|CP048115.1| | 2703789 | g127954 | i0 | 92.946 | 354.288537549407 | 241 | 17 | 95 | 0 | 13 | 253 | 720517 | 720757 | Mucilaginibacter sp. 14171R-50 chromosome, complete genome | blastn | 89635 | 351 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sp. 14171R-50 | |
| 13955891 | 13955891 | PRJNA753151_S_NODE_266291_length_172_cov_2.705426_g264001_i0 | PRJNA753151 | 266291 | 172 | 2.705426 | 4.65333272 | Flavobacterium | 237 | Bacteria | Bacteria | 63.9 | 6.66e-6 | NTclustered | gi|2243410383|gb|CP097434.1| | 907046 | g264001 | i0 | 93.023 | 5.68023255813953 | 43 | 3 | 25 | 0 | 35 | 77 | 24576 | 24618 | Flavobacterium sp. B183 chromosome | blastn | 977 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. B183 | |
| 15230393 | 15230393 | PRJNA753151_S_NODE_161892_length_228_cov_3.470270_g159602_i0 | PRJNA753151 | 161892 | 228 | 3.47027 | 7.9122156 | Flavobacterium | 237 | Bacteria | Bacteria | 422 | 1.34e-113 | NTclustered | gi|1993663771|gb|CP068294.1| | 2724135 | g159602 | i0 | 100 | 536.118421052632 | 228 | 0 | 100 | 0 | 1 | 228 | 807376 | 807603 | Flavobacterium sp. CLA17 chromosome | blastn | 122235 | 422 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. CLA17 | |
| 17308561 | 17308561 | PRJNA753151_S_NODE_299614_length_160_cov_1.538462_g297324_i0 | PRJNA753151 | 299614 | 160 | 1.538462 | 2.4615392 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 143 | 7.649999999999998e-30 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g297324 | i0 | 82.927 | 129.8625 | 164 | 22 | 100 | 5 | 1 | 160 | 171767 | 171606 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 20778 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 21133270 | 21133270 | PRJNA753151_S_NODE_55737_length_349_cov_10.921569_g53447_i0 | PRJNA753151 | 55737 | 349 | 10.921569 | 38.11627581 | uncultured Draconibacterium sp. | 1573823 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|2621784655|emb|OY781113.1| | 1573823 | g53447 | i0 | 100 | 0.0802292263610315 | 28 | 0 | 8 | 0 | 310 | 337 | 425133 | 425106 | MAG: uncultured Draconibacterium sp. isolate abe71d63-47d4-46f6-900f-15657cc07270 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Prolixibacteraceae | Draconibacterium | uncultured Draconibacterium sp. | |
| 22879462 | 22879462 | PRJNA753151_S_NODE_210658_length_198_cov_3.483871_g208368_i0 | PRJNA753151 | 210658 | 198 | 3.483871 | 6.89806458 | Phocaeicola | 909656 | Bacteria | Bacteria | 366 | 5.4e-97 | NTclustered | gi|2290438071|gb|CP103067.1| | 821 | g208368 | i0 | 100 | 343.651515151515 | 198 | 0 | 100 | 0 | 1 | 198 | 320284 | 320481 | Phocaeicola vulgatus strain BFG-626 chromosome, complete genome | blastn | 68043 | 366 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola vulgatus |
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);;