RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1073005" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 6 ✖

bioproject 1

  • PRJNA1073005 · 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
4844030 4844030 PRJNA1073005_P_NODE_7084_length_319_cov_1.731707_g6965_i0 PRJNA1073005 7084 319 1.731707 5.52414533 Acaryochloris 155977 Bacteria Bacteria 337 7.369999999999998e-88   NTclustered gi|2179753748|gb|CP071717.1| 2740837 g6965 i0 85.938 155.605015673981 320 39 100 6 1 319 1169215 1169529 Acaryochloris sp. 'Moss Beach' chromosome, complete genome blastn 49638 337 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Acaryochloridaceae Acaryochloris Acaryochloris sp. 'Moss Beach'
9114581 9114581 PRJNA1073005_P_NODE_4368_length_473_cov_1.820000_g4249_i0 PRJNA1073005 4368 473 1.82 8.6086 cyanobacterium NIES-36 2510787 Bacteria Bacteria 614 4.6799999999999985e-171   NTclustered gi|1566846291|dbj|LC455671.1| 2510787 g4249 i0 90.084 214.716701902748 474 45 100 2 1 473 19 491 Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence blastn 101561 614 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium NIES-36
12494833 12494833 PRJNA1073005_P_NODE_7570_length_299_cov_6.907080_g7451_i0 PRJNA1073005 7570 299 6.90708 20.6521692 root 1 Root_unresolved Root_unresolved 486 6.429999999999999e-133   NTclustered gi|353256004|gb|JN090916.1| 1211 g7451 i0 97.561 107.675585284281 287 2 94 1 5 286 663 377 Uncultured cyanobacterium clone D57C8 16S ribosomal RNA gene, partial sequence blastn 32195 486 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
20142390 20142390 PRJNA1073005_P_NODE_7456_length_303_cov_10.752174_g7337_i0 PRJNA1073005 7456 303 10.752174 32.57908722 Planktothrix 54304 Bacteria Bacteria 518 2.32e-142   NTclustered gi|1004530817|dbj|LC130611.1| 1211 g7337 i0 99.301 100.059405940594 286 2 94 0 14 299 315 600 Uncultured cyanobacterium gene for 16S ribosomal RNA, partial sequence, clone: wr_osc_04 blastn 30318 523 0.990439770554493 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
21417961 21417961 PRJNA1073005_P_NODE_3277_length_583_cov_1.207843_g3159_i0 PRJNA1073005 3277 583 1.207843 7.04172469 Oscillatoriales 1150 Bacteria Bacteria 885 0   NTclustered gi|1566846289|dbj|LC455669.1| 118562 g3159 i0 94.168 177.092624356775 583 30 100 2 1 583 691 1269 Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence blastn 103245 885 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
31733844 31733844 PRJNA1073005_P_NODE_8497_length_266_cov_0.974093_g8378_i0 PRJNA1073005 8497 266 0.974093 2.59108738 Cyanophyceae 3028117 Bacteria Bacteria 104 1.7799999999999994e-24   NR WP_193981278.1 767427 g8378 i0 60.9 24.5864661654135 87 32 98.1 1 266 6 53 137 WP_193981278.1 RRXRR domain-containing protein [[Phormidium] sp. LEGE 05292] diamond 6540 104 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Floridanema [Phormidium] sp. LEGE 05292

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