RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA515078 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
7489070 7489070 PRJNA515078_P_NODE_32686_length_154_cov_1.000000_g32453_i0 PRJNA515078 32686 154 1 1.54 Cyanophyceae 3028117 Bacteria Bacteria 100 4.45e-17   NTclustered gi|306980173|gb|CP002198.1| 497965 g32453 i0 83.636 38.5454545454545 110 15 70 3 1 108 4742728 4742836 Cyanothece sp. PCC 7822, complete genome blastn 5936 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Gloeothece Gloeothece verrucosa
13240779 13240779 PRJNA515078_P_NODE_29771_length_160_cov_1.268293_g29538_i0 PRJNA515078 29771 160 1.268293 2.0292688 Calothrix sp. 69.9 2598797 Bacteria Bacteria 54.7 0.004   NTclustered gi|1727424770|gb|MG595873.1| 2598797 g29538 i0 90.244 0.25625 41 3 25 1 61 100 207 167 Calothrix sp. 69.9 23S large subunit ribosomal RNA gene, partial sequence blastn 41 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. 69.9
16413626 16413626 PRJNA515078_P_NODE_22933_length_181_cov_1.555556_g22700_i0 PRJNA515078 22933 181 1.555556 2.81555636 Limnospira 2596745 Bacteria Bacteria 335 1.36e-87   NTclustered gi|585302946|emb|FO818640.1| 376219 g22700 i0 100 180.552486187845 181 0 100 0 1 181 811922 811742 Arthrospira sp. str. PCC 8005 chromosome, complete genome blastn 32680 335 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira indica
17064057 17064057 PRJNA515078_P_NODE_17874_length_206_cov_1.384615_g17641_i0 PRJNA515078 17874 206 1.384615 2.8523069 Nostoc sp. NIES-4103 2005458 Bacteria Bacteria 56.5 0.001   NTclustered gi|1210228378|dbj|AP018288.1| 2005458 g17641 i0 100 0.145631067961165 30 0 15 0 13 42 823932 823903 Nostoc sp. NIES-4103 DNA, nearly complete genome blastn 30 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. NIES-4103
18338523 18338523 PRJNA515078_P_NODE_24115_length_177_cov_1.114286_g23882_i0 PRJNA515078 24115 177 1.114286 1.97228622 uncultured cyanobacterium 1211 Bacteria Bacteria 211 2.33e-50   NTclustered gi|171263038|gb|EU432339.1| 1211 g23882 i0 88.571 100.039548022599 175 18 99 1 1 175 344 172 Uncultured cyanobacterium clone Fuku4-SW-Pi15 16S ribosomal RNA gene, partial sequence blastn 17707 211 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
18962566 18962566 PRJNA515078_P_NODE_18975_length_199_cov_1.697531_g18742_i0 PRJNA515078 18975 199 1.697531 3.37808669 Limnospira 2596745 Bacteria Bacteria 366 5.43e-97   NTclustered gi|585302946|emb|FO818640.1| 376219 g18742 i0 100 105.603015075377 198 0 99 0 2 199 813744 813547 Arthrospira sp. str. PCC 8005 chromosome, complete genome blastn 21015 366 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira indica

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