RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB39643 · 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
5159760 5159760 PRJEB39643_P_NODE_134305_length_247_cov_0.885057_g134112_i0 PRJEB39643 134305 247 0.885057 2.18609079 Cyanobacterium sp. DS4 2878255 Bacteria Bacteria 52.8 0.022   NTclustered gi|2667402313|gb|CP084098.1| 2878255 g134112 i0 100 0.11336032388664 28 0 11 0 195 222 4185989 4186016 Cyanobacterium sp. Dongsha4 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium sp. DS4
7367042 7367042 PRJEB39643_P_NODE_36266_length_310_cov_2.713080_g36073_i0 PRJEB39643 36266 310 2.71308 8.410548 root 1 Root_unresolved Root_unresolved 270 7.339999999999999e-68   NTclustered gi|406654542|gb|JX463420.1| 1211 g36073 i0 99.329 165.464516129032 149 1 96 0 161 309 405 257 Uncultured cyanobacterium clone SD-92 16S ribosomal RNA gene, partial sequence blastn 51294 270 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
11192856 11192856 PRJEB39643_P_NODE_39809_length_297_cov_5.687500_g39616_i0 PRJEB39643 39809 297 5.6875 16.891875 root 1 Root_unresolved Root_unresolved 523 4.8599999999999986e-144   NTclustered gi|225420981|gb|FJ774032.1| 1211 g39616 i0 98.973 109.498316498316 292 3 98 0 6 297 426 135 Uncultured cyanobacterium clone CYAVE50 16S ribosomal RNA gene, partial sequence blastn 32521 525 0.996190476190476 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
16634222 16634222 PRJEB39643_P_NODE_129254_length_248_cov_2.640000_g129061_i0 PRJEB39643 129254 248 2.64 6.5472 Geminocystis sp. NIES-3709 1617448 Bacteria Bacteria 52.8 0.022   NTclustered gi|770470343|dbj|AP014821.1| 1617448 g129061 i0 100 0.112903225806452 28 0 11 0 2 29 763786 763813 Geminocystis sp. NIES-3709 DNA, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Geminocystis Geminocystis sp. NIES-3709
20116037 20116037 PRJEB39643_P_NODE_42636_length_290_cov_1.419355_g42443_i0 PRJEB39643 42636 290 1.419355 4.1161295 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 60.2 1.6e-4   NTclustered gi|2395771017|gb|CP066886.2| 147317 g42443 i0 100 29.851724137931 32 0 11 0 165 196 3349041 3349072 Arthrospira sp. PCC 9108 chromosome, complete genome blastn 8657 60.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Arthrospira Arthrospira sp. PCC 9108

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