RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA358009", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA358009 · 7 ✖

analysis 1

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
3623782 3623782 PRJNA358009_P_NODE_9803_length_183_cov_9.500000_g9734_i0 PRJNA358009 9803 183 9.5 17.385 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 289 1.0899999999999998e-73   NTclustered gi|505574793|gb|AY598663.2| 126846 g9734 i0 97.076 93.4426229508197 171 5 93 0 10 180 123 293 Phytopythium ostracodes strain CBS 768.73 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 17100 289 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Phytopythium Phytopythium ostracodes
4225354 4225354 PRJNA358009_P_NODE_10864_length_177_cov_3.726562_g10795_i0 PRJNA358009 10864 177 3.726562 6.59601474 Hyaloperonospora parasitica 123356 SAR_Eukaryotes SAR_Eukaryotes 302 1.34e-77   NTclustered gi|33520224|gb|AY273969.1| 123356 g10795 i0 98.817 95.9265536723164 169 2 95 0 4 172 72 240 Hyaloperonospora parasitica large subunit ribosomal RNA gene, partial sequence blastn 16979 302 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora parasitica
4900985 4900985 PRJNA358009_P_NODE_6664_length_326_cov_2.151625_g6601_i0 PRJNA358009 6664 326 2.151625 7.0142975 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 167 1.05e-36   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g6601 i0 98.925 8.79141104294479 93 1 55 0 8 100 2240 2148 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 2866 167 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
10001203 10001203 PRJNA358009_P_NODE_4928_length_327_cov_1.931655_g4865_i0 PRJNA358009 4928 327 1.931655 6.31651185 root 1 Root_unresolved Root_unresolved 180 1.35e-40   NTclustered gi|166044489|emb|CU367398.1| 100861 g4865 i0 99 31.9266055045872 100 1 44 0 1 100 237 138 Aphanomyces euteiches cDNA blastn 10440 180 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18924479 18924479 PRJNA358009_P_NODE_4455_length_327_cov_2.129496_g4392_i0 PRJNA358009 4455 327 2.129496 6.96345192 root 1 Root_unresolved Root_unresolved 174 6.29e-39   NTclustered gi|166046470|emb|CU367587.1| 100861 g4392 i0 98.98 39.9755351681957 98 0 58 1 228 324 617 714 Aphanomyces euteiches cDNA blastn 13072 174 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23350344 23350344 PRJNA358009_P_NODE_8419_length_197_cov_6.317568_g8350_i0 PRJNA358009 8419 197 6.317568 12.44560896 Pythium monospermum 92964 SAR_Eukaryotes SAR_Eukaryotes 333 5.44e-87   NTclustered gi|33520250|gb|AY273995.1| 92964 g8350 i0 98.421 91.3350253807107 190 2 96 1 7 196 28 216 Pythium monospermum large subunit ribosomal RNA gene, partial sequence blastn 17993 333 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium monospermum
25299263 25299263 PRJNA358009_P_NODE_7560_length_234_cov_7.194595_g7492_i0 PRJNA358009 7560 234 7.194595 16.8353523 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 433 6.41e-117   NTclustered gi|363498776|gb|JN662487.1| 120398 g7492 i0 100 93.4188034188034 234 0 100 0 1 234 609 376 Aphanomyces stellatus strain GF 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 21860 433 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus

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