RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA682774" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA682774 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
7043308 7043308 PRJNA682774_P_NODE_306_length_782_cov_2.165021_g281_i0 PRJNA682774 306 782 2.165021 16.93046422 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 640 1.32e-178   NTclustered gi|219111198|ref|XM_002177315.1| 556484 g281 i0 81.596 66.2340153452685 777 140 99 3 6 780 1570 795 Phaeodactylum tricornutum CCAP 1055/1 protein heat shock protein Hsp70 (HSP70A), mRNA blastn 51795 640 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
15203378 15203378 PRJNA682774_P_NODE_1612_length_348_cov_1.661818_g1583_i0 PRJNA682774 1612 348 1.661818 5.78312664 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 638 1.99e-178   NTclustered gi|1134785030|gb|KX575709.1| 3003 g1583 i0 99.713 100 348 1 100 0 1 348 696 1043 Bacillaria paxillifer isolate RVSN23 18S ribosomal RNA gene, partial sequence blastn 34800 643 0.992223950233281 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
18516729 18516729 PRJNA682774_P_NODE_2315_length_299_cov_1.172566_g2286_i0 PRJNA682774 2315 299 1.172566 3.50597234 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 525 1.3599999999999994e-144   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g2286 i0 98.328 96.9364548494983 299 5 100 0 1 299 3903 3605 Nitzschia reversa isolate AGSB0348 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 28984 525 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa

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