RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_clade = "eukaryote SCGC"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • eukaryote SCGC · 2 ✖

bioproject 1

  • PRJNA630162 · 2 ✖

analysis 1

  • blastn · 2 ✖

tax_phylum 0

tax_kingdom 0

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
602143 602143 PRJNA630162_P_NODE_31161_length_323_cov_3.576642_g29639_i0 PRJNA630162 31161 323 3.576642 11.55255366 eukaryote SCGC AAA074-C16 1010495 Root_unresolved Root_unresolved 311 4.53e-80   NTclustered gi|336111305|gb|JF488758.1| 1010495 g29639 i0 84.858 63.953560371517 317 38 97 9 12 323 2 313 Eukaryote SCGC AAA074-C16 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 20657 311 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA074-C16
12630281 12630281 PRJNA630162_P_NODE_138410_length_167_cov_1.644068_g136887_i0 PRJNA630162 138410 167 1.644068 2.74559356 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 165 1.72e-36   NTclustered gi|336111309|gb|JF488762.1| 1010461 g136887 i0 84.94 72.9700598802395 166 21 98 4 1 163 711 547 Eukaryote SCGC AAA071-M11 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 12186 165 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA071-M11

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