RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA891846" 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

  • PRJNA891846 · 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
2518679 2518679 PRJNA891846_P_NODE_22282_length_323_cov_1.432000_g22063_i0 PRJNA891846 22282 323 1.432 4.62536 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 462 1.18e-125   NTclustered gi|695467811|ref|XM_009541420.1| 67593 g22063 i0 92.401 86.0061919504644 329 17 100 6 1 323 341 15 Phytophthora sojae hypothetical protein mRNA blastn 27780 462 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
4695704 4695704 PRJNA891846_P_NODE_35964_length_253_cov_1.283333_g35744_i0 PRJNA891846 35964 253 1.283333 3.24683249 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 217 7.689999999999999e-52   NTclustered gi|695381515|ref|XM_009518817.1| 67593 g35744 i0 82.47 14.3122529644269 251 40 98 3 5 253 495 247 Phytophthora sojae hypothetical protein mRNA blastn 3621 217 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
21268682 21268682 PRJNA891846_P_NODE_14357_length_400_cov_1.162080_g14138_i0 PRJNA891846 14357 400 1.16208 4.64832 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 195 6.02e-45   NTclustered gi|695434857|ref|XM_009533226.1| 67593 g14138 i0 80.723 5.9475 249 48 62 0 140 388 88 336 Phytophthora sojae hypothetical protein mRNA blastn 2379 195 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
21645277 21645277 PRJNA891846_P_NODE_32977_length_266_cov_1.341969_g32758_i0 PRJNA891846 32977 266 1.341969 3.56963754 Pythium 4797 SAR_Eukaryotes SAR_Eukaryotes 486 5.629999999999999e-133   NTclustered gi|505574761|gb|AY598625.2| 82937 g32758 i0 99.624 99.6691729323308 266 1 100 0 1 266 2597 2862 Pythium graminicola strain CBS 327.62 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 26512 486 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium graminicola

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