contig_metadata
11 rows where bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2942497 | 2942497 | PRJNA340009_P_NODE_14703_length_308_cov_6.633205_g14396_i0 | PRJNA340009 | 14703 | 308 | 6.633205 | 20.4302714 | Chlorobiota bacterium | 2268192 | Bacteria | Bacteria | 549 | 8.359999999999996e-152 | NTclustered | gi|1958119998|gb|CP065014.1| | 2268192 | g14396 | i0 | 99.34 | 0.983766233766234 | 303 | 2 | 98 | 0 | 1 | 303 | 1946528 | 1946830 | MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome | blastn | 303 | 549 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiota bacterium | |||||
| 4219377 | 4219377 | PRJNA340009_P_NODE_35224_length_212_cov_2.429448_g34917_i0 | PRJNA340009 | 35224 | 212 | 2.429448 | 5.15042976 | Chloroherpeton thalassium | 100716 | Bacteria | Bacteria | 54.7 | 0.005 | NTclustered | gi|193087197|gb|CP001100.1| | 517418 | g34917 | i0 | 87.5 | 0.358490566037736 | 48 | 4 | 23 | 2 | 59 | 106 | 1577615 | 1577570 | Chloroherpeton thalassium ATCC 35110, complete genome | blastn | 76 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chloroherpetonaceae | Chloroherpeton | Chloroherpeton thalassium | |
| 6769669 | 6769669 | PRJNA340009_P_NODE_29866_length_227_cov_7.775281_g29559_i0 | PRJNA340009 | 29866 | 227 | 7.775281 | 17.64988787 | Chlorobiota bacterium | 2268192 | Bacteria | Bacteria | 403 | 4.85e-108 | NTclustered | gi|1958119998|gb|CP065014.1| | 2268192 | g29559 | i0 | 99.55 | 0.977973568281938 | 222 | 0 | 97 | 1 | 1 | 221 | 3056388 | 3056609 | MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome | blastn | 222 | 403 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiota bacterium | |||||
| 27990843 | 27990843 | PRJNA340009_P_NODE_66985_length_165_cov_0.879310_g66678_i0 | PRJNA340009 | 66985 | 165 | 0.87931 | 1.4508615 | Chlorobium sp. | 1095 | Bacteria | Bacteria | 60.1 | 1.01e-8 | NR | MBV5330610.1 | 1095 | g66678 | i0 | 60.8 | 3.76363636363636 | 51 | 20 | 92.7 | 0 | 1 | 153 | 127 | 177 | MBV5330610.1 hypothetical protein [Chlorobium sp.] | diamond | 621 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. | |
| 28906137 | 28906137 | PRJNA340009_P_NODE_69328_length_164_cov_0.886957_g69021_i0 | PRJNA340009 | 69328 | 164 | 0.886957 | 1.45460948 | Chlorobiales bacterium | 2723030 | Bacteria | Bacteria | 57.8 | 5.76e-8 | NR | MBC8044077.1 | 2723030 | g69021 | i0 | 51.9 | 0.98780487804878 | 54 | 26 | 98.8 | 0 | 163 | 2 | 19 | 72 | MBC8044077.1 tetratricopeptide repeat protein [Chlorobiales bacterium] | diamond | 162 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiales bacterium | |||
| 29663759 | 29663759 | PRJNA340009_P_NODE_64050_length_166_cov_1.264957_g63743_i0 | PRJNA340009 | 64050 | 166 | 1.264957 | 2.09982862 | Chloroherpetonaceae bacterium | 2969135 | Bacteria | Bacteria | 56.2 | 7.06e-8 | NR | MEN6512265.1 | 2969135 | g63743 | i0 | 66.7 | 0.650602409638554 | 36 | 12 | 65.1 | 0 | 48 | 155 | 47 | 82 | MEN6512265.1 hypothetical protein [Chloroherpetonaceae bacterium] | diamond | 108 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chloroherpetonaceae | Chloroherpetonaceae bacterium | ||
| 30200878 | 30200878 | PRJNA340009_P_NODE_72492_length_163_cov_0.894737_g72185_i0 | PRJNA340009 | 72492 | 163 | 0.894737 | 1.45842131 | Chlorobiota bacterium | 2268192 | Bacteria | Bacteria | 46.6 | 5.39e-4 | NR | MFN3196289.1 | 2268192 | g72185 | i0 | 44.7 | 0.865030674846626 | 47 | 26 | 86.5 | 0 | 21 | 161 | 242 | 288 | MFN3196289.1 hypothetical protein [Chlorobiota bacterium] | diamond | 141 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiota bacterium | |||||
| 30376708 | 30376708 | PRJNA340009_P_NODE_28392_length_232_cov_3.874317_g28085_i0 | PRJNA340009 | 28392 | 232 | 3.874317 | 8.98841544 | Bacteria | 2 | Bacteria | Bacteria | 140 | 3.05e-38 | NR | MEI8103065.1 | 1095 | g28085 | i0 | 90.8 | 1.96551724137931 | 76 | 7 | 98.3 | 0 | 4 | 231 | 108 | 183 | MEI8103065.1 IS3 family transposase [Chlorobium sp.] | diamond | 456 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. | |
| 32305258 | 32305258 | PRJNA340009_P_NODE_54759_length_176_cov_2.188976_g54452_i0 | PRJNA340009 | 54759 | 176 | 2.188976 | 3.85259776 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.1 | 3.53e-11 | NR | MEI8103116.1 | 1095 | g54452 | i0 | 56.9 | 1.97727272727273 | 58 | 25 | 98.9 | 0 | 175 | 2 | 27 | 84 | MEI8103116.1 helix-turn-helix domain-containing protein [Chlorobium sp.] | diamond | 348 | 65.5 | 0.993893129770992 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. | |
| 32446113 | 32446113 | PRJNA340009_P_NODE_1519_length_776_cov_3.337001_g1257_i0 | PRJNA340009 | 1519 | 776 | 3.337001 | 25.89512776 | Chlorobium sp. | 1095 | Bacteria | Bacteria | 402 | 1.32e-137 | NR | MEI8103065.1 | 1095 | g1257 | i0 | 87.7 | 2.48582474226804 | 219 | 27 | 84.7 | 0 | 775 | 119 | 176 | 394 | MEI8103065.1 IS3 family transposase [Chlorobium sp.] | diamond | 1929 | 402 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. | |
| 32778376 | 32778376 | PRJNA340009_P_NODE_44900_length_191_cov_4.295775_g44593_i0 | PRJNA340009 | 44900 | 191 | 4.295775 | 8.20493025 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.5 | 9.25e-16 | NR | KER10942.1 | 1519464 | g44593 | i0 | 63.3 | 12.0785340314136 | 60 | 22 | 94.2 | 0 | 7 | 186 | 534 | 593 | KER10942.1 MAG: aspartate kinase [[Candidatus Thermochlorobacteriaceae] bacterium GBChlB] | diamond | 2307 | 81.3 | 0.990159901599016 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chloroherpetonaceae | [Candidatus Thermochlorobacteriaceae] bacterium GBChlB |
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);;