contig_metadata
12 rows where bioproject = "PRJNA951810" and tax_phylum = "Chlorobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 938198 | 938198 | PRJNA951810_P_NODE_93241_length_296_cov_4.224215_g92897_i0 | PRJNA951810 | 93241 | 296 | 4.224215 | 12.5036764 | Chlorobaculum sp. MV4-Y | 2976335 | Bacteria | Bacteria | 230 | 1.1799999999999998e-55 | NTclustered | gi|2304448134|gb|CP104202.1| | 2976335 | g92897 | i0 | 82.772 | 72.7972972972973 | 267 | 36 | 89 | 7 | 10 | 271 | 1249415 | 1249154 | Chlorobaculum sp. MV4-Y chromosome, complete genome | blastn | 21548 | 230 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobaculum | Chlorobaculum sp. MV4-Y | |
| 7315223 | 7315223 | PRJNA951810_P_NODE_32086_length_352_cov_9.297491_g31744_i0 | PRJNA951810 | 32086 | 352 | 9.297491 | 32.72716832 | Chlorobaculum limnaeum | 274537 | Bacteria | Bacteria | 102 | 3.26e-17 | NTclustered | gi|1070918267|gb|CP017305.1| | 274537 | g31744 | i0 | 80.292 | 1.05681818181818 | 137 | 25 | 39 | 2 | 217 | 352 | 2212792 | 2212657 | Chlorobaculum limnaeum strain DSM 1677 chromosome, complete genome | blastn | 372 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobaculum | Chlorobaculum limnaeum | |
| 16240097 | 16240097 | PRJNA951810_P_NODE_37053_length_322_cov_5.759036_g36710_i0 | PRJNA951810 | 37053 | 322 | 5.759036 | 18.54409592 | Pelodictyon phaeoclathratiforme | 34090 | Bacteria | Bacteria | 62.1 | 5.02e-5 | NTclustered | gi|194307659|gb|CP001110.1| | 324925 | g36710 | i0 | 95 | 16.2701863354037 | 40 | 1 | 12 | 1 | 168 | 207 | 2509938 | 2509900 | Pelodictyon phaeoclathratiforme BU-1 chromosome, complete genome | blastn | 5239 | 62.1 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Pelodictyon | Pelodictyon phaeoclathratiforme | |
| 17516208 | 17516208 | PRJNA951810_P_NODE_83234_length_299_cov_2.964602_g82890_i0 | PRJNA951810 | 83234 | 299 | 2.964602 | 8.86415998 | Bacteria | 2 | Bacteria | Bacteria | 172 | 1.01e-49 | NR | TLU51734.1 | 1095 | g82890 | i0 | 86.9 | 26.819397993311 | 99 | 13 | 99.3 | 0 | 297 | 1 | 31 | 129 | TLU51734.1 MAG: divalent metal cation transporter [Chlorobium sp.] | diamond | 8019 | 172 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. | |
| 26677098 | 26677098 | PRJNA951810_P_NODE_109901_length_287_cov_1.677570_g109557_i0 | PRJNA951810 | 109901 | 287 | 1.67757 | 4.8146259 | Chlorobi bacterium NICIL-2 | 1662223 | Bacteria | Bacteria | 60.1 | 3.75e-8 | NR | KXB97453.1 | 1662223 | g109557 | i0 | 43.2 | 0.993031358885017 | 95 | 51 | 97.2 | 3 | 285 | 7 | 87 | 180 | KXB97453.1 MAG: hypothetical protein AA908_06230 [Chlorobi bacterium NICIL-2] | diamond | 285 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobi bacterium NICIL-2 | |||||
| 27878657 | 27878657 | PRJNA951810_P_NODE_89085_length_298_cov_2.608889_g88741_i0 | PRJNA951810 | 89085 | 298 | 2.608889 | 7.77448922 | Chlorobi bacterium NICIL-2 | 1662223 | Bacteria | Bacteria | 199 | 2.09e-59 | NR | KXB97596.1 | 1662223 | g88741 | i0 | 93.3 | 1.05704697986577 | 105 | 1 | 99.7 | 1 | 1 | 297 | 272 | 376 | KXB97596.1 MAG: hypothetical protein AA908_05575 [Chlorobi bacterium NICIL-2] | diamond | 315 | 199 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobi bacterium NICIL-2 | |||||
| 27973267 | 27973267 | PRJNA951810_P_NODE_136605_length_268_cov_3.743590_g136260_i0 | PRJNA951810 | 136605 | 268 | 3.74359 | 10.0328212 | Chlorobi bacterium NICIL-2 | 1662223 | Bacteria | Bacteria | 155 | 9.2e-42 | NR | KXB97076.1 | 1662223 | g136260 | i0 | 96.6 | 0.985074626865672 | 88 | 3 | 98.5 | 0 | 267 | 4 | 188 | 275 | KXB97076.1 MAG: hypothetical protein AA908_08490, partial [Chlorobi bacterium NICIL-2] | diamond | 264 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobi bacterium NICIL-2 | |||||
| 28636637 | 28636637 | PRJNA951810_P_NODE_68947_length_309_cov_2.411017_g68603_i0 | PRJNA951810 | 68947 | 309 | 2.411017 | 7.45004253 | Chlorobium ferrooxidans | 84205 | Bacteria | Bacteria | 81.3 | 2.42e-15 | NR | WP_006367293.1 | 84205 | g68603 | i0 | 78 | 2.39805825242718 | 50 | 11 | 48.5 | 0 | 308 | 159 | 828 | 877 | WP_006367293.1 type I restriction endonuclease subunit R [Chlorobium ferrooxidans] | diamond | 741 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium ferrooxidans | |
| 30373727 | 30373727 | PRJNA951810_P_NODE_76052_length_299_cov_6.141593_g75708_i0 | PRJNA951810 | 76052 | 299 | 6.141593 | 18.36336307 | Chlorobaculum tepidum | 1097 | Bacteria | Bacteria | 122 | 1.03e-29 | NR | WP_226986841.1 | 1097 | g75708 | i0 | 60.6 | 0.993311036789298 | 99 | 39 | 99.3 | 0 | 2 | 298 | 520 | 618 | WP_226986841.1 glycosyltransferase family 87 protein [Chlorobaculum tepidum] | diamond | 297 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobaculum | Chlorobaculum tepidum | |
| 31669114 | 31669114 | PRJNA951810_P_NODE_179077_length_233_cov_3.675000_g178732_i0 | PRJNA951810 | 179077 | 233 | 3.675 | 8.56275 | Chlorobiaceae bacterium | 2067991 | Bacteria | Bacteria | 85.1 | 3.22e-17 | NR | NTW68872.1 | 2067991 | g178732 | i0 | 52.7 | 1.90557939914163 | 74 | 35 | 95.3 | 0 | 4 | 225 | 266 | 339 | NTW68872.1 Tol-Pal system beta propeller repeat protein TolB [Chlorobiaceae bacterium] | diamond | 444 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobiaceae bacterium | ||
| 31960314 | 31960314 | PRJNA951810_P_NODE_57897_length_310_cov_3.915612_g57554_i0 | PRJNA951810 | 57897 | 310 | 3.915612 | 12.1383972 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.8 | 3.2e-16 | NR | MEI7706697.1 | 1095 | g57554 | i0 | 72.9 | 3.73548387096774 | 48 | 13 | 46.5 | 0 | 6 | 149 | 63 | 110 | MEI7706697.1 SPFH domain-containing protein [Chlorobium sp.] | diamond | 1158 | 83.2 | 0.995192307692308 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. | |
| 32023701 | 32023701 | PRJNA951810_P_NODE_64838_length_310_cov_2.869198_g64495_i0 | PRJNA951810 | 64838 | 310 | 2.869198 | 8.8945138 | Bacteria | 2 | Bacteria | Bacteria | 61.2 | 1.93e-8 | NR | MDB5034780.1 | 2268192 | g64495 | i0 | 58.7 | 0.832258064516129 | 46 | 19 | 44.5 | 0 | 303 | 166 | 75 | 120 | MDB5034780.1 AraC family transcriptional regulator [Chlorobiota bacterium] | diamond | 258 | 61.2 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiota 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);;