contig_metadata
21 rows where bioproject = "PRJNA1196384", tax_clade = "Sar" and tax_phylum = "Oomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1597311 | 1597311 | PRJNA1196384_S_NODE_5062_length_181_cov_1.555556_g4998_i0 | PRJNA1196384 | 5062 | 181 | 1.555556 | 2.81555636 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 2.23e-12 | NR | KAJ8578052.1 | 4785 | g4998 | i0 | 72.9 | 2.35359116022099 | 48 | 12 | 77.9 | 1 | 40 | 180 | 117 | 164 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 426 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2873473 | 2873473 | PRJNA1196384_S_NODE_443_length_554_cov_5.576402_g382_i0 | PRJNA1196384 | 443 | 554 | 5.576402 | 30.89326708 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.6300000000000003e-79 | NR | CCA22399.1 | 890382 | g382 | i0 | 67.9 | 26.1606498194946 | 184 | 59 | 99.6 | 0 | 1 | 552 | 9 | 192 | CCA22399.1 40S ribosomal protein S82 putative [Albugo laibachii Nc14] | diamond | 14493 | 244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 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 | ||
| 4149592 | 4149592 | PRJNA1196384_S_NODE_2324_length_254_cov_2.792627_g2260_i0 | PRJNA1196384 | 2324 | 254 | 2.792627 | 7.09327258 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 2.31e-40 | NR | DAZ97987.1 | 4803 | g2260 | i0 | 79.8 | 24.8031496062992 | 84 | 17 | 99.2 | 0 | 254 | 3 | 34 | 117 | DAZ97987.1 TPA: hypothetical protein N0F65_005145 [Lagenidium giganteum] | diamond | 6300 | 142 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 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 | ||
| 27767634 | 27767634 | PRJNA1196384_S_NODE_6904_length_161_cov_1.282258_g6840_i0 | PRJNA1196384 | 6904 | 161 | 1.282258 | 2.06443538 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 3.52e-12 | NR | TYZ58477.1 | 1485010 | g6840 | i0 | 58.5 | 0.987577639751553 | 53 | 22 | 98.8 | 0 | 2 | 160 | 105 | 157 | TYZ58477.1 hypothetical protein PybrP1_007995 [[Pythium] brassicae (nom. inval.)] | diamond | 159 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 28544376 | 28544376 | PRJNA1196384_S_NODE_767_length_436_cov_5.358396_g703_i0 | PRJNA1196384 | 767 | 436 | 5.358396 | 23.36260656 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 3.96e-49 | NR | KAE9027413.1 | 129364 | g703 | i0 | 70 | 6.48853211009174 | 120 | 34 | 81.2 | 1 | 30 | 383 | 31 | 150 | KAE9027413.1 hypothetical protein PR001_g11976 [Phytophthora rubi] | diamond | 2829 | 165 | 0.993939393939394 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora rubi | ||
| 28639072 | 28639072 | PRJNA1196384_S_NODE_2247_length_259_cov_1.031532_g2183_i0 | PRJNA1196384 | 2247 | 259 | 1.031532 | 2.67166788 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 2.07e-14 | NR | KUF91740.1 | 4792 | g2183 | i0 | 58 | 9.25482625482626 | 69 | 26 | 76.4 | 2 | 257 | 60 | 46 | 114 | KUF91740.1 hypothetical protein AM588_10004643 [Phytophthora nicotianae] | diamond | 2397 | 73.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28840833 | 28840833 | PRJNA1196384_S_NODE_6388_length_165_cov_3.140625_g6324_i0 | PRJNA1196384 | 6388 | 165 | 3.140625 | 5.18203125 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 1.49e-7 | NR | OQR84622.1 | 1202772 | g6324 | i0 | 55.6 | 0.981818181818182 | 54 | 22 | 98.2 | 1 | 163 | 2 | 120 | 171 | OQR84622.1 40S ribosomal protein S8-2 [Achlya hypogyna] | diamond | 162 | 55.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 30376225 | 30376225 | PRJNA1196384_S_NODE_4252_length_193_cov_3.711538_g4188_i0 | PRJNA1196384 | 4252 | 193 | 3.711538 | 7.16326834 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 2.54e-9 | NR | XP_067822443.1 | 4779 | g4188 | i0 | 59.3 | 8.39378238341969 | 54 | 20 | 80.8 | 1 | 157 | 2 | 15 | 68 | XP_067822443.1 hypothetical protein CCR75_003781 [Bremia lactucae] | diamond | 1620 | 60.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 31589643 | 31589643 | PRJNA1196384_S_NODE_3416_length_212_cov_2.171429_g3352_i0 | PRJNA1196384 | 3416 | 212 | 2.171429 | 4.60342948 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0166 | NR | OWZ04411.1 | 4795 | g3352 | i0 | 34.6 | 1.44339622641509 | 52 | 32 | 70.8 | 1 | 205 | 56 | 122 | 173 | OWZ04411.1 hypothetical protein PHMEG_00023695 [Phytophthora megakarya] | diamond | 306 | 42.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya |
Advanced export
JSON shape: default, array, newline-delimited
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);;