RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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

  • PRJNA1123309 · 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
6656471 6656471 PRJNA1123309_P_NODE_65846_length_242_cov_0.923077_g65466_i0 PRJNA1123309 65846 242 0.923077 2.23384634 uncultured Rivularia sp. 447564 Bacteria Bacteria 54.7 0.006   NTclustered gi|2621703013|emb|OY762007.1| 447564 g65466 i0 100 0.119834710743802 29 0 12 0 65 93 662926 662954 MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia uncultured Rivularia sp.
11756635 11756635 PRJNA1123309_P_NODE_21170_length_345_cov_3.117647_g20791_i0 PRJNA1123309 21170 345 3.117647 10.75588215 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 488 2.0999999999999993e-133   NTclustered gi|225696260|gb|FJ805927.1| 259957 g20791 i0 94.888 137.713043478261 313 14 90 2 16 327 3479 3168 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 47511 488 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
11757086 11757086 PRJNA1123309_P_NODE_610_length_1502_cov_5.058083_g475_i0 PRJNA1123309 610 1502 5.058083 75.97240666 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 2231 0   NTclustered gi|225696258|gb|FJ805925.1| 259957 g475 i0 93.679 104.896138482024 1503 75 99 12 7 1501 3109 1619 Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 157554 2231 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
15581452 15581452 PRJNA1123309_P_NODE_6533_length_578_cov_2.223762_g6175_i0 PRJNA1123309 6533 578 2.223762 12.85334436 Stanieria cyanosphaera 102116 Bacteria Bacteria 446 2.24e-120   NTclustered gi|17976754|emb|AJ252121.1| 111780 g6175 i0 80.911 31.1851211072664 571 104 98 4 4 570 819 250 Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating) blastn 18025 446 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
20679530 20679530 PRJNA1123309_P_NODE_18737_length_363_cov_1.527586_g18358_i0 PRJNA1123309 18737 363 1.527586 5.54513718 Nostoc sp. C052 2576902 Bacteria Bacteria 65.8 4.42e-6   NTclustered gi|1866639087|gb|CP040272.1| 2576902 g18358 i0 93.182 100.537190082645 44 3 12 0 27 70 566460 566417 Nostoc sp. C052 chromosome, complete genome blastn 36495 65.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. C052
25255377 25255377 PRJNA1123309_P_NODE_49960_length_251_cov_1.707865_g49580_i0 PRJNA1123309 49960 251 1.707865 4.28674115 Nostoc 1177 Bacteria Bacteria 390 4.239999999999999e-104   NTclustered gi|1468713264|gb|CP031941.1| 446679 g49580 i0 96.218 288.733067729084 238 9 95 0 14 251 56714 56477 Nostoc sphaeroides strain Kutzing En chromosome, complete genome blastn 72472 390 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sphaeroides

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