RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1200128" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 8 ✖

bioproject 1

  • PRJNA1200128 · 8 ✖
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
327011 327011 PRJNA1200128_S_NODE_23401_length_194_cov_1.834437_g23292_i0 PRJNA1200128 23401 194 1.834437 3.55880778 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 263 7.11e-66   NTclustered gi|225696216|gb|FJ805883.1| 259957 g23292 i0 91.282 83.2319587628866 195 14 99 3 3 194 1806 2000 Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 16147 263 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
10530866 10530866 PRJNA1200128_S_NODE_22349_length_197_cov_1.220779_g22240_i0 PRJNA1200128 22349 197 1.220779 2.40493463 Nostoc sp. UHCC 0702 2814655 Bacteria Bacteria 204 4.449999999999999e-48   NTclustered gi|1996588181|gb|CP071065.1| 2814655 g22240 i0 85.279 184.238578680203 197 29 100 0 1 197 570617 570813 Nostoc sp. UHCC 0702 chromosome, complete genome blastn 36295 204 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UHCC 0702
11247990 11247990 PRJNA1200128_S_NODE_14189_length_226_cov_1.644809_g14080_i0 PRJNA1200128 14189 226 1.644809 3.71726834 Oscillatoriales 1150 Bacteria Bacteria 412 8.01e-111   NTclustered gi|585302946|emb|FO818640.1| 376219 g14080 i0 99.558 176.955752212389 226 1 100 0 1 226 811834 811609 Arthrospira sp. str. PCC 8005 chromosome, complete genome blastn 39992 412 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira indica
15629876 15629876 PRJNA1200128_S_NODE_21493_length_199_cov_2.358974_g21384_i0 PRJNA1200128 21493 199 2.358974 4.69435826 Synechococcus sp. CB0101 232348 Bacteria Bacteria 52.8 0.017   NTclustered gi|1626690261|gb|CP039373.1| 232348 g21384 i0 100 0.14070351758794 28 0 14 0 71 98 1687046 1687073 Synechococcus sp. CB0101 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CB0101
27420499 27420499 PRJNA1200128_S_NODE_11763_length_240_cov_1.852792_g11654_i0 PRJNA1200128 11763 240 1.852792 4.4467008 Nostoc sp. XA 1180 Bacteria Bacteria 45.4 0.00399   NR WP_229558049.1 2780407 g11654 i0 51.5 1.175 33 16 41.3 0 80 178 62 94 WP_229558049.1 DUF3854 domain-containing protein [Nostoc sp. XA010] diamond 282 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. XA010
29535672 29535672 PRJNA1200128_S_NODE_8130_length_270_cov_1.096916_g8021_i0 PRJNA1200128 8130 270 1.096916 2.9616732 Pseudanabaenaceae cyanobacterium bins.39 2971805 Bacteria Bacteria 44.3 0.0146   NR MDX2256354.1 2971805 g8021 i0 34.5 0.966666666666667 87 47 85.6 3 30 260 167 253 MDX2256354.1 hypothetical protein [Pseudanabaenaceae cyanobacterium bins.39] diamond 261 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium bins.39
30799136 30799136 PRJNA1200128_S_NODE_30294_length_178_cov_1.533333_g30185_i0 PRJNA1200128 30294 178 1.533333 2.72933274 Crocosphaera sp. 2729996 Bacteria Bacteria 43.1 0.0113   NR MDJ0660714.1 2729996 g30185 i0 54.1 0.623595505617977 37 17 62.4 0 116 6 695 731 MDJ0660714.1 HEAT repeat domain-containing protein [Crocosphaera sp.] diamond 111 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera sp.
32444069 32444069 PRJNA1200128_S_NODE_8859_length_263_cov_1.386364_g8750_i0 PRJNA1200128 8859 263 1.386364 3.64613732 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 43.5 0.0234   NR MEZ0369900.1 2762020 g8750 i0 32 0.855513307984791 75 49 83.3 1 28 246 23 97 MEZ0369900.1 lysostaphin resistance A-like protein [Candidatus Sericytochromatia bacterium] diamond 225 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium

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