RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA674050" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 5 ✖

bioproject 1

  • PRJNA674050 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
644270 644270 PRJNA674050_P_NODE_41601_length_224_cov_7.059603_g41398_i0 PRJNA674050 41601 224 7.059603 15.81351072 Leptolyngbya sp. 7M 2812896 Bacteria Bacteria 233 6.62e-57   NTclustered gi|2028908486|gb|CP070897.1| 2812896 g41398 i0 86.636 407.558035714286 217 22 95 5 12 224 4829680 4829467 Leptolyngbya sp. 7M chromosome blastn 91293 233 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. 7M
9572875 9572875 PRJNA674050_P_NODE_40988_length_232_cov_5.849057_g40785_i0 PRJNA674050 40988 232 5.849057 13.56981224 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 237 5.34e-58   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g40785 i0 85.169 56.8448275862069 236 29 100 6 1 232 3681153 3680920 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 13188 237 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
10847606 10847606 PRJNA674050_P_NODE_19469_length_260_cov_1.582888_g19266_i0 PRJNA674050 19469 260 1.582888 4.1155088 Stanieria cyanosphaera 102116 Bacteria Bacteria 248 2.8199999999999997e-61   NTclustered gi|17976754|emb|AJ252121.1| 111780 g19266 i0 83.908 52.0153846153846 261 40 100 2 1 260 741 482 Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating) blastn 13524 248 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
18495598 18495598 PRJNA674050_P_NODE_10835_length_294_cov_85.755656_g10632_i0 PRJNA674050 10835 294 85.755656 252.12162864 Anabaena sp. YBS01 2490939 Bacteria Bacteria 496 1.05e-135   NTclustered gi|1772285456|gb|CP034058.1| 2490939 g10632 i0 99.27 146.969387755102 274 2 93 0 1 274 5575426 5575153 Anabaena sp. YBS01 chromosome, complete genome blastn 43209 496 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. YBS01
19770939 19770939 PRJNA674050_P_NODE_33876_length_245_cov_0.906977_g33673_i0 PRJNA674050 33876 245 0.906977 2.22209365 Synechococcus sp. LA31 2741953 Bacteria Bacteria 294 3.33e-75   NTclustered gi|2045437416|gb|CP075523.1| 2741953 g33673 i0 88.571 2.96734693877551 245 24 99 3 3 245 1269834 1269592 Synechococcus sp. LA31 chromosome blastn 727 294 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. LA31

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