RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA811714" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 6 ✖

bioproject 1

  • PRJNA811714 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
2085106 2085106 PRJNA811714_P_NODE_26662_length_228_cov_2.980645_g26469_i0 PRJNA811714 26662 228 2.980645 6.7958706 Chroococcidiopsis sp. CCNUC1 2653189 Bacteria Bacteria 422 1.34e-113   NTclustered gi|2245124533|gb|CP097480.1| 2653189 g26469 i0 100 2 228 0 100 0 1 228 3760609 3760836 Chroococcidiopsis sp. CCNUC1 chromosome, complete genome blastn 456 422 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCNUC1
4637859 4637859 PRJNA811714_P_NODE_25884_length_230_cov_2.942675_g25691_i0 PRJNA811714 25884 230 2.942675 6.7681525 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 316 6.599999999999998e-82   NTclustered gi|225696185|gb|FJ805852.1| 259957 g25691 i0 91.775 187.534782608696 231 13 99 6 1 228 1703 1930 Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 43133 316 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
6327703 6327703 PRJNA811714_P_NODE_28745_length_220_cov_4.612245_g28552_i0 PRJNA811714 28745 220 4.612245 10.146939 Aliterella 1827277 Bacteria Bacteria 390 3.629999999999999e-104   NTclustered gi|312985528|gb|HQ189039.1| 1211 g28552 i0 98.636 100.154545454545 220 3 100 0 1 220 1034 1253 Uncultured cyanobacterium clone B108207C 16S ribosomal RNA gene, partial sequence blastn 22034 390 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
10152246 10152246 PRJNA811714_P_NODE_26188_length_229_cov_4.153846_g25995_i0 PRJNA811714 26188 229 4.153846 9.51230734 Cyanophyceae 3028117 Bacteria Bacteria 424 3.76e-114   NTclustered gi|146141982|gb|EF522486.1| 1211 g25995 i0 100 99.9956331877729 229 0 100 0 1 229 65 293 Uncultured cyanobacterium clone OCSS038 16S ribosomal RNA gene, partial sequence blastn 22899 424 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
12288506 12288506 PRJNA811714_P_NODE_18330_length_253_cov_2.566667_g18137_i0 PRJNA811714 18330 253 2.566667 6.49366751 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 274 4.5e-69   NTclustered gi|225696260|gb|FJ805927.1| 259957 g18137 i0 86.381 117.719367588933 257 27 100 7 1 253 2998 3250 Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 29783 274 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
22901233 22901233 PRJNA811714_P_NODE_16378_length_261_cov_4.914894_g16185_i0 PRJNA811714 16378 261 4.914894 12.82787334 Cyanophyceae 3028117 Bacteria Bacteria 333 7.589999999999999e-87   NTclustered gi|222138150|gb|FJ589716.1| 588587 g16185 i0 89.734 172.662835249042 263 23 100 3 1 261 2200 2460 Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 45065 333 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsopsis Gloeocapsopsis crepidinum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;