contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA371613" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2950183 | 2950183 | PRJNA371613_P_NODE_7223_length_172_cov_0.948148_g7047_i0 | PRJNA371613 | 7223 | 172 | 0.948148 | 1.63081456 | Telluribacter sp. | 1978767 | Bacteria | Bacteria | 95.9 | 3.19e-22 | NR | WP_327486675.1 | 1978767 | g7047 | i0 | 85.7 | 1.93604651162791 | 56 | 8 | 97.7 | 0 | 170 | 3 | 33 | 88 | WP_327486675.1 SDR family oxidoreductase [Telluribacter sp.] | diamond | 333 | 95.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Telluribacter | Telluribacter sp. | |
| 4226716 | 4226716 | PRJNA371613_P_NODE_7024_length_173_cov_0.941176_g6848_i0 | PRJNA371613 | 7024 | 173 | 0.941176 | 1.62823448 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 125 | 1.23e-34 | NR | MDE3142738.1 | 1898104 | g6848 | i0 | 98.2 | 2.96531791907514 | 57 | 1 | 98.8 | 0 | 1 | 171 | 27 | 83 | MDE3142738.1 RNA methyltransferase [Bacteroidota bacterium] | diamond | 513 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 23351536 | 23351536 | PRJNA371613_P_NODE_5859_length_191_cov_2.493506_g5683_i0 | PRJNA371613 | 5859 | 191 | 2.493506 | 4.76259646 | Epilithonimonas hominis | 420404 | Bacteria | Bacteria | 117 | 9.85e-32 | NR | WP_260255216.1 | 420404 | g5683 | i0 | 96.8 | 2.96858638743455 | 63 | 2 | 99 | 0 | 1 | 189 | 65 | 127 | WP_260255216.1 VanZ family protein [Epilithonimonas hominis] | diamond | 567 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Epilithonimonas | Epilithonimonas hominis | |
| 26853590 | 26853590 | PRJNA371613_P_NODE_9381_length_157_cov_2.133333_g9205_i0 | PRJNA371613 | 9381 | 157 | 2.133333 | 3.34933281 | Pedobacter sp. UYP1 | 1756396 | Bacteria | Bacteria | 102 | 2e-24 | NR | WP_354298963.1 | 1756396 | g9205 | i0 | 98.1 | 0.993630573248408 | 52 | 1 | 99.4 | 0 | 1 | 156 | 175 | 226 | WP_354298963.1 DUF4236 domain-containing protein [Pedobacter sp. UYP1] | diamond | 156 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. UYP1 | |
| 26979894 | 26979894 | PRJNA371613_P_NODE_7382_length_171_cov_0.955224_g7206_i0 | PRJNA371613 | 7382 | 171 | 0.955224 | 1.63343304 | Porphyromonas somerae | 322095 | Bacteria | Bacteria | 118 | 1.62e-30 | NR | WP_304292997.1 | 322095 | g7206 | i0 | 100 | 0.982456140350877 | 56 | 0 | 98.2 | 0 | 2 | 169 | 249 | 304 | WP_304292997.1 hypothetical protein [Porphyromonas somerae] | diamond | 168 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas somerae | |
| 27345052 | 27345052 | PRJNA371613_P_NODE_8783_length_164_cov_1.007874_g8607_i0 | PRJNA371613 | 8783 | 164 | 1.007874 | 1.65291336 | Bacteroidota | 976 | Bacteria | Bacteria | 107 | 2.8399999999999998e-25 | NR | WP_313239148.1 | 28454 | g8607 | i0 | 87 | 65.1951219512195 | 54 | 7 | 98.8 | 0 | 2 | 163 | 282 | 335 | WP_313239148.1 conjugal transfer protein MobC [Sphingobacterium multivorum] | diamond | 10692 | 108 | 0.990740740740741 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium multivorum | |
| 27643752 | 27643752 | PRJNA371613_P_NODE_4904_length_217_cov_1.066667_g4728_i0 | PRJNA371613 | 4904 | 217 | 1.066667 | 2.31466739 | uncultured Persicobacter sp. | 511771 | Bacteria | Bacteria | 48.9 | 1.72e-4 | NR | WP_332920909.1 | 511771 | g4728 | i0 | 44.6 | 0.898617511520737 | 65 | 34 | 87.1 | 1 | 217 | 29 | 268 | 332 | WP_332920909.1 hypothetical protein [uncultured Persicobacter sp.] | diamond | 195 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Persicobacteraceae | Persicobacter | uncultured Persicobacter sp. | |
| 28607863 | 28607863 | PRJNA371613_P_NODE_7387_length_171_cov_0.955224_g7211_i0 | PRJNA371613 | 7387 | 171 | 0.955224 | 1.63343304 | Weeksellaceae | 2762318 | Bacteria | Bacteria | 84.7 | 4.28e-18 | NR | WP_416402847.1 | 343874 | g7211 | i0 | 69.6 | 2.94736842105263 | 56 | 17 | 98.2 | 0 | 170 | 3 | 124 | 179 | WP_416402847.1 hypothetical protein [Empedobacter falsenii] | diamond | 504 | 85.1 | 0.995299647473561 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Empedobacter | Empedobacter falsenii | |
| 29159288 | 29159288 | PRJNA371613_P_NODE_7949_length_168_cov_0.977099_g7773_i0 | PRJNA371613 | 7949 | 168 | 0.977099 | 1.64152632 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 120 | 1.1e-31 | NR | MDO5075529.1 | 2030927 | g7773 | i0 | 100 | 0.982142857142857 | 55 | 0 | 98.2 | 0 | 166 | 2 | 179 | 233 | MDO5075529.1 glycerol acyltransferase [Bacteroidales bacterium] | diamond | 165 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 30296514 | 30296514 | PRJNA371613_P_NODE_7332_length_171_cov_0.955224_g7156_i0 | PRJNA371613 | 7332 | 171 | 0.955224 | 1.63343304 | Pedobacter cryoconitis | 188932 | Bacteria | Bacteria | 105 | 1.0999999999999998e-24 | NR | WP_183892354.1 | 188932 | g7156 | i0 | 89.3 | 1.96491228070175 | 56 | 6 | 98.2 | 0 | 3 | 170 | 1402 | 1457 | WP_183892354.1 gliding motility-associated C-terminal domain-containing protein, partial [Pedobacter cryoconitis] | diamond | 336 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter cryoconitis | |
| 30517215 | 30517215 | PRJNA371613_P_NODE_6553_length_179_cov_1.802817_g6377_i0 | PRJNA371613 | 6553 | 179 | 1.802817 | 3.22704243 | Mucilaginibacter sp. 21P | 2778902 | Bacteria | Bacteria | 46.6 | 6.82e-4 | NR | WP_219124083.1 | 2778902 | g6377 | i0 | 45.5 | 0.737430167597765 | 44 | 24 | 73.7 | 0 | 5 | 136 | 241 | 284 | WP_219124083.1 hypothetical protein [Mucilaginibacter sp. 21P] | diamond | 132 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sp. 21P | |
| 30801466 | 30801466 | PRJNA371613_P_NODE_8834_length_164_cov_1.007874_g8658_i0 | PRJNA371613 | 8834 | 164 | 1.007874 | 1.65291336 | Puia sp. | 2045100 | Bacteria | Bacteria | 60.5 | 4.74e-9 | NR | HWK03525.1 | 2045100 | g8658 | i0 | 71.1 | 0.695121951219512 | 38 | 11 | 69.5 | 0 | 50 | 163 | 1 | 38 | HWK03525.1 SagB/ThcOx family dehydrogenase [Puia sp.] | diamond | 114 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Puia | Puia sp. | |
| 30991262 | 30991262 | PRJNA371613_P_NODE_8634_length_165_cov_1.000000_g8458_i0 | PRJNA371613 | 8634 | 165 | 1 | 1.65 | Chryseobacterium sp. | 1871047 | Bacteria | Bacteria | 47.4 | 2.36e-4 | NR | WP_332650548.1 | 1871047 | g8458 | i0 | 53.7 | 0.745454545454545 | 41 | 19 | 74.5 | 0 | 159 | 37 | 172 | 212 | WP_332650548.1 hypothetical protein [Chryseobacterium sp.] | diamond | 123 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. | |
| 31211872 | 31211872 | PRJNA371613_P_NODE_8535_length_165_cov_1.000000_g8359_i0 | PRJNA371613 | 8535 | 165 | 1 | 1.65 | uncultured Hymenobacter sp. | 170016 | Bacteria | Bacteria | 96.7 | 1.36e-21 | NR | WP_375417845.1 | 170016 | g8359 | i0 | 85.5 | 1 | 55 | 8 | 100 | 0 | 1 | 165 | 376 | 430 | WP_375417845.1 ABC transporter permease [uncultured Hymenobacter sp.] | diamond | 165 | 96.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | uncultured Hymenobacter sp. | |
| 31243881 | 31243881 | PRJNA371613_P_NODE_5875_length_191_cov_1.662338_g5699_i0 | PRJNA371613 | 5875 | 191 | 1.662338 | 3.17506558 | Epilithonimonas xixisoli | 1476462 | Bacteria | Bacteria | 123 | 1.29e-31 | NR | WP_185145332.1 | 1476462 | g5699 | i0 | 98.4 | 2.96858638743455 | 63 | 1 | 99 | 0 | 189 | 1 | 61 | 123 | WP_185145332.1 TolC family protein [Epilithonimonas xixisoli] | diamond | 567 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Epilithonimonas | Epilithonimonas xixisoli | |
| 31433641 | 31433641 | PRJNA371613_P_NODE_7596_length_170_cov_0.962406_g7420_i0 | PRJNA371613 | 7596 | 170 | 0.962406 | 1.6360902 | Epilithonimonas hominis | 420404 | Bacteria | Bacteria | 115 | 3.3799999999999993e-28 | NR | WP_123282182.1 | 420404 | g7420 | i0 | 100 | 0.988235294117647 | 56 | 0 | 98.8 | 0 | 169 | 2 | 33 | 88 | WP_123282182.1 TAT-variant-translocated molybdopterin oxidoreductase [Epilithonimonas hominis] | diamond | 168 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Epilithonimonas | Epilithonimonas hominis | |
| 31560452 | 31560452 | PRJNA371613_P_NODE_6896_length_173_cov_2.823529_g6720_i0 | PRJNA371613 | 6896 | 173 | 2.823529 | 4.88470517 | Prevotella sp. | 59823 | Bacteria | Bacteria | 43.5 | 0.00787 | NR | MBS7367737.1 | 59823 | g6720 | i0 | 100 | 0.832369942196532 | 24 | 0 | 41.6 | 0 | 74 | 3 | 1 | 24 | MBS7367737.1 DUF4982 domain-containing protein [Prevotella sp.] | diamond | 144 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. | |
| 31876408 | 31876408 | PRJNA371613_P_NODE_7217_length_172_cov_0.948148_g7041_i0 | PRJNA371613 | 7217 | 172 | 0.948148 | 1.63081456 | Puia dinghuensis | 1792502 | Bacteria | Bacteria | 88.2 | 8.56e-20 | NR | WP_188936295.1 | 1792502 | g7041 | i0 | 81.8 | 0.959302325581395 | 55 | 10 | 95.9 | 0 | 167 | 3 | 6 | 60 | WP_188936295.1 response regulator [Puia dinghuensis] | diamond | 165 | 88.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Puia | Puia dinghuensis | |
| 32003142 | 32003142 | PRJNA371613_P_NODE_7258_length_171_cov_1.910448_g7082_i0 | PRJNA371613 | 7258 | 171 | 1.910448 | 3.26686608 | Capnocytophaga canimorsus | 28188 | Bacteria | Bacteria | 70.1 | 2.61e-14 | NR | WP_405239645.1 | 28188 | g7082 | i0 | 50 | 1.75438596491228 | 50 | 25 | 87.7 | 0 | 165 | 16 | 3 | 52 | WP_405239645.1 hypothetical protein [Capnocytophaga canimorsus] | diamond | 300 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | Capnocytophaga canimorsus | |
| 32509645 | 32509645 | PRJNA371613_P_NODE_6399_length_182_cov_1.620690_g6223_i0 | PRJNA371613 | 6399 | 182 | 1.62069 | 2.9496558 | Alloprevotella tannerae | 76122 | Bacteria | Bacteria | 121 | 9.76e-31 | NR | WP_006254506.1 | 76122 | g6223 | i0 | 96.7 | 0.989010989010989 | 60 | 2 | 98.9 | 0 | 1 | 180 | 321 | 380 | WP_006254506.1 aminoacyl-histidine dipeptidase [Alloprevotella tannerae] | diamond | 180 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Alloprevotella | Alloprevotella tannerae |
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);;