RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA999747", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA999747 · 14 ✖

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
2549889 2549889 PRJNA999747_S_NODE_582_length_355_cov_129.145062_g550_i0 PRJNA999747 582 355 129.145062 458.4649701 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 606 5.72e-169   NTclustered gi|156986563|gb|EU079911.1| 129350 g550 i0 97.727 99.0985915492958 352 8 99 0 4 355 21 372 Phytophthora colocasiae isolate PD_00139(P6317) 28S ribosomal RNA gene, partial sequence blastn 35180 612 0.990196078431373 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora colocasiae
7358274 7358274 PRJNA999747_S_NODE_2946_length_181_cov_5.086667_g2914_i0 PRJNA999747 2946 181 5.086667 9.20686727 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 296 6.43e-76   NTclustered gi|695467755|ref|XM_009541406.1| 67593 g2914 i0 96.629 77.5138121546961 178 6 98 0 1 178 684 861 Phytophthora sojae hypothetical protein mRNA blastn 14030 296 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
10202833 10202833 PRJNA999747_S_NODE_1808_length_224_cov_15.471503_g1776_i0 PRJNA999747 1808 224 15.471503 34.65616672 Peronosporales 4776 SAR_Eukaryotes SAR_Eukaryotes 414 2.1999999999999996e-111   NTclustered gi|1238675774|gb|MF783088.1| 4784 g1776 i0 100 100 224 0 100 0 1 224 713 936 Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence blastn 22400 414 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
11183875 11183875 PRJNA999747_S_NODE_1169_length_276_cov_100.738776_g1137_i0 PRJNA999747 1169 276 100.738776 278.03902176 Peronospora violacea 162110 SAR_Eukaryotes SAR_Eukaryotes 475 1.2699999999999996e-129   NTclustered gi|23306502|gb|AY035485.1| 162110 g1137 i0 97.826 100.315217391304 276 5 100 1 1 276 241 515 Peronospora violacea isolate AR 191 large subunit ribosomal RNA gene, partial sequence blastn 27687 475 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora violacea
11477970 11477970 PRJNA999747_S_NODE_849_length_311_cov_43.453571_g817_i0 PRJNA999747 849 311 43.453571 135.14060581 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 507 5.16e-139   NTclustered gi|189084007|gb|BT031523.1| 4784 g817 i0 96.154 100.128617363344 312 8 99 2 4 311 1838 2149 Phytophthora capsici clone CBOT29-E20 mRNA sequence blastn 31140 507 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
15302075 15302075 PRJNA999747_S_NODE_1932_length_217_cov_9.709677_g1900_i0 PRJNA999747 1932 217 9.709677 21.06999909 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 385 1.66e-102   NTclustered gi|156986546|gb|EU079801.1| 4785 g1900 i0 98.618 100 217 3 100 0 1 217 1016 800 Phytophthora cinnamomi isolate PD_00125(P3232) 28S ribosomal RNA gene, partial sequence blastn 21700 385 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
15302097 15302097 PRJNA999747_S_NODE_3672_length_164_cov_7.864662_g3640_i0 PRJNA999747 3672 164 7.864662 12.89804568 Peronosporales 4776 SAR_Eukaryotes SAR_Eukaryotes 292 7.41e-75   NTclustered gi|324983146|gb|HQ161084.1| 4786 g3640 i0 99.379 98.1768292682927 161 1 98 0 4 164 588 748 Phytophthora cryptogea strain P10456 18S ribosomal RNA gene, partial sequence blastn 16101 292 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cryptogea
19125491 19125491 PRJNA999747_S_NODE_175_length_539_cov_88.173228_g149_i0 PRJNA999747 175 539 88.173228 475.25369892 Peronospora 70742 SAR_Eukaryotes SAR_Eukaryotes 937 0   NTclustered gi|1663822451|gb|MH730823.1| 162094 g149 i0 98.141 99.8237476808905 538 9 99 1 2 539 299 835 Peronospora hiemalis voucher GLM75690 28S ribosomal RNA gene, partial sequence blastn 53805 937 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora hiemalis
20107154 20107154 PRJNA999747_S_NODE_556_length_361_cov_6.509091_g524_i0 PRJNA999747 556 361 6.509091 23.49781851 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 111 5.57e-20   NTclustered gi|325194684|emb|FR825494.1| 890382 g524 i0 78.857 38.415512465374 175 30 48 7 3 174 32 202 Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 blastn 13868 111 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
20400550 20400550 PRJNA999747_S_NODE_2036_length_213_cov_4.450549_g2004_i0 PRJNA999747 2036 213 4.450549 9.47966937 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 383 5.8499999999999996e-102   NTclustered gi|403181174|gb|JN635096.1| 54510 g2004 i0 99.524 98.0469483568075 210 1 99 0 1 210 343 134 Phytophthora medicaginis isolate WPC7029A43 18S ribosomal RNA gene, partial sequence blastn 20884 383 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora medicaginis
22951892 22951892 PRJNA999747_S_NODE_1878_length_220_cov_4.232804_g1846_i0 PRJNA999747 1878 220 4.232804 9.3121688 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 372 1.32e-98   NTclustered gi|90655130|gb|DQ361251.1| 4784 g1846 i0 97.685 98.2090909090909 216 5 98 0 4 219 742 527 Phytophthora capsici large subunit ribosomal RNA gene, partial sequence blastn 21606 372 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
25206690 25206690 PRJNA999747_S_NODE_3320_length_172_cov_10.567376_g3288_i0 PRJNA999747 3320 172 10.567376 18.17588672 Phytophthora megasperma 4788 SAR_Eukaryotes SAR_Eukaryotes 307 2.79e-79   NTclustered gi|2440150|emb|X75631.1| 4788 g3288 i0 99.408 96.1162790697674 169 1 98 0 4 172 1527 1695 P.megasperma gene for 28S ribosomal RNA blastn 16532 307 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megasperma
30474827 30474827 PRJNA999747_S_NODE_4033_length_158_cov_1.543307_g4001_i0 PRJNA999747 4033 158 1.543307 2.43842506 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 69.3 4.89e-12   NR KAG9409221.1 112091 g4001 i0 79.1 4.1772151898734204 43 9 81.6 0 7 135 298 340 KAG9409221.1 hypothetical protein AC1031_019479 [Aphanomyces cochlioides] diamond 660 69.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
32655869 32655869 PRJNA999747_S_NODE_1600_length_238_cov_4.966184_g1568_i0 PRJNA999747 1600 238 4.966184 11.81951792 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.3 5.64e-14   NR KAL0585142.1 65357 g1568 i0 61 5.15546218487395 59 23 74.4 0 177 1 234 292 KAL0585142.1 hypothetical protein ABG067_005038 [Albugo candida] diamond 1227 76.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida

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