RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 2 ✖

tax_clade 1

bioproject 1

  • PRJEB14803 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
6399631 6399631 PRJEB14803_P_NODE_35086_length_179_cov_2.861111_g34620_i0 PRJEB14803 35086 179 2.861111 5.12138869 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 111 2.47e-20   NTclustered gi|224003048|ref|XM_002291160.1| 296543 g34620 i0 89.773 0.491620111731844 88 7 49 2 93 179 98 12 Thalassiosira pseudonana CCMP1335 Cdc37 protein (Cdc37), partial mRNA blastn 88 111 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
18837625 18837625 PRJEB14803_P_NODE_45315_length_154_cov_1.327731_g44849_i0 PRJEB14803 45315 154 1.327731 2.04470574 Halamphora 1242273 SAR_Eukaryotes SAR_Eukaryotes 93.5 7.45e-15   NTclustered gi|1549146930|gb|MH810165.1| 2133758 g44849 i0 84.158 2.53246753246753 101 11 65 5 1 100 6384 6480 Halamphora calidilacuna voucher JPK8506-AMPH118 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 390 93.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna

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