contig_metadata
9 rows where bioproject = "PRJNA1063685", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179556 | 179556 | PRJNA1063685_S_NODE_29481_length_432_cov_22.896936_g28939_i0 | PRJNA1063685 | 29481 | 432 | 22.896936 | 98.91476352 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 107 | 2.51e-26 | NR | MBL8086383.1 | 2711154 | g28939 | i0 | 58.8 | 0.673611111111111 | 97 | 25 | 67.4 | 1 | 431 | 141 | 59 | 140 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 291 | 107 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 1454213 | 1454213 | PRJNA1063685_S_NODE_30642_length_424_cov_4.441595_g30100_i0 | PRJNA1063685 | 30642 | 424 | 4.441595 | 18.8323628 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 640 | 6.85e-179 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g30100 | i0 | 94.66 | 188.884433962264 | 412 | 22 | 97 | 0 | 1 | 412 | 3682209 | 3682620 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 80087 | 640 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 15482356 | 15482356 | PRJNA1063685_S_NODE_35333_length_394_cov_5.096573_g34790_i0 | PRJNA1063685 | 35333 | 394 | 5.096573 | 20.08049762 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 322 | 2.5999999999999997e-83 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g34790 | i0 | 83.714 | 70.6573604060914 | 350 | 47 | 87 | 9 | 22 | 365 | 3681110 | 3681455 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 27839 | 322 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 20580449 | 20580449 | PRJNA1063685_S_NODE_18617_length_523_cov_20.515556_g18081_i0 | PRJNA1063685 | 18617 | 523 | 20.515556 | 107.29635788 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 263 | 3.5599999999999987e-87 | NR | MBX9724270.1 | 2364082 | g18081 | i0 | 90.7 | 0.803059273422562 | 140 | 13 | 80.3 | 0 | 6 | 425 | 31 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 420 | 263 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27067017 | 27067017 | PRJNA1063685_S_NODE_6982_length_683_cov_8.809836_g6494_i0 | PRJNA1063685 | 6982 | 683 | 8.809836 | 60.17117988 | Vampirovibrio sp. | 2717857 | Bacteria | Bacteria | 171 | 9.36e-49 | NR | MCE3234578.1 | 2717857 | g6494 | i0 | 43.4 | 2.92093704245974 | 228 | 126 | 99.7 | 2 | 1 | 681 | 50 | 275 | MCE3234578.1 Retinol dehydrogenase [Vampirovibrio sp.] | diamond | 1995 | 171 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio sp. | ||
| 27224944 | 27224944 | PRJNA1063685_S_NODE_20063_length_509_cov_4.357798_g19525_i0 | PRJNA1063685 | 20063 | 509 | 4.357798 | 22.18119182 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 168 | 8.11e-50 | NR | MCM1003174.1 | 2137880 | g19525 | i0 | 53 | 1.90373280943026 | 164 | 77 | 96.7 | 0 | 6 | 497 | 14 | 177 | MCM1003174.1 adenine phosphoribosyltransferase [Candidatus Gastranaerophilales bacterium] | diamond | 969 | 168 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 28038093 | 28038093 | PRJNA1063685_S_NODE_40865_length_364_cov_1.044674_g40322_i0 | PRJNA1063685 | 40865 | 364 | 1.044674 | 3.80261336 | Bacteria | 2 | Bacteria | Bacteria | 150 | 1.54e-40 | NR | RTL35142.1 | 2052166 | g40322 | i0 | 59.3 | 10.5576923076923 | 118 | 48 | 97.3 | 0 | 362 | 9 | 279 | 396 | RTL35142.1 MAG: putrescine aminotransferase [Candidatus Melainabacteria bacterium] | diamond | 3843 | 150 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29530275 | 29530275 | PRJNA1063685_S_NODE_48830_length_324_cov_4.231076_g48287_i0 | PRJNA1063685 | 48830 | 324 | 4.231076 | 13.70868624 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 84 | 6.65e-19 | NR | MBX9771134.1 | 2364082 | g48287 | i0 | 74.1 | 0.5 | 54 | 14 | 50 | 0 | 168 | 7 | 1 | 54 | MBX9771134.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 162 | 84 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30352045 | 30352045 | PRJNA1063685_S_NODE_8612_length_651_cov_15.522491_g8107_i0 | PRJNA1063685 | 8612 | 651 | 15.522491 | 101.05141641 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 253 | 5.91e-79 | NR | MBX3148973.1 | 2364082 | g8107 | i0 | 58 | 0.921658986175115 | 200 | 84 | 92.2 | 0 | 2 | 601 | 244 | 443 | MBX3148973.1 putrescine aminotransferase [Candidatus Obscuribacterales bacterium] | diamond | 600 | 253 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales 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);;