RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA533114 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
11320636 11320636 PRJNA533114_P_NODE_59929_length_308_cov_0.982979_g59677_i0 PRJNA533114 59929 308 0.982979 3.02757532 Oscillatoriales 1150 Bacteria Bacteria 52.8 0.029   NTclustered gi|2395771017|gb|CP066886.2| 147317 g59677 i0 100 0.272727272727273 28 0 9 0 190 217 3500943 3500916 Arthrospira sp. PCC 9108 chromosome, complete genome blastn 84 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Arthrospira Arthrospira sp. PCC 9108
15807185 15807185 PRJNA533114_P_NODE_119753_length_241_cov_0.916667_g119501_i0 PRJNA533114 119753 241 0.916667 2.20916747 Nostoc sp. PCC 7107 317936 Bacteria Bacteria 52.8 0.022   NTclustered gi|427357970|gb|CP003548.1| 317936 g119501 i0 100 0.116182572614108 28 0 12 0 114 141 3508219 3508192 Nostoc sp. PCC 7107, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. PCC 7107
16420366 16420366 PRJNA533114_P_NODE_47573_length_340_cov_3.333333_g47321_i0 PRJNA533114 47573 340 3.333333 11.3333322 Synechococcus 1129 Bacteria Bacteria 52.8 0.032   NTclustered gi|852371558|gb|CP011941.1| 32052 g47321 i0 100 0.164705882352941 28 0 8 0 251 278 634755 634782 Synechococcus sp. WH 8020 chromosome blastn 56 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. WH 8020

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