RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA914897 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1251042 1251042 PRJNA914897_P_NODE_42941_length_238_cov_2.024242_g42517_i0 PRJNA914897 42941 238 2.024242 4.81769596 Albugo 65356 SAR_Eukaryotes SAR_Eukaryotes 110 1.25e-19   NTclustered gi|325180343|emb|FR824051.1| 890382 g42517 i0 89.655 7.03361344537815 87 8 37 1 22 108 90833 90748 Albugo laibachii Nc14, genomic contig CONTIG_6_NC14_v4_250275_231 blastn 1674 110 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
5998040 5998040 PRJNA914897_P_NODE_18545_length_399_cov_1.374233_g18123_i0 PRJNA914897 18545 399 1.374233 5.48318967 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 381 4.289999999999999e-101   NTclustered gi|695434207|ref|XM_009533074.1| 67593 g18123 i0 85.598 50.7994987468672 368 47 91 6 3 367 365 1 Phytophthora sojae hypothetical protein partial mRNA blastn 20269 381 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
5998290 5998290 PRJNA914897_P_NODE_685_length_1890_cov_4.209686_g597_i0 PRJNA914897 685 1890 4.209686 79.5630654 Plasmopara halstedii 4781 SAR_Eukaryotes SAR_Eukaryotes 128 3.15e-24   NTclustered gi|1378171397|ref|XM_024720156.1| 4781 g597 i0 79.365 2.43015873015873 189 34 10 4 783 969 2692 2877 Plasmopara halstedii aminophospholipid translocase (PHALS_06804), partial mRNA blastn 4593 128 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
6355086 6355086 PRJNA914897_P_NODE_41645_length_243_cov_0.882353_g41221_i0 PRJNA914897 41645 243 0.882353 2.14411779 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.68e-8   NTclustered gi|698813385|ref|XM_009841420.1| 112090 g41221 i0 97.619 29.4567901234568 42 1 17 0 62 103 8 49 Aphanomyces astaci hypothetical protein mRNA blastn 7158 73.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
11454790 11454790 PRJNA914897_P_NODE_33949_length_266_cov_0.896373_g33525_i0 PRJNA914897 33949 266 0.896373 2.38435218 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 148 3.02e-31   NTclustered gi|325053448|dbj|AB512835.1| 643144 g33525 i0 94.737 40.3684210526316 95 5 36 0 2 96 1192 1286 Pythium takayamanum gene for beta-tubulin, partial cds, strain: NBRC 104224 blastn 10738 148 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium takayamanum
13648543 13648543 PRJNA914897_P_NODE_34631_length_261_cov_1.638298_g34207_i0 PRJNA914897 34631 261 1.638298 4.27595778 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 209 1.33e-49   NTclustered gi|301098279|ref|XM_002898187.1| 403677 g34207 i0 86.458 3.61685823754789 192 24 73 2 1 190 1257 1448 Phytophthora infestans T30-4 cysteine desulfurase 1, mitochondrial precursor (PITG_15057), mRNA blastn 944 209 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
22572009 22572009 PRJNA914897_P_NODE_32638_length_273_cov_1.205000_g32214_i0 PRJNA914897 32638 273 1.205 3.28965 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 283 8.159999999999999e-72   NTclustered gi|695434305|ref|XM_009533098.1| 67593 g32214 i0 85.821 96.3333333333333 268 36 98 2 7 273 884 618 Phytophthora sojae hypothetical protein partial mRNA blastn 26299 283 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae

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