contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27270773 | 27270773 | PRJNA641707_P_NODE_275123_length_172_cov_4.886179_g272460_i0 | PRJNA641707 | 275123 | 172 | 4.886179 | 8.40422788 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 85.1 | 1.59e-17 | NR | MEO6098476.1 | 2725311 | g272460 | i0 | 72.2 | 0.941860465116279 | 54 | 15 | 94.2 | 0 | 163 | 2 | 418 | 471 | MEO6098476.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 162 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 27409760 | 27409760 | PRJNA641707_P_NODE_123963_length_245_cov_4.571429_g121300_i0 | PRJNA641707 | 123963 | 245 | 4.571429 | 11.20000105 | Bacteria | 2 | Bacteria | Bacteria | 68.2 | 2.03e-11 | NR | NLW32912.1 | 35828 | g121300 | i0 | 87.9 | 2.82857142857143 | 33 | 4 | 40.4 | 0 | 3 | 101 | 92 | 124 | NLW32912.1 IS5 family transposase [Fibrobacter sp.] | diamond | 693 | 68.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 28155168 | 28155168 | PRJNA641707_P_NODE_237705_length_187_cov_6.195652_g235042_i0 | PRJNA641707 | 237705 | 187 | 6.195652 | 11.58586924 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 110 | 1.7600000000000002e-26 | NR | MBW8889910.1 | 2052160 | g235042 | i0 | 80 | 0.962566844919786 | 60 | 12 | 96.3 | 0 | 182 | 3 | 916 | 975 | MBW8889910.1 DNA polymerase III subunit alpha [Fibrobacterota bacterium] | diamond | 180 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 28861849 | 28861849 | PRJNA641707_P_NODE_38108_length_352_cov_10.775578_g35468_i0 | PRJNA641707 | 38108 | 352 | 10.775578 | 37.93003456 | Bacteria | 2 | Bacteria | Bacteria | 107 | 1.31e-24 | NR | MBW8889356.1 | 2052160 | g35468 | i0 | 75.7 | 2.38636363636364 | 70 | 13 | 59.7 | 1 | 210 | 1 | 3 | 68 | MBW8889356.1 DUF444 family protein [Fibrobacterota bacterium] | diamond | 840 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 30776384 | 30776384 | PRJNA641707_P_NODE_302754_length_163_cov_8.789474_g300091_i0 | PRJNA641707 | 302754 | 163 | 8.789474 | 14.32684262 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 83.2 | 3.27e-17 | NR | MDB5102516.1 | 2052160 | g300091 | i0 | 76 | 2.76073619631902 | 50 | 11 | 92 | 1 | 152 | 3 | 11 | 59 | MDB5102516.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 450 | 83.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 31535074 | 31535074 | PRJNA641707_P_NODE_272736_length_173_cov_4.483871_g270073_i0 | PRJNA641707 | 272736 | 173 | 4.483871 | 7.75709683 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 45.8 | 9.64e-4 | NR | MDB5102747.1 | 2052160 | g270073 | i0 | 63.6 | 0.572254335260116 | 33 | 12 | 57.2 | 0 | 70 | 168 | 115 | 147 | MDB5102747.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 99 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 31629758 | 31629758 | PRJNA641707_P_NODE_187496_length_199_cov_6.066667_g184833_i0 | PRJNA641707 | 187496 | 199 | 6.066667 | 12.07266733 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 57.4 | 1.02e-7 | NR | NLW32089.1 | 35828 | g184833 | i0 | 72.7 | 1.98994974874372 | 33 | 9 | 49.7 | 0 | 101 | 3 | 191 | 223 | NLW32089.1 Ku protein [Fibrobacter sp.] | diamond | 396 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. |
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);;