RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA492406" 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

  • PRJNA492406 · 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
8105973 8105973 PRJNA492406_P_NODE_8547_length_417_cov_2.444767_g8248_i0 PRJNA492406 8547 417 2.444767 10.19467839 Plectonema terebrans 272135 Bacteria Bacteria 230 1.7299999999999996e-55   NTclustered gi|46409900|gb|AY584525.1| 272137 g8248 i0 86.047 241.868105515588 215 28 51 2 202 415 1027 814 Plectonema terebrans CCAP 1463/4 23S ribosomal RNA gene, partial sequence blastn 100859 230 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Plectonema Plectonema terebrans
14481163 14481163 PRJNA492406_P_NODE_24892_length_259_cov_1.516129_g24593_i0 PRJNA492406 24892 259 1.516129 3.92677411 Leptolyngbya boryana 1184 Bacteria Bacteria 416 7.259999999999999e-112   NTclustered gi|46409901|gb|AY584526.1| 272134 g24593 i0 95.769 199.953667953668 260 8 100 3 1 259 870 613 Leptolyngbya boryana PCC 6306 23S ribosomal RNA gene, partial sequence blastn 51788 416 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya boryana
20854345 20854345 PRJNA492406_P_NODE_32757_length_229_cov_2.410256_g32458_i0 PRJNA492406 32757 229 2.410256 5.51948624 Plectolyngbya koreana 3016458 Bacteria Bacteria 370 4.97e-98   NTclustered gi|2106138547|gb|OK382087.1| 2880695 g32458 i0 95.671 155.187772925764 231 8 100 1 1 229 2206 1976 Plectolyngbya koreana FBCC-A1478 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 35538 370 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Plectolyngbya Plectolyngbya koreana
24051113 24051113 PRJNA492406_P_NODE_20159_length_283_cov_1.071429_g19860_i0 PRJNA492406 20159 283 1.071429 3.03214407 root 1 Root_unresolved Root_unresolved 130 1.17e-25   NTclustered gi|229563072|gb|FJ901831.1| 1211 g19860 i0 81.098 48.3038869257951 164 30 58 1 106 269 944 1106 Uncultured cyanobacterium clone LPSB70 16S ribosomal RNA gene, partial sequence blastn 13670 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium

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