RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB29441 · 8 ✖

analysis 1

  • diamond · 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
6404786 6404786 PRJEB29441_P_NODE_31286_length_187_cov_1.478261_g30845_i0 PRJEB29441 31286 187 1.478261 2.76434807 Cyanophyceae 3028117 Bacteria Bacteria 104 5.13e-26   NR WP_334726191.1 1180 g30845 i0 96.1 4.09090909090909 51 2 81.8 0 185 33 90 140 WP_334726191.1 manganese catalase family protein [Nostoc sp.] diamond 765 105 0.990476190476191 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
27152729 27152729 PRJEB29441_P_NODE_41982_length_165_cov_0.879310_g41541_i0 PRJEB29441 41982 165 0.87931 1.4508615 Cyanophyceae 3028117 Bacteria Bacteria 42 0.0151   NR WP_035992714.1 1229172 g41541 i0 100 1.6 22 0 40 0 68 3 1 22 WP_035992714.1 phage holin family protein [Leptolyngbya sp. KIOST-1] diamond 264 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. KIOST-1
27823168 27823168 PRJEB29441_P_NODE_45584_length_162_cov_0.902655_g45143_i0 PRJEB29441 45584 162 0.902655 1.4623011 Leptolyngbya sp. CCNP13 47254 Bacteria Bacteria 100 1.18e-24   NR WP_323349933.1 3110255 g45143 i0 88.9 1 54 6 100 0 162 1 10 63 WP_323349933.1 general stress protein [Leptolyngbya sp. CCNP1308] diamond 162 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. CCNP1308
29111126 29111126 PRJEB29441_P_NODE_18428_length_250_cov_1.348259_g17987_i0 PRJEB29441 18428 250 1.348259 3.3706475 Crocosphaera 263510 Bacteria Bacteria 76.3 5.21e-16   NR EAM52380.1 165597 g17987 i0 61 4.176 59 17 70.8 1 248 72 35 87 EAM52380.1 xenobiotic reductase B [Crocosphaera watsonii WH 8501] diamond 1044 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera watsonii
31076019 31076019 PRJEB29441_P_NODE_47275_length_161_cov_0.910714_g46834_i0 PRJEB29441 47275 161 0.910714 1.46624954 Nodosilinea sp. LEGE 2497642 Bacteria Bacteria 107 1.23e-26   NR WP_228052409.1 2777970 g46834 i0 96.2 7.90062111801242 53 2 98.8 0 159 1 190 242 WP_228052409.1 M23 family metallopeptidase [Nodosilinea sp. LEGE 07298] diamond 1272 107 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Nodosilinea Nodosilinea sp. LEGE 07298
31676620 31676620 PRJEB29441_P_NODE_39437_length_167_cov_0.864407_g38996_i0 PRJEB29441 39437 167 0.864407 1.44355969 Allocoleopsis sp. 3088169 Bacteria Bacteria 57 1.19e-7   NR HEY9703711.1 3088169 g38996 i0 45.5 0.988023952095808 55 30 98.8 0 2 166 45 99 HEY9703711.1 hypothetical protein [Allocoleopsis sp.] diamond 165 57 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis sp.
32309805 32309805 PRJEB29441_P_NODE_30959_length_188_cov_1.467626_g30518_i0 PRJEB29441 30959 188 1.467626 2.75913688 Gloeocapsa sp. DLM2.Bin57 2480214 Bacteria Bacteria 94.7 8.76e-21   NR TVQ47685.1 2480214 g30518 i0 78.7 15.5904255319149 61 13 97.3 0 185 3 718 778 TVQ47685.1 MAG: glutamate synthase large subunit [Gloeocapsa sp. DLM2.Bin57] diamond 2931 94.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. DLM2.Bin57
32688456 32688456 PRJEB29441_P_NODE_41580_length_165_cov_0.879310_g41139_i0 PRJEB29441 41580 165 0.87931 1.4508615 filamentous cyanobacterium CCP5 2107701 Bacteria Bacteria 55.8 1.78e-7   NR PSN10382.1 2107701 g41139 i0 93.1 0.527272727272727 29 2 52.7 0 75 161 1 29 PSN10382.1 hypothetical protein C7271_26085 [filamentous cyanobacterium CCP5] diamond 87 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         filamentous cyanobacterium CCP5

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