contig_metadata
5 rows where bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8770988 | 8770988 | PRJNA533623_P_NODE_45727_length_314_cov_9.126482_g43951_i0 | PRJNA533623 | 45727 | 314 | 9.126482 | 28.65715348 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75 | 6.27e-9 | NTclustered | gi|1070918267|gb|CP017305.1| | 274537 | g43951 | i0 | 95.745 | 2.11783439490446 | 47 | 1 | 15 | 1 | 76 | 122 | 1833022 | 1833067 | Chlorobaculum limnaeum strain DSM 1677 chromosome, complete genome | blastn | 665 | 75 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobaculum | Chlorobaculum limnaeum | |
| 11985052 | 11985052 | PRJNA533623_P_NODE_31790_length_399_cov_15.068047_g30019_i0 | PRJNA533623 | 31790 | 399 | 15.068047 | 60.12150753 | Chlorobiota bacterium | 2268192 | Bacteria | Bacteria | 212 | 7.2e-63 | NR | RMF35224.1 | 2268192 | g30019 | i0 | 89.3 | 0.909774436090226 | 121 | 13 | 91 | 0 | 377 | 15 | 32 | 152 | RMF35224.1 MAG: ABC transporter ATP-binding protein [Chlorobiota bacterium] | diamond | 363 | 212 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiota bacterium | |||||
| 22183181 | 22183181 | PRJNA533623_P_NODE_378_length_2550_cov_47.197268_g223_i0 | PRJNA533623 | 378 | 2550 | 47.197268 | 1203.530334 | Chlorobaculum tepidum | 1097 | Bacteria | Bacteria | 760 | 0 | NTclustered | gi|21672293|gb|AE006470.1| | 194439 | g223 | i0 | 85.519 | 25.8047058823529 | 732 | 100 | 29 | 6 | 43 | 771 | 1781295 | 1780567 | Chlorobium tepidum TLS, complete genome | blastn | 65802 | 760 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobaculum | Chlorobaculum tepidum | |
| 27377485 | 27377485 | PRJNA533623_P_NODE_29283_length_420_cov_8.565460_g27513_i0 | PRJNA533623 | 29283 | 420 | 8.56546 | 35.974932 | Bacteria | 2 | Bacteria | Bacteria | 101 | 5.07e-22 | NR | WP_059139550.1 | 1092 | g27513 | i0 | 71.9 | 8.69285714285714 | 64 | 18 | 45.7 | 0 | 97 | 288 | 31 | 94 | WP_059139550.1 citrate synthase [Chlorobium limicola] | diamond | 3651 | 102 | 0.990196078431373 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium limicola | |
| 29666846 | 29666846 | PRJNA533623_P_NODE_75190_length_206_cov_2.731034_g73409_i0 | PRJNA533623 | 75190 | 206 | 2.731034 | 5.62593004 | Chlorobium sp. | 1095 | Bacteria | Bacteria | 42 | 0.0448 | NR | MBV5304086.1 | 1095 | g73409 | i0 | 40.4 | 0.684466019417476 | 47 | 26 | 68.4 | 1 | 152 | 12 | 1692 | 1736 | MBV5304086.1 VCBS domain-containing protein [Chlorobium sp.] | diamond | 141 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobium | Chlorobium sp. |
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);;