contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Candidatus Fervidibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27373386 | 27373386 | PRJNA946307_P_NODE_173063_length_153_cov_2.740385_g172189_i0 | PRJNA946307 | 173063 | 153 | 2.740385 | 4.19278905 | Candidatus Fervidibacter sp. | 3100871 | Bacteria | Bacteria | 94.4 | 9.1e-22 | NR | MFA0775551.1 | 3100871 | g172189 | i0 | 93.8 | 0.941176470588235 | 48 | 3 | 94.1 | 0 | 6 | 149 | 182 | 229 | MFA0775551.1 hypothetical protein [Candidatus Fervidibacter sp.] | diamond | 144 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Fervidibacterota | Candidatus Fervidibacter | Candidatus Fervidibacter sp. | |||||
| 29905903 | 29905903 | PRJNA946307_P_NODE_106171_length_181_cov_2.712121_g105297_i0 | PRJNA946307 | 106171 | 181 | 2.712121 | 4.90893901 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 44.7 | 0.00217 | NR | WP_259096678.1 | 1448929 | g105297 | i0 | 36.5 | 2.65193370165746 | 52 | 30 | 82.9 | 2 | 25 | 174 | 52 | 102 | WP_259096678.1 transcription termination/antitermination protein NusG [Candidatus Fervidibacter sacchari] | diamond | 480 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Fervidibacterota | Candidatus Fervidibacter | Candidatus Fervidibacter sacchari | |||||
| 30625538 | 30625538 | PRJNA946307_P_NODE_122873_length_174_cov_1.544000_g121999_i0 | PRJNA946307 | 122873 | 174 | 1.544 | 2.68656 | Candidatus Fervidibacter sp. | 3100871 | Bacteria | Bacteria | 126 | 3.9699999999999996e-32 | NR | MFA0732144.1 | 3100871 | g121999 | i0 | 98.1 | 1.82758620689655 | 53 | 1 | 91.4 | 0 | 3 | 161 | 154 | 206 | MFA0732144.1 hypothetical protein [Candidatus Fervidibacter sp.] | diamond | 318 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Fervidibacterota | Candidatus Fervidibacter | Candidatus Fervidibacter sp. | |||||
| 31447481 | 31447481 | PRJNA946307_P_NODE_131016_length_170_cov_2.355372_g130142_i0 | PRJNA946307 | 131016 | 170 | 2.355372 | 4.0041324 | Candidatus Fervidibacterota bacterium | 2080304 | Bacteria | Bacteria | 55.8 | 5.2100000000000003e-08 | NR | MFA0761756.1 | 2080304 | g130142 | i0 | 51 | 0.864705882352941 | 49 | 24 | 86.5 | 0 | 11 | 157 | 2 | 50 | MFA0761756.1 hypothetical protein [Candidatus Fervidibacterota bacterium] | diamond | 147 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Fervidibacterota | Candidatus Fervidibacterota bacterium | ||||||
| 31890207 | 31890207 | PRJNA946307_P_NODE_122377_length_174_cov_1.616000_g121503_i0 | PRJNA946307 | 122377 | 174 | 1.616 | 2.81184 | Candidatus Fervidibacter sp. | 3100871 | Bacteria | Bacteria | 77.8 | 6.26e-15 | NR | MFA0733970.1 | 3100871 | g121503 | i0 | 64.7 | 2.6551724137931 | 51 | 18 | 87.9 | 0 | 8 | 160 | 194 | 244 | MFA0733970.1 hypothetical protein [Candidatus Fervidibacter sp.] | diamond | 462 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Fervidibacterota | Candidatus Fervidibacter | Candidatus Fervidibacter 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);;