RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA788929 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
8422721 8422721 PRJNA788929_P_NODE_42787_length_240_cov_10.095808_g42126_i0 PRJNA788929 42787 240 10.095808 24.2299392 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 279 9.1e-71   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g42126 i0 89.862 96.6333333333333 217 22 90 0 24 240 48954 48738 Navicula incertata mitochondrion, complete genome blastn 23192 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
10973548 10973548 PRJNA788929_P_NODE_40849_length_244_cov_10.736842_g40188_i0 PRJNA788929 40849 244 10.736842 26.19789448 Halamphora americana 2305497 SAR_Eukaryotes SAR_Eukaryotes 366 6.92e-97   NTclustered gi|1549146931|gb|MH810166.1| 2305497 g40188 i0 96.396 73.7622950819672 222 8 91 0 1 222 10134 9913 Halamphora americana voucher JPK7977-AMPH100 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 17998 366 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora americana
21172149 21172149 PRJNA788929_P_NODE_47077_length_217_cov_4.555556_g46416_i0 PRJNA788929 47077 217 4.555556 9.88555652 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 182 2.34e-41   NTclustered gi|657012566|gb|KF302620.1| 2850 g46416 i0 88.742 71.7926267281106 151 13 69 4 67 216 764 617 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 15579 182 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23722439 23722439 PRJNA788929_P_NODE_47499_length_214_cov_5.943262_g46838_i0 PRJNA788929 47499 214 5.943262 12.71858068 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 124 3.94e-24   NTclustered gi|219129759|ref|XM_002185013.1| 556484 g46838 i0 91.209 6.58878504672897 91 8 43 0 43 133 391 481 Phaeodactylum tricornutum CCAP 1055/1 calmoduline (CaM1), mRNA blastn 1410 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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