contig_metadata
12 rows where bioproject = "PRJNA390533" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 409785 | 409785 | PRJNA390533_P_NODE_38841_length_186_cov_1.333333_g37814_i0 | PRJNA390533 | 38841 | 186 | 1.333333 | 2.47999938 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 58.9 | 2.27e-8 | NR | HEX8552111.1 | 2800791 | g37814 | i0 | 44.3 | 1.93548387096774 | 61 | 33 | 98.4 | 1 | 184 | 2 | 4 | 63 | HEX8552111.1 helix-turn-helix domain-containing protein [Abditibacteriaceae bacterium] | diamond | 360 | 58.9 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 2960359 | 2960359 | PRJNA390533_P_NODE_23683_length_330_cov_3.350515_g22659_i0 | PRJNA390533 | 23683 | 330 | 3.350515 | 11.0566995 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 283 | 1.01e-71 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g22659 | i0 | 82.769 | 278.942424242424 | 325 | 49 | 98 | 7 | 7 | 328 | 2851497 | 2851177 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 92051 | 283 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 2960508 | 2960508 | PRJNA390533_P_NODE_37923_length_190_cov_3.331126_g36896_i0 | PRJNA390533 | 37923 | 190 | 3.331126 | 6.3291394 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 219 | 1.52e-52 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g36896 | i0 | 87.368 | 235.373684210526 | 190 | 24 | 100 | 0 | 1 | 190 | 2851529 | 2851718 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 44721 | 219 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 13163594 | 13163594 | PRJNA390533_P_NODE_43271_length_168_cov_1.503876_g42244_i0 | PRJNA390533 | 43271 | 168 | 1.503876 | 2.52651168 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 281 | 1.65e-71 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g42244 | i0 | 98.137 | 3.45238095238095 | 161 | 3 | 96 | 0 | 8 | 168 | 2852839 | 2852679 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 580 | 281 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 16987002 | 16987002 | PRJNA390533_P_NODE_14754_length_486_cov_5.568233_g13763_i0 | PRJNA390533 | 14754 | 486 | 5.568233 | 27.06161238 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 377 | 6.880000000000001e-100 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g13763 | i0 | 82.619 | 235.810699588477 | 443 | 61 | 90 | 12 | 31 | 466 | 2852274 | 2851841 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 114604 | 377 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 18261085 | 18261085 | PRJNA390533_P_NODE_12175_length_554_cov_5.848544_g11237_i0 | PRJNA390533 | 12175 | 554 | 5.848544 | 32.40093376 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 459 | 2.7499999999999992e-124 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g11237 | i0 | 83.865 | 78.1516245487365 | 502 | 60 | 89 | 16 | 31 | 524 | 2852274 | 2851786 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 43296 | 459 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 20811398 | 20811398 | PRJNA390533_P_NODE_35097_length_208_cov_1.035503_g34070_i0 | PRJNA390533 | 35097 | 208 | 1.035503 | 2.15384624 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 89.4 | 9.23e-19 | NR | HEX8549949.1 | 2800791 | g34070 | i0 | 69.6 | 0.995192307692308 | 69 | 17 | 99.5 | 1 | 2 | 208 | 582 | 646 | HEX8549949.1 DEAD/DEAH box helicase family protein [Abditibacteriaceae bacterium] | diamond | 207 | 89.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 22086259 | 22086259 | PRJNA390533_P_NODE_40038_length_180_cov_2.744681_g39011_i0 | PRJNA390533 | 40038 | 180 | 2.744681 | 4.9404258 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 239 | 1.09e-58 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g39011 | i0 | 93.827 | 283.25 | 162 | 4 | 88 | 4 | 22 | 180 | 2852303 | 2852461 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 50985 | 239 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 24635971 | 24635971 | PRJNA390533_P_NODE_1660_length_1303_cov_4.723892_g1384_i0 | PRJNA390533 | 1660 | 1303 | 4.723892 | 61.55231276 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1218 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g1384 | i0 | 95.91 | 174.637759017652 | 758 | 19 | 97 | 7 | 346 | 1092 | 2851963 | 2851207 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 227553 | 1218 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 26854012 | 26854012 | PRJNA390533_P_NODE_42581_length_170_cov_2.412214_g41554_i0 | PRJNA390533 | 42581 | 170 | 2.412214 | 4.1007638 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 114 | 1.17e-27 | NR | HEX8549948.1 | 2800791 | g41554 | i0 | 87.5 | 0.988235294117647 | 56 | 7 | 98.8 | 0 | 169 | 2 | 109 | 164 | HEX8549948.1 site-specific DNA-methyltransferase [Abditibacteriaceae bacterium] | diamond | 168 | 114 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 28780438 | 28780438 | PRJNA390533_P_NODE_24307_length_321_cov_1.170213_g23281_i0 | PRJNA390533 | 24307 | 321 | 1.170213 | 3.75638373 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 120 | 3.65e-29 | NR | HEX8549948.1 | 2800791 | g23281 | i0 | 55 | 1.01869158878505 | 109 | 46 | 99.1 | 1 | 318 | 1 | 912 | 1020 | HEX8549948.1 site-specific DNA-methyltransferase [Abditibacteriaceae bacterium] | diamond | 327 | 120 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 32066687 | 32066687 | PRJNA390533_P_NODE_42958_length_169_cov_1.515385_g41931_i0 | PRJNA390533 | 42958 | 169 | 1.515385 | 2.56100065 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 90.1 | 2.83e-19 | NR | HEX8549948.1 | 2800791 | g41931 | i0 | 67.9 | 0.994082840236686 | 56 | 18 | 99.4 | 0 | 2 | 169 | 229 | 284 | HEX8549948.1 site-specific DNA-methyltransferase [Abditibacteriaceae bacterium] | diamond | 168 | 90.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae 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);;