contig_metadata
6 rows where bioproject = "PRJNA609258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1147333 | 1147333 | PRJNA609258_P_NODE_30961_length_335_cov_1.870229_g30576_i0 | PRJNA609258 | 30961 | 335 | 1.870229 | 6.26526715 | Arthronema | 241432 | Bacteria | Bacteria | 619 | 6.91e-173 | NTclustered | gi|664803861|gb|KM019974.1| | 241439 | g30576 | i0 | 100 | 100.731343283582 | 335 | 0 | 100 | 0 | 1 | 335 | 512 | 846 | Arthronema africanum SAG 12.89 16S ribosomal RNA gene, partial sequence | blastn | 33745 | 619 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Leptolyngbyales | Leptolyngbyaceae | Arthronema | Arthronema africanum | |
| 4415451 | 4415451 | PRJNA609258_P_NODE_54404_length_248_cov_0.891429_g54019_i0 | PRJNA609258 | 54404 | 248 | 0.891429 | 2.21074392 | Cylindrospermopsis | 77021 | Bacteria | Bacteria | 52.8 | 1.19e-5 | NR | WP_218773708.1 | 77022 | g54019 | i0 | 39 | 3.95564516129032 | 82 | 45 | 96.8 | 2 | 7 | 246 | 448 | 526 | WP_218773708.1 beta strand repeat-containing protein [Cylindrospermopsis raciborskii] | diamond | 981 | 53.1 | 0.994350282485876 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Aphanizomenonaceae | Cylindrospermopsis | Cylindrospermopsis raciborskii | |
| 10791023 | 10791023 | PRJNA609258_P_NODE_24809_length_379_cov_0.866013_g24425_i0 | PRJNA609258 | 24809 | 379 | 0.866013 | 3.28218927 | uncultured Chroococcidiopsis sp. | 259957 | Bacteria | Bacteria | 494 | 4.99e-135 | NTclustered | gi|225696254|gb|FJ805921.1| | 259957 | g24425 | i0 | 90.86 | 107.071240105541 | 372 | 29 | 98 | 4 | 2 | 371 | 3103 | 2735 | Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 40580 | 494 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcidiopsidales | Chroococcidiopsidaceae | Chroococcidiopsis | uncultured Chroococcidiopsis sp. | |
| 15890341 | 15890341 | PRJNA609258_P_NODE_40753_length_287_cov_1.144860_g40368_i0 | PRJNA609258 | 40753 | 287 | 1.14486 | 3.2857482 | Scytonema hofmannii | 34078 | Bacteria | Bacteria | 453 | 6.23e-123 | NTclustered | gi|146740650|emb|AM709637.1| | 128403 | g40368 | i0 | 95.139 | 191.376306620209 | 288 | 13 | 100 | 1 | 1 | 287 | 2693 | 2406 | Scytonema hofmanni PCC 7110 partial ribosomal RNA operon, strain PCC 7110 | blastn | 54925 | 453 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Scytonemataceae | Scytonema | Scytonema hofmannii | |
| 18998664 | 18998664 | PRJNA609258_P_NODE_2815_length_1113_cov_1.704808_g2596_i0 | PRJNA609258 | 2815 | 1113 | 1.704808 | 18.97451304 | Cyanophyceae | 3028117 | Bacteria | Bacteria | 1520 | 0 | NTclustered | gi|225696255|gb|FJ805922.1| | 259957 | g2596 | i0 | 91.413 | 176.274034141959 | 1118 | 82 | 100 | 11 | 1 | 1113 | 1859 | 2967 | Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 196193 | 1520 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcidiopsidales | Chroococcidiopsidaceae | Chroococcidiopsis | uncultured Chroococcidiopsis sp. | |
| 30648605 | 30648605 | PRJNA609258_P_NODE_32573_length_326_cov_1.233202_g32188_i0 | PRJNA609258 | 32573 | 326 | 1.233202 | 4.02023852 | Anabaenopsis elenkinii | 156213 | Bacteria | Bacteria | 43.5 | 0.0476 | NR | WP_200989542.1 | 156213 | g32188 | i0 | 32 | 0.690184049079755 | 75 | 45 | 66.3 | 3 | 35 | 250 | 252 | 323 | WP_200989542.1 fatty acid desaturase [Anabaenopsis elenkinii] | diamond | 225 | 43.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nodulariaceae | Anabaenopsis | Anabaenopsis elenkinii |
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);;