contig_metadata
15 rows where bioproject = "PRJNA448207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8091996 | 8091996 | PRJNA448207_P_NODE_30447_length_245_cov_0.877907_g30284_i0 | PRJNA448207 | 30447 | 245 | 0.877907 | 2.15087215 | Aquirufa nivalisilvae | 2516557 | Bacteria | Bacteria | 361 | 3.2399999999999996e-95 | NTclustered | gi|1390254249|gb|CP029346.1| | 2516557 | g30284 | i0 | 93.145 | 322.555102040816 | 248 | 14 | 100 | 2 | 1 | 245 | 360717 | 360964 | Aquirufa nivalisilvae strain HME7025 chromosome, complete genome | blastn | 79026 | 361 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Aquirufa | Aquirufa nivalisilvae | |
| 9366794 | 9366794 | PRJNA448207_P_NODE_33408_length_241_cov_0.916667_g33245_i0 | PRJNA448207 | 33408 | 241 | 0.916667 | 2.20916747 | Prevotella sp. oral taxon 299 | 652716 | Bacteria | Bacteria | 329 | 8.95e-86 | NTclustered | gi|532126075|gb|CP003667.1| | 575614 | g33245 | i0 | 91.286 | 244.207468879668 | 241 | 21 | 100 | 0 | 1 | 241 | 1523749 | 1523509 | Prevotella sp. oral taxon 299 str. F0039 plasmid, complete sequence | blastn | 58854 | 329 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. oral taxon 299 | |
| 10642377 | 10642377 | PRJNA448207_P_NODE_11649_length_365_cov_1.455479_g11487_i0 | PRJNA448207 | 11649 | 365 | 1.455479 | 5.31249835 | Aquirufa lenticrescens | 2696560 | Bacteria | Bacteria | 374 | 6.509999999999998e-99 | NTclustered | gi|2091518249|gb|CP049834.1| | 2696560 | g11487 | i0 | 85.366 | 57.5178082191781 | 369 | 44 | 100 | 8 | 1 | 365 | 217703 | 217341 | Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome | blastn | 20994 | 374 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Aquirufa | Aquirufa lenticrescens | |
| 13192377 | 13192377 | PRJNA448207_P_NODE_29931_length_245_cov_0.895349_g29768_i0 | PRJNA448207 | 29931 | 245 | 0.895349 | 2.19360505 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 182 | 2.7e-41 | NTclustered | gi|1869340971|gb|CP058703.1| | 2099675 | g29768 | i0 | 80.478 | 255.265306122449 | 251 | 38 | 100 | 9 | 1 | 245 | 2013176 | 2013421 | MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome | blastn | 62540 | 182 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 13192550 | 13192550 | PRJNA448207_S_NODE_1631_length_342_cov_1.486989_g1620_i0 | PRJNA448207 | 1631 | 342 | 1.486989 | 5.08550238 | Vaginella massiliensis | 1816680 | Bacteria | Bacteria | 62.1 | 5.37e-5 | NTclustered | gi|2831277486|gb|CP171010.1| | 1816680 | g1620 | i0 | 86.207 | 0.169590643274854 | 58 | 6 | 17 | 2 | 1 | 57 | 1289943 | 1289887 | Vaginella massiliensis strain WGS2087 chromosome, complete genome | blastn | 58 | 62.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Vaginella | Vaginella massiliensis | |
| 13845812 | 13845812 | PRJNA448207_P_NODE_22871_length_268_cov_1.117949_g22708_i0 | PRJNA448207 | 22871 | 268 | 1.117949 | 2.99610332 | Cytophagales | 768507 | Bacteria | Bacteria | 265 | 2.9e-66 | NTclustered | gi|2581931629|dbj|AP025313.1| | 866807 | g22708 | i0 | 86.885 | 213.018656716418 | 244 | 23 | 89 | 9 | 21 | 259 | 5796 | 6035 | Aureibacter tunicatorum NBRC 107587 plasmid pATrrn DNA, complete genome | blastn | 57089 | 267 | 0.99250936329588 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Persicobacteraceae | Aureibacter | Aureibacter tunicatorum | |
| 17016240 | 17016240 | PRJNA448207_P_NODE_6334_length_480_cov_1.378378_g6172_i0 | PRJNA448207 | 6334 | 480 | 1.378378 | 6.6162144 | Aquirufa lenticrescens | 2696560 | Bacteria | Bacteria | 676 | 0 | NTclustered | gi|2091518249|gb|CP049834.1| | 2696560 | g6172 | i0 | 92.083 | 300.395833333333 | 480 | 38 | 100 | 0 | 1 | 480 | 216826 | 217305 | Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome | blastn | 144190 | 676 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Aquirufa | Aquirufa lenticrescens | |
| 27455470 | 27455470 | PRJNA448207_P_NODE_27063_length_249_cov_0.875000_g26900_i0 | PRJNA448207 | 27063 | 249 | 0.875 | 2.17875 | Candidatus Pullibacteroides excrementavium | 2840905 | Bacteria | Bacteria | 42.7 | 0.0402 | NR | MBO8433670.1 | 2840905 | g26900 | i0 | 33.9 | 0.746987951807229 | 62 | 37 | 69.9 | 1 | 188 | 15 | 543 | 604 | MBO8433670.1 fibronectin type III domain-containing protein [Candidatus Pullibacteroides excrementavium] | diamond | 186 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Candidatus Pullibacteroides | Candidatus Pullibacteroides excrementavium | ||
| 28939389 | 28939389 | PRJNA448207_S_NODE_3488_length_250_cov_0.864407_g3477_i0 | PRJNA448207 | 3488 | 250 | 0.864407 | 2.1610175 | Porphyromonas gingivalis F | 837 | Bacteria | Bacteria | 59.7 | 8.01e-10 | NR | ERJ68952.1 | 1227271 | g3477 | i0 | 96.2 | 0.312 | 26 | 1 | 31.2 | 0 | 80 | 3 | 10 | 35 | ERJ68952.1 hypothetical protein HMPREF1555_00132 [Porphyromonas gingivalis F0570] | diamond | 78 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas gingivalis | |
| 29065669 | 29065669 | PRJNA448207_P_NODE_28448_length_247_cov_0.885057_g28285_i0 | PRJNA448207 | 28448 | 247 | 0.885057 | 2.18609079 | Tannerella sp. | 2382127 | Bacteria | Bacteria | 53.1 | 2.31e-6 | NR | MDR1224070.1 | 2382127 | g28285 | i0 | 35.2 | 0.862348178137652 | 71 | 44 | 83.8 | 1 | 243 | 37 | 71 | 141 | MDR1224070.1 hypothetical protein [Tannerella sp.] | diamond | 213 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Tannerellaceae | Tannerella | Tannerella sp. | |
| 30013003 | 30013003 | PRJNA448207_P_NODE_28591_length_247_cov_0.885057_g28428_i0 | PRJNA448207 | 28591 | 247 | 0.885057 | 2.18609079 | Porphyromonas sp. | 1924944 | Bacteria | Bacteria | 114 | 2.61e-31 | NR | WP_414477854.1 | 1924944 | g28428 | i0 | 98.3 | 3.582995951417 | 59 | 1 | 71.7 | 0 | 247 | 71 | 24 | 82 | WP_414477854.1 transposase, partial [Porphyromonas sp.] | diamond | 885 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. | |
| 30329340 | 30329340 | PRJNA448207_P_NODE_13292_length_346_cov_0.849817_g13129_i0 | PRJNA448207 | 13292 | 346 | 0.849817 | 2.94036682 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 47.4 | 0.00283 | NR | HKU63407.1 | 2448054 | g13129 | i0 | 36.1 | 0.936416184971098 | 108 | 55 | 85 | 6 | 25 | 318 | 66 | 169 | HKU63407.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 324 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30455553 | 30455553 | PRJNA448207_P_NODE_26193_length_250_cov_0.870056_g26030_i0 | PRJNA448207 | 26193 | 250 | 0.870056 | 2.17514 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 41.6 | 0.0346 | NR | MCH8276136.1 | 1898104 | g26030 | i0 | 42.4 | 0.396 | 33 | 19 | 39.6 | 0 | 3 | 101 | 9 | 41 | MCH8276136.1 hypothetical protein [Bacteroidota bacterium] | diamond | 99 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 31466700 | 31466700 | PRJNA448207_P_NODE_17796_length_304_cov_1.961039_g17633_i0 | PRJNA448207 | 17796 | 304 | 1.961039 | 5.96155856 | Hymenobacter sp. | 1898978 | Bacteria | Bacteria | 42 | 0.0174 | NR | MDB5234348.1 | 1898978 | g17633 | i0 | 40 | 0.592105263157895 | 60 | 35 | 58.2 | 1 | 235 | 59 | 7 | 66 | MDB5234348.1 transcription-repair coupling factor [Hymenobacter sp.] | diamond | 180 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter sp. | |
| 31845972 | 31845972 | PRJNA448207_P_NODE_27137_length_249_cov_0.875000_g26974_i0 | PRJNA448207 | 27137 | 249 | 0.875 | 2.17875 | Flavobacterium soli | 344881 | Bacteria | Bacteria | 166 | 1.43e-50 | NR | WP_026704786.1 | 344881 | g26974 | i0 | 92.8 | 1 | 83 | 6 | 100 | 0 | 249 | 1 | 20 | 102 | WP_026704786.1 class I SAM-dependent methyltransferase [Flavobacterium soli] | diamond | 249 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium soli |
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);;