contig_metadata
6 rows where bioproject = "PRJNA986481", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28510773 | 28510773 | PRJNA986481_P_NODE_31187_length_293_cov_0.967213_g30662_i0 | PRJNA986481 | 31187 | 293 | 0.967213 | 2.83393409 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 105 | 2.88e-25 | NR | MCJ7802071.1 | 2026760 | g30662 | i0 | 50.5 | 0.993174061433447 | 97 | 46 | 97.3 | 2 | 287 | 3 | 173 | 269 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 291 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28542553 | 28542553 | PRJNA986481_P_NODE_36767_length_269_cov_1.159091_g36242_i0 | PRJNA986481 | 36767 | 269 | 1.159091 | 3.11795479 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.1 | 0.0359 | NR | MCH8303627.1 | 2026760 | g36242 | i0 | 33.8 | 0.825278810408922 | 74 | 49 | 82.5 | 0 | 27 | 248 | 182 | 255 | MCH8303627.1 serpin family protein [Fidelibacterota bacterium] | diamond | 222 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29521098 | 29521098 | PRJNA986481_P_NODE_41890_length_261_cov_1.900943_g41365_i0 | PRJNA986481 | 41890 | 261 | 1.900943 | 4.96146123 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.1 | 0.035 | NR | MDP7216876.1 | 2026760 | g41365 | i0 | 30.9 | 0.931034482758621 | 81 | 40 | 93.1 | 1 | 15 | 257 | 1953 | 2017 | MDP7216876.1 PQQ-binding-like beta-propeller repeat protein [Fidelibacterota bacterium] | diamond | 243 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29931792 | 29931792 | PRJNA986481_P_NODE_10691_length_501_cov_1.787611_g10170_i0 | PRJNA986481 | 10691 | 501 | 1.787611 | 8.95593111 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 46.2 | 0.0255 | NR | MBL7052137.1 | 2026760 | g10170 | i0 | 28.3 | 1.07784431137725 | 113 | 62 | 61.7 | 4 | 311 | 3 | 123 | 226 | MBL7052137.1 amidohydrolase family protein [Fidelibacterota bacterium] | diamond | 540 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30184348 | 30184348 | PRJNA986481_P_NODE_52072_length_250_cov_1.004975_g51547_i0 | PRJNA986481 | 52072 | 250 | 1.004975 | 2.5124375 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 103 | 1.1699999999999997e-23 | NR | MEE9162194.1 | 2026760 | g51547 | i0 | 57.3 | 3.936 | 82 | 35 | 98.4 | 0 | 3 | 248 | 288 | 369 | MEE9162194.1 M28 family metallopeptidase [Fidelibacterota bacterium] | diamond | 984 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32587490 | 32587490 | PRJNA986481_P_NODE_7039_length_610_cov_3.636364_g6549_i0 | PRJNA986481 | 7039 | 610 | 3.636364 | 22.1818204 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 162 | 1.53e-45 | NR | MCJ7802071.1 | 2026760 | g6549 | i0 | 46.4 | 0.816393442622951 | 166 | 87 | 80.7 | 2 | 4 | 495 | 104 | 269 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 498 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;