RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB7366" 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 · 4 ✖

bioproject 1

  • PRJEB7366 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
2685326 2685326 PRJEB7366_P_NODE_21243_length_164_cov_1.682171_g20809_i0 PRJEB7366 21243 164 1.682171 2.75876044 uncultured Cyanobacterium sp. 751952 Bacteria Bacteria 287 3.45e-73   NTclustered gi|371534702|gb|JQ003547.1| 751952 g20809 i0 98.171 97.1280487804878 164 3 100 0 1 164 440 277 Uncultured Cyanobacterium sp. isolate DGGE gel band 5 16S ribosomal RNA gene, partial sequence blastn 15929 287 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium uncultured Cyanobacterium sp.
9062526 9062526 PRJEB7366_P_NODE_19448_length_173_cov_1.311594_g19014_i0 PRJEB7366 19448 173 1.311594 2.26905762 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 315 1.68e-81   NTclustered gi|453199515|gb|JQ997495.1| 259957 g19014 i0 99.422 169.300578034682 173 1 100 0 1 173 187 359 Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 29289 315 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
19260863 19260863 PRJEB7366_P_NODE_5896_length_367_cov_2.771084_g5463_i0 PRJEB7366 5896 367 2.771084 10.16987828 Dolichospermum sp. UHCC 0315A 1914871 Bacteria Bacteria 82.4 4.45e-11   NTclustered gi|1731522919|gb|CP043056.1| 1914871 g5463 i0 86.486 8.35422343324251 74 10 20 0 134 207 2228239 2228166 Dolichospermum sp. UHCC 0315A chromosome, complete genome blastn 3066 82.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp. UHCC 0315A
20536137 20536137 PRJEB7366_P_NODE_15497_length_198_cov_1.625767_g15063_i0 PRJEB7366 15497 198 1.625767 3.21901866 Kalymmatonema hyalinum 119533 Bacteria Bacteria 322 1.18e-83   NTclustered gi|1280084619|gb|MF574181.1| 119533 g15063 i0 95.96 188.80303030303 198 8 100 0 1 198 5110 4913 Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence blastn 37383 322 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Kalymmatonema Kalymmatonema hyalinum

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