contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 644543 | 644543 | PRJNA674308_P_NODE_18841_length_225_cov_2.340909_g18606_i0 | PRJNA674308 | 18841 | 225 | 2.340909 | 5.26704525 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.13e-44 | NTclustered | gi|669138647|ref|XM_008606670.1| | 1156394 | g18606 | i0 | 82.222 | 1.97777777777778 | 225 | 38 | 99 | 2 | 2 | 225 | 2084 | 1861 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 445 | 193 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 644591 | 644591 | PRJNA674308_P_NODE_23701_length_204_cov_53.148387_g23466_i0 | PRJNA674308 | 23701 | 204 | 53.148387 | 108.42270948 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.27e-58 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g23466 | i0 | 87.864 | 38.3039215686275 | 206 | 21 | 100 | 4 | 1 | 204 | 1694 | 1491 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 7814 | 239 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 644629 | 644629 | PRJNA674308_P_NODE_2741_length_588_cov_43.647495_g2514_i0 | PRJNA674308 | 2741 | 588 | 43.647495 | 256.6472706 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.81e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g2514 | i0 | 80.533 | 57.530612244898 | 375 | 65 | 63 | 4 | 29 | 396 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 1166510 | 1166510 | PRJNA674308_P_NODE_20781_length_216_cov_2.179641_g20546_i0 | PRJNA674308 | 20781 | 216 | 2.179641 | 4.70802456 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.3799999999999998e-48 | NTclustered | gi|2248512916|ref|NC_063792.1| | 100870 | g20546 | i0 | 84.112 | 93.4027777777778 | 214 | 32 | 99 | 2 | 3 | 215 | 17970 | 18182 | Phytophthora litchii isolate SHS3 mitochondrion, complete genome | blastn | 20175 | 207 | 0.995169082125604 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora litchii | ||
| 1920784 | 1920784 | PRJNA674308_P_NODE_2302_length_650_cov_1.777038_g2082_i0 | PRJNA674308 | 2302 | 650 | 1.777038 | 11.550747 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 1038 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g2082 | i0 | 96.232 | 101.758461538462 | 637 | 18 | 98 | 6 | 17 | 650 | 2849 | 2216 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 66143 | 1038 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 3718163 | 3718163 | PRJNA674308_P_NODE_19003_length_225_cov_0.886364_g18768_i0 | PRJNA674308 | 19003 | 225 | 0.886364 | 1.994319 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 8.670000000000002e-51 | NTclustered | gi|2795042802|ref|XM_067923953.1| | 4785 | g18768 | i0 | 84.163 | 28.1111111111111 | 221 | 33 | 98 | 2 | 6 | 225 | 569 | 350 | Phytophthora cinnamomi guanine nucleotide-binding protein subunit beta-like protein (IUM83_00199), partial mRNA | blastn | 6325 | 213 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9573491 | 9573491 | PRJNA674308_P_NODE_7708_length_342_cov_6.566553_g7473_i0 | PRJNA674308 | 7708 | 342 | 6.566553 | 22.45761126 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 4.87e-75 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g7473 | i0 | 87.451 | 72.6842105263158 | 255 | 32 | 75 | 0 | 88 | 342 | 1 | 255 | A.bisexualis gene for actin | blastn | 24858 | 294 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 10848615 | 10848615 | PRJNA674308_P_NODE_11709_length_279_cov_20.517391_g11474_i0 | PRJNA674308 | 11709 | 279 | 20.517391 | 57.24352089 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 7.63e-137 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g11474 | i0 | 98.925 | 84.7670250896057 | 279 | 3 | 100 | 0 | 1 | 279 | 2469 | 2191 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 23650 | 499 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 12124206 | 12124206 | PRJNA674308_P_NODE_50150_length_163_cov_0.912281_g49915_i0 | PRJNA674308 | 50150 | 163 | 0.912281 | 1.48701803 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.22e-77 | NTclustered | gi|166046571|emb|CU367688.1| | 100861 | g49915 | i0 | 100 | 51.6257668711656 | 163 | 0 | 100 | 0 | 1 | 163 | 230 | 392 | Aphanomyces euteiches cDNA | blastn | 8415 | 302 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 12645859 | 12645859 | PRJNA674308_P_NODE_27510_length_191_cov_3.978873_g27275_i0 | PRJNA674308 | 27510 | 191 | 3.978873 | 7.59964743 | Saprolegniaceae | 4764 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.4699999999999996e-82 | NTclustered | gi|5327102|emb|AJ238661.1| | 92984 | g27275 | i0 | 96.859 | 100.759162303665 | 191 | 5 | 100 | 1 | 1 | 191 | 670 | 859 | Leptolegnia chapmanii 18S rRNA gene, partial | blastn | 19245 | 318 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Leptolegnia | Leptolegnia chapmanii | ||
| 13399001 | 13399001 | PRJNA674308_P_NODE_54711_length_152_cov_8.368932_g54476_i0 | PRJNA674308 | 54711 | 152 | 8.368932 | 12.72077664 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.46e-71 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g54476 | i0 | 100 | 101.953947368421 | 152 | 0 | 100 | 0 | 1 | 152 | 98 | 249 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 15497 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 15947600 | 15947600 | PRJNA674308_P_NODE_5413_length_408_cov_2.247911_g5178_i0 | PRJNA674308 | 5413 | 408 | 2.247911 | 9.17147688 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 640 | 6.569999999999999e-179 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g5178 | i0 | 95.739 | 106.007352941176 | 399 | 13 | 97 | 4 | 12 | 408 | 8991 | 8595 | Achlya hypogyna mitochondrion, complete genome | blastn | 43251 | 640 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 15947631 | 15947631 | PRJNA674308_P_NODE_9693_length_305_cov_5.488281_g9458_i0 | PRJNA674308 | 9693 | 305 | 5.488281 | 16.73925705 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 564 | 2.95e-156 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g9458 | i0 | 100 | 99.7803278688525 | 305 | 0 | 100 | 0 | 1 | 305 | 573 | 269 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 30433 | 564 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 17222779 | 17222779 | PRJNA674308_P_NODE_26274_length_195_cov_4.986301_g26039_i0 | PRJNA674308 | 26274 | 195 | 4.986301 | 9.72328695 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 9.79e-25 | NTclustered | gi|698785786|ref|XM_009827635.1| | 112090 | g26039 | i0 | 84.375 | 62.4974358974359 | 128 | 20 | 66 | 0 | 1 | 128 | 205 | 332 | Aphanomyces astaci histone H4 mRNA | blastn | 12187 | 126 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21047122 | 21047122 | PRJNA674308_P_NODE_16137_length_241_cov_1.916667_g15902_i0 | PRJNA674308 | 16137 | 241 | 1.916667 | 4.61916747 | Phytopythium fagopyri | 1130067 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.6100000000000002e-33 | NTclustered | gi|440647382|dbj|AB690639.1| | 1130067 | g15902 | i0 | 83.333 | 70.1369294605809 | 168 | 28 | 70 | 0 | 8 | 175 | 289 | 122 | Phytopythium fagopyri mitochondrial COXI gene for cytochrome oxidase I, partial cds, isolate: HonMa | blastn | 16903 | 156 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium fagopyri | ||
| 22322162 | 22322162 | PRJNA674308_P_NODE_45638_length_165_cov_0.896552_g45403_i0 | PRJNA674308 | 45638 | 165 | 0.896552 | 1.4793108 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3.73e-23 | NTclustered | gi|669152195|ref|XM_008613438.1| | 1156394 | g45403 | i0 | 80.645 | 26.2606060606061 | 155 | 30 | 94 | 0 | 10 | 164 | 306 | 152 | Saprolegnia diclina VS20 40S ribosomal protein S2 mRNA | blastn | 4333 | 121 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 24118460 | 24118460 | PRJNA674308_P_NODE_25419_length_198_cov_74.825503_g25184_i0 | PRJNA674308 | 25419 | 198 | 74.825503 | 148.15449594 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 3.37e-69 | NTclustered | gi|145280621|gb|EF175576.1| | 434927 | g25184 | i0 | 100 | 75.2323232323232 | 148 | 0 | 75 | 0 | 51 | 198 | 300 | 153 | Aphanomyces sp. MCA 3058 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 14896 | 274 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. MCA 3058 | ||
| 24870890 | 24870890 | PRJNA674308_P_NODE_28280_length_189_cov_1.685714_g28045_i0 | PRJNA674308 | 28280 | 189 | 1.685714 | 3.18599946 | Phytophthora novae-guineae | 3070859 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 5.429999999999999e-52 | NTclustered | gi|1940379313|gb|MN883605.1| | 3070859 | g28045 | i0 | 87.302 | 97.7513227513227 | 189 | 24 | 100 | 0 | 1 | 189 | 17334 | 17522 | Phytophthora novae-guineae culture ICMP:19637 mitochondrion, complete genome | blastn | 18475 | 217 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora novae-guineae |
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);;