contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax_clade = "Cyanobacteriota/Melainabacteria group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 740733 | 740733 | PRJNA758770_S_NODE_29361_length_246_cov_0.901734_g29235_i0 | PRJNA758770 | 29361 | 246 | 0.901734 | 2.21826564 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 139 | 4.939999999999999e-37 | NR | MBT9546178.1 | 2762020 | g29235 | i0 | 79.3 | 1 | 82 | 17 | 100 | 0 | 1 | 246 | 340 | 421 | MBT9546178.1 mannose-1-phosphate guanylyltransferase/mannose-6-phosphate isomerase [Candidatus Sericytochromatia bacterium] | diamond | 246 | 139 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 28916057 | 28916057 | PRJNA758770_S_NODE_32428_length_242_cov_0.923077_g32302_i0 | PRJNA758770 | 32428 | 242 | 0.923077 | 2.23384634 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 147 | 2.5e-40 | NR | MBT9544550.1 | 2762020 | g32302 | i0 | 93.6 | 0.966942148760331 | 78 | 5 | 96.7 | 0 | 9 | 242 | 1 | 78 | MBT9544550.1 tetratricopeptide repeat protein [Candidatus Sericytochromatia bacterium] | diamond | 234 | 147 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 29200658 | 29200658 | PRJNA758770_S_NODE_25029_length_251_cov_0.876404_g24903_i0 | PRJNA758770 | 25029 | 251 | 0.876404 | 2.19977404 | Kamptonema cortianum | 2922243 | Bacteria | Bacteria | 147 | 1.35e-40 | NR | MDK3156905.1 | 2922243 | g24903 | i0 | 85.5 | 0.99203187250996006 | 83 | 12 | 99.2 | 0 | 251 | 3 | 116 | 198 | MDK3156905.1 beta-ketoacyl-ACP synthase II [Kamptonema cortianum] | diamond | 249 | 147 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Microcoleaceae | Kamptonema | Kamptonema cortianum | |
| 29484375 | 29484375 | PRJNA758770_S_NODE_28770_length_247_cov_0.890805_g28644_i0 | PRJNA758770 | 28770 | 247 | 0.890805 | 2.20028835 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 67.8 | 4.45e-11 | NR | MBT9548723.1 | 2762020 | g28644 | i0 | 78.9 | 0.461538461538462 | 38 | 8 | 46.2 | 0 | 1 | 114 | 287 | 324 | MBT9548723.1 UDP-glucose 4-epimerase GalE [Candidatus Sericytochromatia bacterium] | diamond | 114 | 67.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 30369513 | 30369513 | PRJNA758770_S_NODE_23632_length_253_cov_0.866667_g23506_i0 | PRJNA758770 | 23632 | 253 | 0.866667 | 2.19266751 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 156 | 2.71e-44 | NR | MBT9547113.1 | 2762020 | g23506 | i0 | 91.7 | 0.99604743083004 | 84 | 7 | 99.6 | 0 | 1 | 252 | 120 | 203 | MBT9547113.1 exonuclease SbcCD subunit D [Candidatus Sericytochromatia bacterium] | diamond | 252 | 156 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 30874551 | 30874551 | PRJNA758770_S_NODE_25974_length_250_cov_0.881356_g25848_i0 | PRJNA758770 | 25974 | 250 | 0.881356 | 2.20339 | Limnospira platensis | 118562 | Bacteria | Bacteria | 107 | 1e-27 | NR | MDV7395832.1 | 3080829 | g25848 | i0 | 59.8 | 0.984 | 82 | 33 | 98.4 | 0 | 250 | 5 | 1 | 82 | MDV7395832.1 tetratricopeptide repeat protein [Arthrospira platensis SPKY1] | diamond | 246 | 107 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Sirenicapillariaceae | Limnospira | Limnospira platensis | |
| 31126967 | 31126967 | PRJNA758770_S_NODE_30655_length_244_cov_0.912281_g30529_i0 | PRJNA758770 | 30655 | 244 | 0.912281 | 2.22596564 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 114 | 1.96e-27 | NR | MBT9546694.1 | 2762020 | g30529 | i0 | 69.6 | 0.971311475409836 | 79 | 24 | 97.1 | 0 | 7 | 243 | 67 | 145 | MBT9546694.1 VWA domain-containing protein [Candidatus Sericytochromatia bacterium] | diamond | 237 | 114 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 31538630 | 31538630 | PRJNA758770_S_NODE_32816_length_242_cov_0.923077_g32690_i0 | PRJNA758770 | 32816 | 242 | 0.923077 | 2.23384634 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 45.4 | 0.00395 | NR | MBT9546439.1 | 2762020 | g32690 | i0 | 82.1 | 0.347107438016529 | 28 | 5 | 34.7 | 0 | 84 | 1 | 1 | 28 | MBT9546439.1 transcription termination/antitermination protein NusA [Candidatus Sericytochromatia bacterium] | diamond | 84 | 45.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 32139569 | 32139569 | PRJNA758770_S_NODE_31578_length_243_cov_0.917647_g31452_i0 | PRJNA758770 | 31578 | 243 | 0.917647 | 2.22988221 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 111 | 1.86e-26 | NR | MBF2055079.1 | 2762020 | g31452 | i0 | 65.8 | 0.975308641975309 | 79 | 27 | 97.5 | 0 | 237 | 1 | 426 | 504 | MBF2055079.1 Mu transposase C-terminal domain-containing protein [Candidatus Sericytochromatia bacterium] | diamond | 237 | 111 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia 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);;