contig_metadata
9 rows where bioproject = "PRJNA1035005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26971786 | 26971786 | PRJNA1035005_P_NODE_6702_length_416_cov_2.737609_g6300_i0 | PRJNA1035005 | 6702 | 416 | 2.737609 | 11.38845344 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 199 | 4.02e-63 | NR | MBX9722668.1 | 2364082 | g6300 | i0 | 73.1 | 0.9375 | 130 | 35 | 93.8 | 0 | 414 | 25 | 8 | 137 | MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 390 | 199 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27793417 | 27793417 | PRJNA1035005_P_NODE_26964_length_286_cov_2.333333_g26558_i0 | PRJNA1035005 | 26964 | 286 | 2.333333 | 6.67333238 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 180 | 1.54e-50 | NR | MBX9572987.1 | 2364082 | g26558 | i0 | 95.7 | 0.986013986013986 | 94 | 4 | 98.6 | 0 | 3 | 284 | 36 | 129 | MBX9572987.1 ATP-dependent DNA helicase [Candidatus Obscuribacterales bacterium] | diamond | 282 | 180 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28140895 | 28140895 | PRJNA1035005_P_NODE_55065_length_253_cov_0.866667_g54659_i0 | PRJNA1035005 | 55065 | 253 | 0.866667 | 2.19266751 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 85.5 | 3.74e-17 | NR | MBX9573989.1 | 2364082 | g54659 | i0 | 98.4 | 0.723320158102767 | 61 | 1 | 72.3 | 0 | 183 | 1 | 1 | 61 | MBX9573989.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 183 | 85.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28645958 | 28645958 | PRJNA1035005_P_NODE_74767_length_246_cov_0.901734_g74361_i0 | PRJNA1035005 | 74767 | 246 | 0.901734 | 2.21826564 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 145 | 2.75e-38 | NR | MBX3136942.1 | 2364082 | g74361 | i0 | 100 | 1.97560975609756 | 81 | 0 | 98.8 | 0 | 245 | 3 | 140 | 220 | MBX3136942.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 486 | 145 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30003682 | 30003682 | PRJNA1035005_P_NODE_34391_length_277_cov_1.220588_g33985_i0 | PRJNA1035005 | 34391 | 277 | 1.220588 | 3.38102876 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 163 | 3.3699999999999998e-46 | NR | MBK9142728.1 | 2052166 | g33985 | i0 | 94.5 | 0.985559566787004 | 91 | 5 | 98.6 | 0 | 5 | 277 | 200 | 290 | MBK9142728.1 NnrS family protein [Candidatus Melainabacteria bacterium] | diamond | 273 | 163 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30351678 | 30351678 | PRJNA1035005_P_NODE_73312_length_246_cov_0.901734_g72906_i0 | PRJNA1035005 | 73312 | 246 | 0.901734 | 2.21826564 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 109 | 5.49e-28 | NR | MBX9572691.1 | 2364082 | g72906 | i0 | 100 | 0.646341463414634 | 53 | 0 | 64.6 | 0 | 244 | 86 | 142 | 194 | MBX9572691.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 159 | 109 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31109277 | 31109277 | PRJNA1035005_P_NODE_76235_length_245_cov_0.906977_g75829_i0 | PRJNA1035005 | 76235 | 245 | 0.906977 | 2.22209365 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 60.5 | 1.04e-9 | NR | HEY9784808.1 | 2364082 | g75829 | i0 | 42.9 | 0.857142857142857 | 70 | 40 | 85.7 | 0 | 2 | 211 | 28 | 97 | HEY9784808.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 210 | 60.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32753451 | 32753451 | PRJNA1035005_P_NODE_33440_length_278_cov_1.492683_g33034_i0 | PRJNA1035005 | 33440 | 278 | 1.492683 | 4.14965874 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 101 | 1.5000000000000002e-22 | NR | MBN9397551.1 | 2052166 | g33034 | i0 | 100 | 0.507194244604317 | 47 | 0 | 50.7 | 0 | 3 | 143 | 653 | 699 | MBN9397551.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 141 | 101 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32753454 | 32753454 | PRJNA1035005_P_NODE_39200_length_270_cov_2.314721_g38794_i0 | PRJNA1035005 | 39200 | 270 | 2.314721 | 6.2497467 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 180 | 1.0999999999999999e-53 | NR | MBX9572034.1 | 2364082 | g38794 | i0 | 100 | 1 | 90 | 0 | 100 | 0 | 270 | 1 | 257 | 346 | MBX9572034.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 270 | 180 | 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);;