RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA883229 · 8 ✖

analysis 1

  • blastn · 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
860065 860065 PRJNA883229_P_NODE_7401_length_269_cov_0.801020_g7355_i0 PRJNA883229 7401 269 0.80102 2.1547438 Cyanobium usitatum 2304190 Bacteria Bacteria 383 7.69e-102   NTclustered gi|2638501482|emb|OY986431.1| 2116684 g7355 i0 92.537 15.4832713754647 268 18 99 2 3 269 2142965 2143231 Cyanobium usitatum str. Tous isolate KAC_108 genome assembly, chromosome: 1 blastn 4165 383 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium usitatum
4688328 4688328 PRJNA883229_P_NODE_15004_length_244_cov_0.912281_g14958_i0 PRJNA883229 15004 244 0.912281 2.22596564 Synechococcus sp. CBW1108 1353147 Bacteria Bacteria 62.1 3.66e-5   NTclustered gi|1940487417|gb|CP060395.1| 1353147 g14958 i0 86.207 0.237704918032787 58 6 23 2 188 244 2212723 2212779 Synechococcus sp. CBW1108 chromosome, complete genome blastn 58 62.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CBW1108
16162592 16162592 PRJNA883229_P_NODE_11093_length_250_cov_0.881356_g11047_i0 PRJNA883229 11093 250 0.881356 2.20339 Synechococcus sp. PROS-U-1 1400866 Bacteria Bacteria 283 7.379999999999999e-72   NTclustered gi|1895800440|gb|CP047951.1| 1400866 g11047 i0 87.2 61.168 250 30 99 2 2 250 1849877 1850125 Synechococcus sp. PROS-U-1 chromosome, complete genome blastn 15292 283 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. PROS-U-1
18711282 18711282 PRJNA883229_P_NODE_13655_length_246_cov_0.901734_g13609_i0 PRJNA883229 13655 246 0.901734 2.21826564 Pleurocapsa sp. FMAR1 3040204 Bacteria Bacteria 429 8.789999999999998e-116   NTclustered gi|2621703423|emb|OY762512.1| 3040204 g13609 i0 98.374 174.630081300813 246 1 100 1 1 246 3669514 3669756 Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1 blastn 42959 429 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. FMAR1
20367403 20367403 PRJNA883229_P_NODE_14036_length_245_cov_0.906977_g13990_i0 PRJNA883229 14036 245 0.906977 2.22209365 Synechococcus 1129 Bacteria Bacteria 243 1.22e-59   NTclustered gi|1940477070|gb|CP060398.1| 1353134 g13990 i0 84.8 9.04897959183674 250 28 100 7 1 245 578140 577896 Synechococcus sp. CBW1002 chromosome, complete genome blastn 2217 243 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CBW1002
21261895 21261895 PRJNA883229_P_NODE_1417_length_516_cov_21.925508_g1371_i0 PRJNA883229 1417 516 21.925508 113.13562128 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 713 0   NTclustered gi|225696191|gb|FJ805858.1| 259957 g1371 i0 92.43 134.837209302326 502 35 97 3 1 500 2104 1604 Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 69576 713 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
21643230 21643230 PRJNA883229_P_NODE_11157_length_250_cov_0.881356_g11111_i0 PRJNA883229 11157 250 0.881356 2.20339 Synechococcales 1890424 Bacteria Bacteria 200 7.639999999999999e-47   NTclustered gi|427344508|gb|CP003495.1| 292564 g11111 i0 86.667 9.688 180 24 72 0 21 200 1476627 1476806 Cyanobium gracile PCC 6307, complete genome blastn 2422 200 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium gracile
25086021 25086021 PRJNA883229_P_NODE_14620_length_245_cov_0.906977_g14574_i0 PRJNA883229 14620 245 0.906977 2.22209365 Cyanobium sp. NS01 261284 Bacteria Bacteria 300 7.15e-77   NTclustered gi|1895767613|gb|CP047940.1| 261284 g14574 i0 88.889 0.991836734693878 243 27 99 0 1 243 2621178 2620936 Cyanobium sp. NS01 chromosome, complete genome blastn 243 300 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. NS01

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