RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1196384" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA1196384 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
3593589 3593589 PRJNA1196384_S_NODE_4563_length_188_cov_1.781457_g4499_i0 PRJNA1196384 4563 188 1.781457 3.34913916 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 272 1.1399999999999998e-68   NTclustered gi|300518487|gb|GU133413.1| 82933 g4499 i0 93.011 98.9255319148936 186 13 99 0 1 186 739 554 Pythium chamaihyphon strain PPRI8625 beta-tubulin gene, partial cds blastn 18598 272 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Phytopythium Phytopythium chamaehyphon
4149590 4149590 PRJNA1196384_S_NODE_2004_length_276_cov_3.092050_g1940_i0 PRJNA1196384 2004 276 3.09205 8.534058 Phytophthora taxon Oaksoil 544548 SAR_Eukaryotes SAR_Eukaryotes 268 2.3099999999999994e-67   NTclustered gi|193230739|gb|EU797495.1| 544548 g1940 i0 84.42 80.1884057971015 276 37 99 5 2 274 375 647 Phytophthora sp. oaksoil/Poland elongation factor gene, partial cds blastn 22132 268 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora taxon Oaksoil
4149658 4149658 PRJNA1196384_S_NODE_6444_length_165_cov_1.218750_g6380_i0 PRJNA1196384 6444 165 1.21875 2.0109375 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 97.1 6.28e-16   NTclustered gi|675168882|ref|XM_008895078.1| 761204 g6380 i0 80.645 19.2121212121212 124 24 75 0 3 126 587 464 Phytophthora parasitica INRA-310 60S ribosomal protein mRNA blastn 3170 97.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
7975996 7975996 PRJNA1196384_S_NODE_1587_length_310_cov_2.113553_g1523_i0 PRJNA1196384 1587 310 2.113553 6.5520143 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 185 2.7399999999999998e-42   NTclustered gi|675204844|ref|XM_008913059.1| 761204 g1523 i0 77.564 20.7677419354839 312 66 100 3 1 310 158 467 Phytophthora parasitica INRA-310 ribosomal protein S4 mRNA blastn 6438 185 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
7976118 7976118 PRJNA1196384_S_NODE_8547_length_150_cov_0.911504_g8483_i0 PRJNA1196384 8547 150 0.911504 1.367256 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 117 4.27e-22   NTclustered gi|2795045055|ref|XM_067937582.1| 4785 g8483 i0 90.805 12.2266666666667 87 8 58 0 64 150 224 310 Phytophthora cinnamomi ribosomal protein L34 (IUM83_12935), partial mRNA blastn 1834 117 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
9971266 9971266 PRJNA1196384_S_NODE_3068_length_222_cov_1.989189_g3004_i0 PRJNA1196384 3068 222 1.989189 4.41599958 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 320 4.89e-83   NTclustered gi|156988391|gb|EU080863.1| 4794 g3004 i0 92.76 95.3693693693694 221 16 99 0 2 222 12 232 Phytophthora drechsleri isolate PD_01308(PDA1188) beta-tubulin gene, partial cds blastn 21172 320 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora drechsleri
14351681 14351681 PRJNA1196384_S_NODE_3272_length_216_cov_1.072626_g3208_i0 PRJNA1196384 3272 216 1.072626 2.31687216 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 150 6.57e-32   NTclustered gi|698776983|ref|XM_009823234.1| 112090 g3208 i0 82.941 13.6851851851852 170 25 78 4 47 214 365 198 Aphanomyces astaci hypothetical protein mRNA blastn 2956 150 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
18174328 18174328 PRJNA1196384_S_NODE_5615_length_174_cov_1.350365_g5551_i0 PRJNA1196384 5615 174 1.350365 2.3496351 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 99 1.85e-16   NTclustered gi|2795025757|ref|XM_067925552.1| 4785 g5551 i0 80.882 2.39080459770115 136 16 75 8 34 164 885 1015 Phytophthora cinnamomi 60S ribosomal protein L4 (IUM83_01682), partial mRNA blastn 416 99 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
21445059 21445059 PRJNA1196384_S_NODE_1377_length_331_cov_1.588435_g1313_i0 PRJNA1196384 1377 331 1.588435 5.25771985 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 117 1.09e-21   NTclustered gi|813164367|ref|XM_012347854.1| 695850 g1313 i0 83.871 0.858006042296072 124 18 37 2 116 238 341 219 Saprolegnia parasitica CBS 223.65 60S ribosomal protein L37-A mRNA blastn 284 117 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
21999526 21999526 PRJNA1196384_S_NODE_7758_length_155_cov_0.991525_g7694_i0 PRJNA1196384 7758 155 0.991525 1.53686375 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 62.1 2.12e-5   NTclustered gi|813110819|ref|XM_012339621.1| 695850 g7694 i0 80 1.46451612903226 85 15 54 2 13 96 229 146 Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA blastn 227 62.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
24548796 24548796 PRJNA1196384_S_NODE_4420_length_190_cov_2.444444_g4356_i0 PRJNA1196384 4420 190 2.444444 4.6444436 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 139 1.22e-28   NTclustered gi|695446713|ref|XM_009536260.1| 67593 g4356 i0 86.992 61.6473684210526 123 16 65 0 67 189 744 622 Phytophthora sojae hypothetical protein partial mRNA blastn 11713 139 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
24548830 24548830 PRJNA1196384_S_NODE_6420_length_165_cov_1.679688_g6356_i0 PRJNA1196384 6420 165 1.679688 2.7714852 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 182 1.6899999999999996e-41   NTclustered gi|669138411|ref|XM_008606552.1| 1156394 g6356 i0 86.667 95.5393939393939 165 21 99 1 2 165 1216 1052 Saprolegnia diclina VS20 ATP synthase subunit beta, mitochondrial mRNA blastn 15764 182 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina

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