contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018748 | 2018748 | PRJNA763243_P_NODE_16222_length_385_cov_1.608974_g15877_i0 | PRJNA763243 | 16222 | 385 | 1.608974 | 6.1945499 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 5.98e-20 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g15877 | i0 | 83.2 | 24.8753246753247 | 125 | 17 | 32 | 4 | 257 | 380 | 41793 | 41672 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 9577 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 2480736 | 2480736 | PRJNA763243_P_NODE_5422_length_608_cov_522.652336_g5099_i0 | PRJNA763243 | 5422 | 608 | 522.652336 | 3177.72620288 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 1079 | 0 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g5099 | i0 | 98.843 | 99.6809210526316 | 605 | 7 | 99 | 0 | 4 | 608 | 72 | 676 | Aphanomyces euteiches cDNA | blastn | 60606 | 1079 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 4571252 | 4571252 | PRJNA763243_P_NODE_24064_length_328_cov_2.619608_g23718_i0 | PRJNA763243 | 24064 | 328 | 2.619608 | 8.59231424 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.72e-92 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g23718 | i0 | 86.462 | 50.2713414634146 | 325 | 38 | 98 | 6 | 4 | 325 | 324 | 3 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 16489 | 351 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5847540 | 5847540 | PRJNA763243_P_NODE_69605_length_222_cov_12.046980_g69259_i0 | PRJNA763243 | 69605 | 222 | 12.04698 | 26.7442956 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.32e-66 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g69259 | i0 | 88.837 | 97.3693693693694 | 215 | 24 | 97 | 0 | 3 | 217 | 251 | 37 | A.bisexualis gene for actin | blastn | 21616 | 265 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 5847660 | 5847660 | PRJNA763243_P_NODE_74965_length_198_cov_6.512000_g74619_i0 | PRJNA763243 | 74965 | 198 | 6.512 | 12.89376 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.81e-15 | NTclustered | gi|695462266|ref|XM_009540112.1| | 67593 | g74619 | i0 | 81.982 | 10.020202020202 | 111 | 20 | 56 | 0 | 88 | 198 | 174 | 64 | Phytophthora sojae hypothetical protein mRNA | blastn | 1984 | 95.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7121554 | 7121554 | PRJNA763243_P_NODE_20086_length_353_cov_1.375000_g19740_i0 | PRJNA763243 | 20086 | 353 | 1.375 | 4.85375 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|695395908|ref|XM_009523000.1| | 67593 | g19740 | i0 | 87.5 | 0.135977337110482 | 48 | 4 | 13 | 2 | 87 | 133 | 1420 | 1466 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 48 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7122542 | 7122542 | PRJNA763243_P_NODE_63566_length_241_cov_0.916667_g63220_i0 | PRJNA763243 | 63566 | 241 | 0.916667 | 2.20916747 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.63e-46 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g63220 | i0 | 82.805 | 69.7634854771784 | 221 | 38 | 92 | 0 | 4 | 224 | 48841 | 49061 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 16813 | 198 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8858449 | 8858449 | PRJNA763243_P_NODE_69307_length_223_cov_63.146667_g68961_i0 | PRJNA763243 | 69307 | 223 | 63.146667 | 140.81706741 | Aquastella | 1495611 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 4.74e-108 | NTclustered | gi|629632980|gb|KF294792.1| | 1495612 | g68961 | i0 | 100 | 97.7264573991031 | 218 | 0 | 98 | 0 | 4 | 221 | 1367 | 1584 | Aquastella attenuata isolate SL45 18S ribosomal RNA gene, partial sequence | blastn | 21793 | 403 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aquastella | Aquastella attenuata | ||
| 9672496 | 9672496 | PRJNA763243_P_NODE_72628_length_207_cov_360.761194_g72282_i0 | PRJNA763243 | 72628 | 207 | 360.761194 | 746.77567158 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.65e-95 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g72282 | i0 | 98.529 | 98.2995169082126 | 204 | 3 | 99 | 0 | 4 | 207 | 1883 | 2086 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 20348 | 361 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 10947839 | 10947839 | PRJNA763243_P_NODE_58049_length_245_cov_3.959302_g57703_i0 | PRJNA763243 | 58049 | 245 | 3.959302 | 9.7002899 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.67e-18 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g57703 | i0 | 87.912 | 13.4734693877551 | 91 | 9 | 37 | 2 | 156 | 245 | 41764 | 41675 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 3301 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 11409131 | 11409131 | PRJNA763243_P_NODE_66729_length_232_cov_7.301887_g66383_i0 | PRJNA763243 | 66729 | 232 | 7.301887 | 16.94037784 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 9.12e-41 | NTclustered | gi|2795037587|ref|XM_067935188.1| | 4785 | g66383 | i0 | 83.59 | 13.3965517241379 | 195 | 28 | 83 | 4 | 10 | 202 | 193 | 1 | Phytophthora cinnamomi 60S ribosomal protein L5 (IUM83_10672), partial mRNA | blastn | 3108 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 13497934 | 13497934 | PRJNA763243_P_NODE_991_length_1217_cov_8.604021_g832_i0 | PRJNA763243 | 991 | 1217 | 8.604021 | 104.71093557 | Achlya ambisexualis | 4768 | SAR_Eukaryotes | SAR_Eukaryotes | 701 | 0 | NTclustered | gi|22086549|gb|AF402100.1| | 4768 | g832 | i0 | 78.215 | 83.2752670501232 | 1143 | 215 | 93 | 30 | 1 | 1126 | 1147 | 22 | Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds | blastn | 101346 | 701 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis | ||
| 16046622 | 16046622 | PRJNA763243_P_NODE_70893_length_216_cov_4.608392_g70547_i0 | PRJNA763243 | 70893 | 216 | 4.608392 | 9.95412672 | Pseudoperonospora urticae | 162119 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 1.28e-103 | NTclustered | gi|33520221|gb|AY273966.1| | 162119 | g70547 | i0 | 99.531 | 98.6203703703704 | 213 | 1 | 99 | 0 | 1 | 213 | 249 | 37 | Pseudoperonospora urticae large subunit ribosomal RNA gene, partial sequence | blastn | 21302 | 388 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora urticae | ||
| 17320938 | 17320938 | PRJNA763243_P_NODE_114_length_2815_cov_60.446025_g84_i0 | PRJNA763243 | 114 | 2815 | 60.446025 | 1701.55560375 | Phytophthora hedraiandra | 295481 | SAR_Eukaryotes | SAR_Eukaryotes | 536 | 6.62e-147 | NTclustered | gi|2314988701|ref|NC_067067.1| | 295481 | g84 | i0 | 75.059 | 40.4891651865009 | 1263 | 260 | 44 | 48 | 1 | 1235 | 33218 | 31983 | Phytophthora hedraiandra voucher CBS111725 mitochondrion, complete genome | blastn | 113977 | 536 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora hedraiandra | ||
| 17782855 | 17782855 | PRJNA763243_P_NODE_38134_length_281_cov_21.298077_g37788_i0 | PRJNA763243 | 38134 | 281 | 21.298077 | 59.84759637 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 1.01e-125 | NTclustered | gi|227430058|emb|FM999232.1| | 281399 | g37788 | i0 | 96.763 | 97.8967971530249 | 278 | 7 | 99 | 2 | 4 | 280 | 145 | 421 | Aphanomyces frigidophilus 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene (partial), isolate SAP233 | blastn | 27509 | 462 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces frigidophilus | ||
| 21607518 | 21607518 | PRJNA763243_P_NODE_6897_length_551_cov_6.947699_g6560_i0 | PRJNA763243 | 6897 | 551 | 6.947699 | 38.28182149 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.31e-17 | NTclustered | gi|698793878|ref|XR_717100.1| | 112090 | g6560 | i0 | 80.916 | 21.0344827586207 | 131 | 24 | 24 | 1 | 395 | 524 | 3791 | 3661 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 11590 | 102 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 22421440 | 22421440 | PRJNA763243_P_NODE_8758_length_500_cov_19.772834_g8416_i0 | PRJNA763243 | 8758 | 500 | 19.772834 | 98.86417 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.72e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g8416 | i0 | 80.533 | 67.634 | 375 | 65 | 74 | 4 | 129 | 496 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33817 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23696822 | 23696822 | PRJNA763243_P_NODE_65439_length_236_cov_11.496933_g65093_i0 | PRJNA763243 | 65439 | 236 | 11.496933 | 27.13276188 | Aphanomyces sp. APH2 | 637497 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.379999999999999e-101 | NTclustered | gi|226818991|gb|FJ794896.1| | 637497 | g65093 | i0 | 97.748 | 93.8940677966102 | 222 | 3 | 93 | 1 | 14 | 233 | 1724 | 1503 | Aphanomyces sp. APH2 strain APH2_BRN01 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 | 22159 | 381 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. APH2 |
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);;