RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB27957 · 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
1297640 1297640 PRJEB27957_P_NODE_18822_length_337_cov_1.722222_g18712_i0 PRJEB27957 18822 337 1.722222 5.80388814 Synechocystis sp. PCC 6714 1147 Bacteria Bacteria 52.8 0.032   NTclustered gi|662702554|gb|CP007542.1| 1147 g18712 i0 96.774 0.0919881305637982 31 1 9 0 96 126 3062126 3062156 Synechocystis sp. PCC 6714, complete genome blastn 31 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 6714
6401550 6401550 PRJEB27957_P_NODE_67906_length_205_cov_2.000000_g67796_i0 PRJEB27957 67906 205 2 4.1 Geminocystis sp. NIES-3708 1615909 Bacteria Bacteria 52.8 0.018   NTclustered gi|770466698|dbj|AP014815.1| 1615909 g67796 i0 100 0.136585365853659 28 0 14 0 132 159 85006 84979 Geminocystis sp. NIES-3708 DNA, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Geminocystis Geminocystis sp. NIES-3708
6401561 6401561 PRJEB27957_P_NODE_91986_length_179_cov_1.600000_g91876_i0 PRJEB27957 91986 179 1.6 2.864 Halomicronema hongdechloris 1209493 Bacteria Bacteria 54.7 0.004   NTclustered gi|1562104929|gb|CP021983.2| 1641165 g91876 i0 96.875 0.335195530726257 32 1 18 0 83 114 4967758 4967789 Halomicronema hongdechloris C2206 genome blastn 60 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Halomicronema Halomicronema hongdechloris
7675677 7675677 PRJEB27957_P_NODE_60187_length_216_cov_0.880240_g60077_i0 PRJEB27957 60187 216 0.88024 1.9013184 Synechococcus sp. CB0101 232348 Bacteria Bacteria 52.8 0.019   NTclustered gi|1626690261|gb|CP039373.1| 232348 g60077 i0 100 0.12962962962963 28 0 13 0 104 131 1687073 1687046 Synechococcus sp. CB0101 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CB0101
11501388 11501388 PRJEB27957_P_NODE_106890_length_168_cov_0.873950_g106780_i0 PRJEB27957 106890 168 0.87395 1.468236 Trichormus azollae 1164 Bacteria Bacteria 54.7 0.004   NTclustered gi|298231532|gb|CP002059.1| 551115 g106780 i0 100 0.172619047619048 29 0 17 0 78 106 2785823 2785851 'Nostoc azollae' 0708, complete genome blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Trichormus Trichormus azollae
11501391 11501391 PRJEB27957_P_NODE_109690_length_167_cov_0.881356_g109580_i0 PRJEB27957 109690 167 0.881356 1.47186452 Allocoleopsis franciscana 2886352 Bacteria Bacteria 52.8 0.014   NTclustered gi|428249989|gb|CP003630.1| 1173027 g109580 i0 96.875 0.191616766467066 32 0 19 1 48 78 3192395 3192364 Allocoleopsis franciscana PCC 7113, complete genome blastn 32 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis franciscana
17564710 17564710 PRJEB27957_P_NODE_81194_length_190_cov_1.475177_g81084_i0 PRJEB27957 81194 190 1.475177 2.8028363 Microcystis 1125 Bacteria Bacteria 158 3.36e-34   NTclustered gi|2041080097|dbj|AP024565.1| 1126 g81084 i0 82.447 64.6 188 26 98 5 4 190 5089531 5089712 Microcystis aeruginosa NIES-88 DNA, complete genome blastn 12274 158 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis aeruginosa
20424074 20424074 PRJEB27957_P_NODE_111877_length_166_cov_1.000000_g111767_i0 PRJEB27957 111877 166 1 1.66 Aliterella chasmolithica 2739056 Bacteria Bacteria 268 1.27e-67   NTclustered gi|1713066352|gb|MN243145.1| 2599943 g111767 i0 95.783 138.921686746988 166 7 100 0 1 166 2431 2266 Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 23061 268 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella chasmolithica

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