RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1143173" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1143173 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
286286 286286 PRJNA1143173_P_NODE_31281_length_254_cov_3.088398_g31255_i0 PRJNA1143173 31281 254 3.088398 7.84453092 Allocoleopsis franciscana 2886352 Bacteria Bacteria 167 7.889999999999999e-37   NTclustered gi|428249989|gb|CP003630.1| 1173027 g31255 i0 87.248 0.586614173228346 149 16 57 1 4 149 667926 667778 Allocoleopsis franciscana PCC 7113, complete genome blastn 149 167 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis franciscana
5389303 5389303 PRJNA1143173_P_NODE_19905_length_287_cov_4.845794_g19879_i0 PRJNA1143173 19905 287 4.845794 13.90742878 Stenomitos frigidus 1886765 Bacteria Bacteria 182 3.24e-41   NTclustered gi|2814759481|gb|CP170648.1| 3070788 g19879 i0 81.057 0.790940766550523 227 43 79 0 61 287 4255979 4256205 MAG: Stenomitos frigidus ULC029 chromosome, complete genome blastn 227 182 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos frigidus
11765237 11765237 PRJNA1143173_P_NODE_42110_length_214_cov_4.567376_g42084_i0 PRJNA1143173 42110 214 4.567376 9.77418464 Calothrix sp. PCC 7716 2853227 Bacteria Bacteria 259 1.03e-64   NTclustered gi|2083844586|dbj|AP025018.1| 2853227 g42084 i0 93.182 0.822429906542056 176 12 82 0 1 176 5720117 5720292 Calothrix sp. PCC 7716 DNA, complete genome blastn 176 259 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 7716
17610364 17610364 PRJNA1143173_P_NODE_21194_length_283_cov_6.266667_g21168_i0 PRJNA1143173 21194 283 6.266667 17.73466761 Microseira 1609595 Bacteria Bacteria 484 2.1699999999999994e-132   NTclustered gi|1866773963|gb|MT733836.1| 2750792 g21168 i0 97.527 100.173144876325 283 7 100 0 1 283 432 714 Microseira sp. CHAB 4136.02-6 16S ribosomal RNA gene, partial sequence blastn 28349 484 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Microseira Microseira minor

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