RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA393181 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
5514157 5514157 PRJNA393181_S_NODE_26385_length_222_cov_2.135135_g26279_i0 PRJNA393181 26385 222 2.135135 4.7399997 Gloeobacter violaceus 33072 Bacteria Bacteria 56.5 0.002   NTclustered gi|37508091|dbj|BA000045.2| 251221 g26279 i0 94.444 0.162162162162162 36 2 16 0 123 158 1334813 1334848 Gloeobacter violaceus PCC 7421 DNA, complete genome blastn 36 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gloeobacterales Gloeobacteraceae Gloeobacter Gloeobacter violaceus
7456626 7456626 PRJNA393181_S_NODE_47986_length_150_cov_1.035398_g47880_i0 PRJNA393181 47986 150 1.035398 1.553097 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 126 7.1e-25   NTclustered gi|37508091|dbj|BA000045.2| 251221 g47880 i0 88.462 6.29333333333333 104 12 69 0 41 144 1540845 1540948 Gloeobacter violaceus PCC 7421 DNA, complete genome blastn 944 126 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gloeobacterales Gloeobacteraceae Gloeobacter Gloeobacter violaceus
8063455 8063455 PRJNA393181_S_NODE_16887_length_291_cov_1.677165_g16781_i0 PRJNA393181 16887 291 1.677165 4.88055015 Nostoc sp. UHCC 0870 2914041 Bacteria Bacteria 58.4 5.79e-4   NTclustered gi|2190707562|gb|CP091913.1| 2914041 g16781 i0 97.059 0.979381443298969 34 1 12 0 155 188 2124141 2124174 Nostoc sp. UHCC 0870 chromosome, complete genome blastn 285 58.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UHCC 0870
10006522 10006522 PRJNA393181_S_NODE_25248_length_228_cov_2.628272_g25142_i0 PRJNA393181 25248 228 2.628272 5.99246016 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 52.8 0.02   NTclustered gi|2589057682|gb|CP135918.1| 2597771 g25142 i0 96.774 0.394736842105263 31 1 14 0 196 226 6960975 6960945 Fischerella sp. JS2 chromosome, complete genome blastn 90 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella sp. JS2
13164835 13164835 PRJNA393181_S_NODE_9391_length_393_cov_3.474719_g9285_i0 PRJNA393181 9391 393 3.474719 13.65564567 Nostoc sp. TCL26-01 2576904 Bacteria Bacteria 56.5 0.003   NTclustered gi|1866654106|gb|CP040297.1| 2576904 g9285 i0 96.97 0.155216284987277 33 1 8 0 69 101 2824096 2824064 Nostoc sp. TCL26-01 chromosome, complete genome blastn 61 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. TCL26-01
19536226 19536226 PRJNA393181_S_NODE_25476_length_227_cov_2.036842_g25370_i0 PRJNA393181 25476 227 2.036842 4.62363134 Synechococcus sp. CBW1004 1353136 Bacteria Bacteria 54.7 0.006   NTclustered gi|1940480550|gb|CP060397.1| 1353136 g25370 i0 96.875 0.140969162995595 32 1 14 0 195 226 1015880 1015911 Synechococcus sp. CBW1004 chromosome, complete genome blastn 32 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CBW1004
19536682 19536682 PRJNA393181_S_NODE_42956_length_161_cov_1.782258_g42850_i0 PRJNA393181 42956 161 1.782258 2.86943538 Halotia branconii 1620816 Bacteria Bacteria 56.5 0.001   NTclustered gi|2500982325|gb|CP124543.1| 1539056 g42850 i0 100 3.49068322981366 30 0 19 0 78 107 1859575 1859604 Halotia branconii CENA392 chromosome, complete genome blastn 562 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Halotia Halotia branconii

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