contig_metadata
6 rows where bioproject = "PRJNA674308", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 644624 | 644624 | PRJNA674308_P_NODE_26741_length_194_cov_1.324138_g26506_i0 | PRJNA674308 | 26741 | 194 | 1.324138 | 2.56882772 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 220 | 4.34e-53 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g26506 | i0 | 87.179 | 41.1546391752577 | 195 | 24 | 100 | 1 | 1 | 194 | 3679730 | 3679924 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 7984 | 220 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 7023351 | 7023351 | PRJNA674308_P_NODE_23526_length_205_cov_1.583333_g23291_i0 | PRJNA674308 | 23526 | 205 | 1.583333 | 3.24583265 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 279 | 7.54e-71 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g23291 | i0 | 91.22 | 109.419512195122 | 205 | 18 | 100 | 0 | 1 | 205 | 3680349 | 3680553 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 22431 | 279 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 14673986 | 14673986 | PRJNA674308_P_NODE_7472_length_347_cov_11.157718_g7237_i0 | PRJNA674308 | 7472 | 347 | 11.157718 | 38.71728146 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 372 | 2.22e-98 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g7237 | i0 | 88.599 | 126.789625360231 | 307 | 34 | 88 | 1 | 1 | 307 | 3680024 | 3679719 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 43996 | 372 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28724011 | 28724011 | PRJNA674308_P_NODE_48627_length_164_cov_0.904348_g48392_i0 | PRJNA674308 | 48627 | 164 | 0.904348 | 1.48313072 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 99 | 1.5099999999999998e-23 | NR | MDR3615957.1 | 2364082 | g48392 | i0 | 92.6 | 0.98780487804878 | 54 | 4 | 98.8 | 0 | 2 | 163 | 143 | 196 | MDR3615957.1 SDR family oxidoreductase [Candidatus Obscuribacterales bacterium] | diamond | 162 | 99 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31092861 | 31092861 | PRJNA674308_P_NODE_37675_length_168_cov_2.184874_g37440_i0 | PRJNA674308 | 37675 | 168 | 2.184874 | 3.67058832 | Candidatus Melainabacteria bacterium GWF2_37_15 | 1801606 | Bacteria | Bacteria | 61.6 | 2.84e-9 | NR | OGI00366.1 | 1801606 | g37440 | i0 | 55.8 | 1.67857142857143 | 52 | 23 | 92.9 | 0 | 167 | 12 | 275 | 326 | OGI00366.1 MAG: glutamate-5-semialdehyde dehydrogenase [Candidatus Melainabacteria bacterium GWF2_37_15] | diamond | 282 | 61.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium GWF2_37_15 | |||||
| 32799723 | 32799723 | PRJNA674308_P_NODE_32760_length_177_cov_1.218750_g32525_i0 | PRJNA674308 | 32760 | 177 | 1.21875 | 2.1571875 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 42 | 0.0283 | NR | MCD8024556.1 | 2137880 | g32525 | i0 | 45.7 | 0.593220338983051 | 35 | 19 | 59.3 | 0 | 72 | 176 | 103 | 137 | MCD8024556.1 molecular chaperone DnaJ [Candidatus Gastranaerophilales bacterium] | diamond | 105 | 42 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales 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);;