contig_metadata
8 rows where bioproject = "PRJNA340009" and tax_phylum = "Fibrobacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27169316 | 27169316 | PRJNA340009_P_NODE_69422_length_164_cov_0.886957_g69115_i0 | PRJNA340009 | 69422 | 164 | 0.886957 | 1.45460948 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 94.4 | 1.63e-22 | NR | MBK9577754.1 | 2052160 | g69115 | i0 | 84.3 | 0.932926829268293 | 51 | 8 | 93.3 | 0 | 1 | 153 | 56 | 106 | MBK9577754.1 elongation factor P [Fibrobacterota bacterium] | diamond | 153 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 27502899 | 27502899 | PRJNA340009_P_NODE_61963_length_167_cov_0.864407_g61656_i0 | PRJNA340009 | 61963 | 167 | 0.864407 | 1.44355969 | Bacteria | 2 | Bacteria | Bacteria | 95.9 | 2.5300000000000003e-21 | NR | QQS07523.1 | 2052160 | g61656 | i0 | 83 | 2.8562874251497 | 53 | 9 | 95.2 | 0 | 160 | 2 | 1 | 53 | QQS07523.1 MAG: isoleucine--tRNA ligase [Fibrobacterota bacterium] | diamond | 477 | 95.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 28874718 | 28874718 | PRJNA340009_P_NODE_65288_length_166_cov_0.871795_g64981_i0 | PRJNA340009 | 65288 | 166 | 0.871795 | 1.4471797 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 83.6 | 3.96e-17 | NR | MEN9354133.1 | 2052160 | g64981 | i0 | 77.4 | 0.957831325301205 | 53 | 12 | 95.8 | 0 | 7 | 165 | 82 | 134 | MEN9354133.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 159 | 83.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 29159129 | 29159129 | PRJNA340009_P_NODE_76389_length_161_cov_0.910714_g76082_i0 | PRJNA340009 | 76389 | 161 | 0.910714 | 1.46624954 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 58.9 | 2.35e-8 | NR | MBW8890480.1 | 2052160 | g76082 | i0 | 60.4 | 0.987577639751553 | 53 | 16 | 98.8 | 1 | 161 | 3 | 170 | 217 | MBW8890480.1 sigma-70 family RNA polymerase sigma factor [Fibrobacterota bacterium] | diamond | 159 | 58.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 29695333 | 29695333 | PRJNA340009_P_NODE_62310_length_167_cov_0.864407_g62003_i0 | PRJNA340009 | 62310 | 167 | 0.864407 | 1.44355969 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 102 | 1.06e-24 | NR | WP_407457182.1 | 35828 | g62003 | i0 | 85.5 | 0.988023952095808 | 55 | 8 | 98.8 | 0 | 1 | 165 | 80 | 134 | WP_407457182.1 HNH endonuclease signature motif containing protein [Fibrobacter sp.] | diamond | 165 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 30043040 | 30043040 | PRJNA340009_P_NODE_32891_length_218_cov_7.266272_g32584_i0 | PRJNA340009 | 32891 | 218 | 7.266272 | 15.84047296 | Chitinispirillaceae bacterium | 2813024 | Bacteria | Bacteria | 43.1 | 0.0133 | NR | HEX2959828.1 | 2813024 | g32584 | i0 | 48.1 | 0.743119266055046 | 54 | 26 | 74.3 | 2 | 168 | 7 | 102 | 153 | HEX2959828.1 HlyD family efflux transporter periplasmic adaptor subunit [Chitinispirillaceae bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Chitinispirillia | Chitinispirillales | Chitinispirillaceae | Chitinispirillaceae bacterium | ||
| 30706533 | 30706533 | PRJNA340009_P_NODE_52294_length_180_cov_1.519084_g51987_i0 | PRJNA340009 | 52294 | 180 | 1.519084 | 2.7343512 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 75.1 | 5.56e-16 | NR | MDR1759855.1 | 35828 | g51987 | i0 | 58.5 | 0.883333333333333 | 53 | 22 | 88.3 | 0 | 180 | 22 | 32 | 84 | MDR1759855.1 DUF3781 domain-containing protein [Fibrobacter sp.] | diamond | 159 | 75.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 31908030 | 31908030 | PRJNA340009_P_NODE_74497_length_162_cov_0.902655_g74190_i0 | PRJNA340009 | 74497 | 162 | 0.902655 | 1.4623011 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 106 | 2.03e-26 | NR | MEN9355515.1 | 2052160 | g74190 | i0 | 96 | 0.925925925925926 | 50 | 2 | 92.6 | 0 | 150 | 1 | 49 | 98 | MEN9355515.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 150 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota 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);;