contig_metadata
12 rows where bioproject = "PRJNA474426" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27392472 | 27392472 | PRJNA474426_P_NODE_13183_length_289_cov_1.900000_g12978_i0 | PRJNA474426 | 13183 | 289 | 1.9 | 5.491 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 55.1 | 2.65e-6 | NR | MFN8373876.1 | 2052143 | g12978 | i0 | 71.9 | 0.332179930795848 | 32 | 9 | 33.2 | 0 | 289 | 194 | 288 | 319 | MFN8373876.1 NAD(P)H-quinone oxidoreductase [Anaerolineae bacterium] | diamond | 96 | 55.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28513531 | 28513531 | PRJNA474426_P_NODE_16807_length_249_cov_2.060000_g16602_i0 | PRJNA474426 | 16807 | 249 | 2.06 | 5.1294 | Kouleothrix | 186475 | Bacteria | Bacteria | 87 | 9.51e-18 | NR | HEX2910407.1 | 2448782 | g16602 | i0 | 48.6 | 2.67469879518072 | 74 | 37 | 88 | 1 | 10 | 228 | 234 | 307 | HEX2910407.1 hypothetical protein [Chloroflexia bacterium] | diamond | 666 | 87 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 30392661 | 30392661 | PRJNA474426_P_NODE_8273_length_375_cov_6.024540_g8068_i0 | PRJNA474426 | 8273 | 375 | 6.02454 | 22.592025 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 122 | 2.75e-29 | NR | HLE92716.1 | 2073117 | g8068 | i0 | 53.4 | 0.928 | 116 | 54 | 92.8 | 0 | 361 | 14 | 172 | 287 | HLE92716.1 phage portal protein [Anaerolineales bacterium] | diamond | 348 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31103294 | 31103294 | PRJNA474426_P_NODE_20135_length_223_cov_1.022989_g19930_i0 | PRJNA474426 | 20135 | 223 | 1.022989 | 2.28126547 | FCB group | 1783270 | Bacteria | Bacteria | 85.5 | 2.59e-17 | NR | MAT41911.1 | 2024896 | g19930 | i0 | 67.1 | 3.59192825112108 | 70 | 21 | 94.2 | 2 | 14 | 223 | 480 | 547 | MAT41911.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 801 | 85.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 31213283 | 31213283 | PRJNA474426_P_NODE_13915_length_280_cov_1.800866_g13710_i0 | PRJNA474426 | 13915 | 280 | 1.800866 | 5.0424248 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 99.8 | 6.18e-23 | NR | MCK6584251.1 | 2073117 | g13710 | i0 | 93.5 | 3.05357142857143 | 46 | 3 | 49.3 | 0 | 268 | 131 | 253 | 298 | MCK6584251.1 phosphotransferase family protein [Anaerolineales bacterium] | diamond | 855 | 99.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31593459 | 31593459 | PRJNA474426_P_NODE_12376_length_300_cov_1.844622_g12171_i0 | PRJNA474426 | 12376 | 300 | 1.844622 | 5.533866 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 176 | 3.9e-50 | NR | RPI93045.1 | 2026724 | g12171 | i0 | 85.7 | 0.98 | 98 | 14 | 98 | 0 | 299 | 6 | 63 | 160 | RPI93045.1 MAG: hypothetical protein EHM40_11050 [Chloroflexota bacterium] | diamond | 294 | 176 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31624840 | 31624840 | PRJNA474426_P_NODE_9756_length_344_cov_2.159322_g9551_i0 | PRJNA474426 | 9756 | 344 | 2.159322 | 7.42806768 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.2 | 0.00709 | NR | MBI2757063.1 | 2026724 | g9551 | i0 | 34.1 | 0.741279069767442 | 85 | 33 | 74.1 | 2 | 3 | 257 | 656 | 717 | MBI2757063.1 hypothetical protein [Chloroflexota bacterium] | diamond | 255 | 46.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31688074 | 31688074 | PRJNA474426_P_NODE_13397_length_286_cov_2.459916_g13192_i0 | PRJNA474426 | 13397 | 286 | 2.459916 | 7.03535976 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 130 | 1.22e-33 | NR | MBT9158925.1 | 2026724 | g13192 | i0 | 66.3 | 1.91958041958042 | 92 | 30 | 95.5 | 1 | 14 | 286 | 151 | 242 | MBT9158925.1 hypothetical protein [Chloroflexota bacterium] | diamond | 549 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32321233 | 32321233 | PRJNA474426_P_NODE_36139_length_162_cov_2.902655_g35934_i0 | PRJNA474426 | 36139 | 162 | 2.902655 | 4.7023011 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 57 | 1.13e-7 | NR | MCZ2127444.1 | 2073117 | g35934 | i0 | 54 | 0.925925925925926 | 50 | 22 | 92.6 | 1 | 12 | 161 | 55 | 103 | MCZ2127444.1 hypothetical protein [Anaerolineales bacterium] | diamond | 150 | 57 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32384159 | 32384159 | PRJNA474426_P_NODE_23619_length_202_cov_1.542484_g23414_i0 | PRJNA474426 | 23619 | 202 | 1.542484 | 3.11581768 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 49.7 | 6.7e-5 | NR | HEY2979921.1 | 2073117 | g23414 | i0 | 58.1 | 0.638613861386139 | 43 | 14 | 63.9 | 1 | 9 | 137 | 230 | 268 | HEY2979921.1 PD-(D/E)XK nuclease family protein [Anaerolineales bacterium] | diamond | 129 | 49.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32479307 | 32479307 | PRJNA474426_P_NODE_26119_length_190_cov_1.631206_g25914_i0 | PRJNA474426 | 26119 | 190 | 1.631206 | 3.0992914 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 65.9 | 1.24e-10 | NR | HEX9075367.1 | 2052143 | g25914 | i0 | 48.3 | 1.84736842105263 | 58 | 30 | 91.6 | 0 | 6 | 179 | 354 | 411 | HEX9075367.1 LCP family protein [Anaerolineae bacterium] | diamond | 351 | 65.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32794147 | 32794147 | PRJNA474426_P_NODE_14460_length_273_cov_2.593750_g14255_i0 | PRJNA474426 | 14460 | 273 | 2.59375 | 7.0809375 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 56.2 | 3.72e-7 | NR | MCC6458038.1 | 2614250 | g14255 | i0 | 46.4 | 0.615384615384615 | 56 | 26 | 57.1 | 1 | 11 | 166 | 42 | 97 | MCC6458038.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 168 | 56.2 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae 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);;