contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA513467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26792420 | 26792420 | PRJNA513467_S_NODE_781_length_367_cov_1.730303_g758_i0 | PRJNA513467 | 781 | 367 | 1.730303 | 6.35021201 | Sphingobacterium allocomposti | 415956 | Bacteria | Bacteria | 192 | 1.44e-59 | NR | WP_148907411.1 | 415956 | g758 | i0 | 100 | 0.768392370572207 | 94 | 0 | 76.8 | 0 | 3 | 284 | 101 | 194 | WP_148907411.1 DUF4290 domain-containing protein [Sphingobacterium allocomposti] | diamond | 282 | 192 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium allocomposti | |
| 27503548 | 27503548 | PRJNA513467_S_NODE_7303_length_158_cov_1.190083_g7280_i0 | PRJNA513467 | 7303 | 158 | 1.190083 | 1.88033114 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 71.2 | 1.02e-12 | NR | WP_277479552.1 | 1075417 | g7280 | i0 | 64.3 | 7.84177215189873 | 42 | 15 | 79.7 | 0 | 156 | 31 | 455 | 496 | WP_277479552.1 FAD-dependent oxidoreductase [Catalinimonas alkaloidigena] | diamond | 1239 | 71.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Catalimonadaceae | Catalinimonas | Catalinimonas alkaloidigena | |
| 27709428 | 27709428 | PRJNA513467_S_NODE_1964_length_254_cov_3.133641_g1941_i0 | PRJNA513467 | 1964 | 254 | 3.133641 | 7.95944814 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 138 | 1.65e-36 | NR | HQQ97914.1 | 2099675 | g1941 | i0 | 77.4 | 1.98425196850394 | 84 | 19 | 99.2 | 0 | 252 | 1 | 212 | 295 | HQQ97914.1 polysaccharide biosynthesis C-terminal domain-containing protein [Cyclobacteriaceae bacterium] | diamond | 504 | 138 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 27835124 | 27835124 | PRJNA513467_S_NODE_4464_length_188_cov_1.655629_g4441_i0 | PRJNA513467 | 4464 | 188 | 1.655629 | 3.11258252 | Chitinophagales bacterium | 2448779 | Bacteria | Bacteria | 56.6 | 1.85e-7 | NR | MBL7788765.1 | 2448779 | g4441 | i0 | 57.8 | 0.718085106382979 | 45 | 19 | 71.8 | 0 | 186 | 52 | 179 | 223 | MBL7788765.1 tetratricopeptide repeat protein [Chitinophagales bacterium] | diamond | 135 | 56.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagales bacterium | |||
| 28229314 | 28229314 | PRJNA513467_S_NODE_5206_length_178_cov_1.659574_g5183_i0 | PRJNA513467 | 5206 | 178 | 1.659574 | 2.95404172 | Paludibacter | 346096 | Bacteria | Bacteria | 86.3 | 9.86e-20 | NR | MEI6556078.1 | 1898105 | g5183 | i0 | 86 | 2.8988764044943802 | 43 | 6 | 72.5 | 0 | 130 | 2 | 1 | 43 | MEI6556078.1 hypothetical protein [Paludibacter sp.] | diamond | 516 | 86.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Paludibacteraceae | Paludibacter | Paludibacter sp. | |
| 28403597 | 28403597 | PRJNA513467_S_NODE_4146_length_193_cov_1.500000_g4123_i0 | PRJNA513467 | 4146 | 193 | 1.5 | 2.895 | Sphingobacterium allocomposti | 415956 | Bacteria | Bacteria | 57.8 | 8.82e-8 | NR | WP_148909915.1 | 415956 | g4123 | i0 | 100 | 0.450777202072539 | 29 | 0 | 45.1 | 0 | 191 | 105 | 325 | 353 | WP_148909915.1 Mrp/NBP35 family ATP-binding protein [Sphingobacterium allocomposti] | diamond | 87 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium allocomposti | |
| 29255872 | 29255872 | PRJNA513467_S_NODE_2049_length_250_cov_2.774648_g2026_i0 | PRJNA513467 | 2049 | 250 | 2.774648 | 6.93662 | Chryseobacterium sp. VAUSW3 | 2010998 | Bacteria | Bacteria | 165 | 2.9199999999999998e-46 | NR | OWR14901.1 | 2010998 | g2026 | i0 | 96.3 | 0.984 | 82 | 3 | 98.4 | 0 | 3 | 248 | 60 | 141 | OWR14901.1 hypothetical protein CDW55_00205 [Chryseobacterium sp. VAUSW3] | diamond | 246 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. VAUSW3 | |
| 29776567 | 29776567 | PRJNA513467_S_NODE_5531_length_174_cov_2.145985_g5508_i0 | PRJNA513467 | 5531 | 174 | 2.145985 | 3.7340139 | Prevotella | 838 | Bacteria | Bacteria | 113 | 4.239999999999999e-31 | NR | MBO5314386.1 | 59823 | g5508 | i0 | 96.6 | 2 | 58 | 2 | 100 | 0 | 174 | 1 | 14 | 71 | MBO5314386.1 50S ribosomal protein L23 [Prevotella sp.] | diamond | 348 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. | |
| 29856028 | 29856028 | PRJNA513467_S_NODE_4851_length_183_cov_1.267123_g4828_i0 | PRJNA513467 | 4851 | 183 | 1.267123 | 2.31883509 | Sphingobacterium allocomposti | 415956 | Bacteria | Bacteria | 126 | 5.559999999999999e-32 | NR | WP_148910241.1 | 415956 | g4828 | i0 | 100 | 1 | 61 | 0 | 100 | 0 | 1 | 183 | 154 | 214 | WP_148910241.1 KUP/HAK/KT family potassium transporter [Sphingobacterium allocomposti] | diamond | 183 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium allocomposti | |
| 30550974 | 30550974 | PRJNA513467_S_NODE_7173_length_159_cov_1.139344_g7150_i0 | PRJNA513467 | 7173 | 159 | 1.139344 | 1.81155696 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 42.4 | 0.0171 | NR | MES2382405.1 | 1898104 | g7150 | i0 | 47.8 | 0.867924528301887 | 46 | 24 | 86.8 | 0 | 22 | 159 | 243 | 288 | MES2382405.1 hypothetical protein [Bacteroidota bacterium] | diamond | 138 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 32669266 | 32669266 | PRJNA513467_S_NODE_8380_length_150_cov_2.212389_g8357_i0 | PRJNA513467 | 8380 | 150 | 2.212389 | 3.3185835 | Sphingobacteriia bacterium | 2035813 | Bacteria | Bacteria | 75.1 | 2.44e-14 | NR | MCE1167990.1 | 2035813 | g8357 | i0 | 72.9 | 0.96 | 48 | 13 | 96 | 0 | 149 | 6 | 269 | 316 | MCE1167990.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Sphingobacteriia bacterium] | diamond | 144 | 75.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriia 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);;