contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA867519" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2123495 | 2123495 | PRJNA867519_P_NODE_27442_length_249_cov_0.875000_g27288_i0 | PRJNA867519 | 27442 | 249 | 0.875 | 2.17875 | Allomyces arbusculus | 64504 | Fungi | Fungi | 283 | 7.339999999999999e-72 | NTclustered | gi|197096946|emb|FM205774.1| | 64504 | g27288 | i0 | 90.61 | 1.5421686746988 | 213 | 20 | 86 | 0 | 3 | 215 | 799 | 587 | Allomyces arbuscula mRNA for calcium-dependent metacaspase CDP II (mcaII gene), strain Burma 1Db | blastn | 384 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 3398890 | 3398890 | PRJNA867519_P_NODE_27663_length_248_cov_1.760000_g27509_i0 | PRJNA867519 | 27663 | 248 | 1.76 | 4.3648 | Allomyces macrogynus | 28583 | Fungi | Fungi | 416 | 6.9e-112 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g27509 | i0 | 96.8 | 36.0846774193548 | 250 | 6 | 100 | 2 | 1 | 248 | 793 | 544 | Allomyces macrogynus mitochondrion, complete genome | blastn | 8949 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 3398898 | 3398898 | PRJNA867519_P_NODE_28483_length_247_cov_1.747126_g28329_i0 | PRJNA867519 | 28483 | 247 | 1.747126 | 4.31540122 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 220 | 5.78e-53 | NTclustered | gi|167189|gb|M81713.1|BSIPROKINA | 4808 | g28329 | i0 | 82.869 | 5.34008097165992 | 251 | 38 | 100 | 3 | 1 | 247 | 1776 | 1527 | Blastocladiella emersonii cAMP-dependent protein kinase regulatory subunit gene, complete cds | blastn | 1319 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 7226398 | 7226398 | PRJNA867519_P_NODE_34226_length_232_cov_3.867925_g34072_i0 | PRJNA867519 | 34226 | 232 | 3.867925 | 8.973586 | Allomyces moniliformis | 64506 | Fungi | Fungi | 429 | 8.2e-116 | NTclustered | gi|321173707|gb|HQ888688.1| | 64506 | g34072 | i0 | 100 | 94.5948275862069 | 232 | 0 | 100 | 0 | 1 | 232 | 1676 | 1445 | Allomyces moniliformis strain India 3 18S ribosomal RNA gene, partial sequence | blastn | 21946 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces moniliformis | |
| 7226431 | 7226431 | PRJNA867519_P_NODE_7346_length_406_cov_13.843844_g7192_i0 | PRJNA867519 | 7346 | 406 | 13.843844 | 56.20600664 | Allomyces moniliformis | 64506 | Fungi | Fungi | 750 | 0 | NTclustered | gi|321173707|gb|HQ888688.1| | 64506 | g7192 | i0 | 100 | 98.3965517241379 | 406 | 0 | 100 | 0 | 1 | 406 | 1144 | 739 | Allomyces moniliformis strain India 3 18S ribosomal RNA gene, partial sequence | blastn | 39949 | 750 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces moniliformis | |
| 9776089 | 9776089 | PRJNA867519_P_NODE_2548_length_635_cov_2.532028_g2399_i0 | PRJNA867519 | 2548 | 635 | 2.532028 | 16.0783778 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 418 | 5.4e-112 | NTclustered | gi|91242951|gb|DQ454107.1| | 4808 | g2399 | i0 | 82.016 | 1.23937007874016 | 506 | 78 | 79 | 9 | 1 | 501 | 1473 | 1970 | Blastocladiella emersonii heat shock protein Hsp70-3 mRNA, complete cds | blastn | 787 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 11051805 | 11051805 | PRJNA867519_P_NODE_209_length_1593_cov_8.511184_g149_i0 | PRJNA867519 | 209 | 1593 | 8.511184 | 135.58316112 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 1932 | 0 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g149 | i0 | 91.554 | 72.653483992467 | 1409 | 107 | 88 | 12 | 4 | 1406 | 72 | 1474 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 115737 | 1932 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 11051928 | 11051928 | PRJNA867519_P_NODE_6229_length_436_cov_2.666667_g6075_i0 | PRJNA867519 | 6229 | 436 | 2.666667 | 11.62666812 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 346 | 1.73e-90 | NTclustered | gi|240254697|gb|FJ765531.1| | 4808 | g6075 | i0 | 88.929 | 2.84403669724771 | 280 | 31 | 64 | 0 | 4 | 283 | 1161 | 1440 | Blastocladiella emersonii cGMP phosphodiesterase mRNA, complete cds | blastn | 1240 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 12327160 | 12327160 | PRJNA867519_P_NODE_12730_length_326_cov_1.217391_g12576_i0 | PRJNA867519 | 12730 | 326 | 1.217391 | 3.96869466 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 272 | 2.16e-68 | NTclustered | gi|240254691|gb|FJ765528.1| | 4808 | g12576 | i0 | 83.39 | 1.80981595092025 | 295 | 47 | 90 | 2 | 2 | 295 | 418 | 711 | Blastocladiella emersonii guanylyl cyclase 1 mRNA, partial cds | blastn | 590 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 12327161 | 12327161 | PRJNA867519_P_NODE_12950_length_323_cov_2.764000_g12796_i0 | PRJNA867519 | 12950 | 323 | 2.764 | 8.92772 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 71.3 | 8.37e-8 | NTclustered | gi|111054102|gb|DQ787196.1| | 4808 | g12796 | i0 | 84 | 0.318885448916409 | 75 | 11 | 23 | 1 | 18 | 92 | 3226 | 3299 | Blastocladiella emersonii heat shock protein 90 kDa (hsp90) gene, complete cds | blastn | 103 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 13601723 | 13601723 | PRJNA867519_P_NODE_14491_length_309_cov_1.305085_g14337_i0 | PRJNA867519 | 14491 | 309 | 1.305085 | 4.03271265 | Allomyces macrogynus | 28583 | Fungi | Fungi | 549 | 8.389999999999996e-152 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g14337 | i0 | 98.71 | 23.4466019417476 | 310 | 2 | 100 | 2 | 1 | 309 | 1081 | 773 | Allomyces macrogynus mitochondrion, complete genome | blastn | 7245 | 549 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 14876235 | 14876235 | PRJNA867519_P_NODE_9152_length_371_cov_27.395973_g8998_i0 | PRJNA867519 | 9152 | 371 | 27.395973 | 101.63905983 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 281 | 4.13e-71 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g8998 | i0 | 93.684 | 51.167115902965 | 190 | 9 | 51 | 3 | 1 | 188 | 3193 | 3381 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 18983 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 16150840 | 16150840 | PRJNA867519_P_NODE_353_length_1363_cov_4.430233_g273_i0 | PRJNA867519 | 353 | 1363 | 4.430233 | 60.38407579 | Allomyces macrogynus | 28583 | Fungi | Fungi | 669 | 0 | NTclustered | gi|777407|gb|U23936.1|AMU23936 | 28583 | g273 | i0 | 96.782 | 28.2751283932502 | 404 | 7 | 30 | 4 | 960 | 1363 | 1 | 398 | Allomyces macrogynus small subunit ribosomal RNA (rns) gene, complete sequence | blastn | 38539 | 669 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 18699384 | 18699384 | PRJNA867519_P_NODE_14595_length_308_cov_1.310638_g14441_i0 | PRJNA867519 | 14595 | 308 | 1.310638 | 4.03676504 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 403 | 6.89e-108 | NTclustered | gi|111054102|gb|DQ787196.1| | 4808 | g14441 | i0 | 92.553 | 91.3961038961039 | 282 | 19 | 91 | 2 | 1 | 281 | 2183 | 1903 | Blastocladiella emersonii heat shock protein 90 kDa (hsp90) gene, complete cds | blastn | 28150 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 18699459 | 18699459 | PRJNA867519_P_NODE_24535_length_255_cov_1.269231_g24381_i0 | PRJNA867519 | 24535 | 255 | 1.269231 | 3.23653905 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 322 | 1.6e-83 | NTclustered | gi|91242951|gb|DQ454107.1| | 4808 | g24381 | i0 | 89.412 | 78.5254901960784 | 255 | 27 | 100 | 0 | 1 | 255 | 1401 | 1147 | Blastocladiella emersonii heat shock protein Hsp70-3 mRNA, complete cds | blastn | 20024 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 21250173 | 21250173 | PRJNA867519_P_NODE_11617_length_338_cov_1.739623_g11463_i0 | PRJNA867519 | 11617 | 338 | 1.739623 | 5.87992574 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 311 | 4.77e-80 | NTclustered | gi|304272|gb|L17008.1|BSIKINA | 4808 | g11463 | i0 | 85.714 | 1.94674556213018 | 294 | 42 | 87 | 0 | 3 | 296 | 1884 | 2177 | Blastocladiella emersonii cAMP-dependent protein kinase, complete cds | blastn | 658 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22524729 | 22524729 | PRJNA867519_P_NODE_11358_length_341_cov_2.201493_g11204_i0 | PRJNA867519 | 11358 | 341 | 2.201493 | 7.50709113 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 294 | 4.85e-75 | NTclustered | gi|240254697|gb|FJ765531.1| | 4808 | g11204 | i0 | 82.687 | 0.982404692082111 | 335 | 54 | 98 | 4 | 9 | 341 | 356 | 688 | Blastocladiella emersonii cGMP phosphodiesterase mRNA, complete cds | blastn | 335 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22914660 | 22914660 | PRJNA867519_P_NODE_28538_length_247_cov_1.482759_g28384_i0 | PRJNA867519 | 28538 | 247 | 1.482759 | 3.66241473 | Allomyces | 28581 | Fungi | Fungi | 291 | 4.35e-74 | NTclustered | gi|1314778963|gb|KY905143.1| | 64504 | g28384 | i0 | 87.903 | 5.01619433198381 | 248 | 28 | 100 | 2 | 1 | 247 | 1092 | 846 | Allomyces arbusculus opsin-GC mRNA, partial cds | blastn | 1239 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 23800380 | 23800380 | PRJNA867519_P_NODE_32599_length_242_cov_0.911243_g32445_i0 | PRJNA867519 | 32599 | 242 | 0.911243 | 2.20520806 | Allomyces macrogynus | 28583 | Fungi | Fungi | 235 | 2.02e-57 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g32445 | i0 | 99.231 | 2.51239669421488 | 130 | 1 | 82 | 0 | 113 | 242 | 39933 | 40062 | Allomyces macrogynus mitochondrion, complete genome | blastn | 608 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 25074308 | 25074308 | PRJNA867519_P_NODE_7300_length_407_cov_13.089820_g7146_i0 | PRJNA867519 | 7300 | 407 | 13.08982 | 53.2755674 | Allomyces arbusculus | 64504 | Fungi | Fungi | 699 | 0 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g7146 | i0 | 97.555 | 107.009828009828 | 409 | 8 | 100 | 2 | 1 | 407 | 2883 | 2475 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 43553 | 699 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus |
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);;