RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA951412" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA951412 · 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
2210148 2210148 PRJNA951412_P_NODE_8302_length_204_cov_4.694656_g8217_i0 PRJNA951412 8302 204 4.694656 9.57709824 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 200 6.01e-47   NTclustered gi|695433088|ref|XM_009532804.1| 67593 g8217 i0 84.577 7.19607843137255 201 31 99 0 4 204 224 424 Phytophthora sojae hypothetical protein mRNA blastn 1468 200 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
4763161 4763161 PRJNA951412_P_NODE_3524_length_265_cov_1.614583_g3439_i0 PRJNA951412 3524 265 1.614583 4.27864495 Phytophthora cambivora 53983 SAR_Eukaryotes SAR_Eukaryotes 254 6.19e-63   NTclustered gi|156987041|gb|EU080554.1| 53983 g3439 i0 85.306 90.1584905660377 245 36 92 0 8 252 883 1127 Phytophthora cambivora isolate PD_00043(P0592) heat shock protein 90 (HSP90) gene, partial cds blastn 23892 254 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cambivora
21336897 21336897 PRJNA951412_P_NODE_5197_length_249_cov_0.886364_g5112_i0 PRJNA951412 5197 249 0.886364 2.20704636 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 196 9.84e-46   NTclustered gi|2795061008|ref|XM_067940276.1| 4785 g5112 i0 82.589 38.0240963855422 224 37 90 2 27 249 429 207 Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA blastn 9468 196 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
21665093 21665093 PRJNA951412_P_NODE_4777_length_250_cov_1.548023_g4692_i0 PRJNA951412 4777 250 1.548023 3.8700575 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 137 6.08e-28   NTclustered gi|23394393|gb|AF424661.1| 4787 g4692 i0 80.791 7.464 177 33 71 1 70 246 146 321 Phytophthora infestans clone MY-10-D-12 cystathionine beta-synthase mRNA, complete cds blastn 1866 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans

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