contig_metadata
16 rows where bioproject = "PRJNA546018", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4337619 | 4337619 | PRJNA546018_S_NODE_12584_length_477_cov_2.012019_g12260_i0 | PRJNA546018 | 12584 | 477 | 2.012019 | 9.59733063 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 191 | 9.43e-44 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g12260 | i0 | 96.522 | 22.5932914046122 | 115 | 4 | 51 | 0 | 134 | 248 | 32220 | 32334 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 10777 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 4338389 | 4338389 | PRJNA546018_S_NODE_60704_length_184_cov_4.975610_g60379_i0 | PRJNA546018 | 60704 | 184 | 4.97561 | 9.1551224 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 135 | 1.51e-27 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g60379 | i0 | 98.684 | 10.4347826086957 | 76 | 1 | 41 | 0 | 91 | 166 | 14667 | 14592 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 1920 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 5614476 | 5614476 | PRJNA546018_S_NODE_15125_length_426_cov_27.841096_g14800_i0 | PRJNA546018 | 15125 | 426 | 27.841096 | 118.60306896 | Catenaria sp. | 2420186 | Fungi | Fungi | 497 | 4.39e-136 | NTclustered | gi|1866582684|gb|MT730859.1| | 2420186 | g14800 | i0 | 87.85 | 85.6643192488263 | 428 | 46 | 100 | 5 | 1 | 426 | 4071 | 4494 | Catenaria sp. isolate JEL0871 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 36493 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 7497362 | 7497362 | PRJNA546018_S_NODE_33826_length_267_cov_3.514563_g33501_i0 | PRJNA546018 | 33826 | 267 | 3.514563 | 9.38388321 | Blastocladiales | 4805 | Fungi | Fungi | 148 | 3.0299999999999998e-31 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g33501 | i0 | 94.792 | 27.8426966292135 | 96 | 4 | 36 | 1 | 173 | 267 | 841 | 936 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 7434 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 11989932 | 11989932 | PRJNA546018_S_NODE_43110_length_233_cov_7.424419_g42785_i0 | PRJNA546018 | 43110 | 233 | 7.424419 | 17.29889627 | Catenophlyctis variabilis | 945688 | Fungi | Fungi | 302 | 1.88e-77 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g42785 | i0 | 90.87 | 58.3047210300429 | 230 | 13 | 98 | 5 | 6 | 233 | 2778 | 2555 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 13585 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 18362245 | 18362245 | PRJNA546018_S_NODE_14775_length_432_cov_25.994609_g14450_i0 | PRJNA546018 | 14775 | 432 | 25.994609 | 112.29671088 | Allomyces arbusculus | 64504 | Fungi | Fungi | 342 | 2.2099999999999998e-89 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g14450 | i0 | 81.609 | 100.80787037037 | 435 | 61 | 100 | 16 | 1 | 432 | 1554 | 1972 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 43549 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 22187653 | 22187653 | PRJNA546018_S_NODE_25438_length_315_cov_8.590551_g25113_i0 | PRJNA546018 | 25438 | 315 | 8.590551 | 27.06023565 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 357 | 5.58e-94 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g25113 | i0 | 89.51 | 20.2793650793651 | 286 | 24 | 90 | 5 | 8 | 291 | 10643 | 10362 | Blastocladiella sp. mitochondrion, complete genome | blastn | 6388 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 24736797 | 24736797 | PRJNA546018_S_NODE_23940_length_326_cov_75.403774_g23615_i0 | PRJNA546018 | 23940 | 326 | 75.403774 | 245.81630324 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 296 | 1.28e-75 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g23615 | i0 | 84.639 | 45.0368098159509 | 319 | 25 | 97 | 17 | 10 | 326 | 2425 | 2129 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 14682 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 24737215 | 24737215 | PRJNA546018_S_NODE_49100_length_216_cov_9.006452_g48775_i0 | PRJNA546018 | 49100 | 216 | 9.006452 | 19.45393632 | Catenophlyctis variabilis | 945688 | Fungi | Fungi | 189 | 1.3899999999999996e-43 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g48775 | i0 | 83.256 | 81.3425925925926 | 215 | 27 | 99 | 7 | 4 | 216 | 768 | 975 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 17570 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 29509365 | 29509365 | PRJNA546018_S_NODE_16450_length_406_cov_5.649275_g16125_i0 | PRJNA546018 | 16450 | 406 | 5.649275 | 22.9360565 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 58.9 | 5.06e-7 | NR | KAI9179281.1 | 1313167 | g16125 | i0 | 40.2 | 0.716748768472906 | 97 | 38 | 71.7 | 1 | 26 | 316 | 863 | 939 | KAI9179281.1 hypothetical protein H9P43_005944 [Blastocladiella emersonii ATCC 22665] | diamond | 291 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30235874 | 30235874 | PRJNA546018_S_NODE_18192_length_383_cov_2.450311_g17867_i0 | PRJNA546018 | 18192 | 383 | 2.450311 | 9.38469113 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 68.2 | 2.33e-10 | NR | ORZ38373.1 | 765915 | g17867 | i0 | 36.4 | 0.838120104438642 | 107 | 63 | 82.2 | 2 | 15 | 329 | 946 | 1049 | ORZ38373.1 SacI homology domain-domain-containing protein [Catenaria anguillulae PL171] | diamond | 321 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30299502 | 30299502 | PRJNA546018_S_NODE_46232_length_224_cov_3.239264_g45907_i0 | PRJNA546018 | 46232 | 224 | 3.239264 | 7.25595136 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 84.7 | 4.81e-17 | NR | ORZ38750.1 | 765915 | g45907 | i0 | 69.8 | 0.84375 | 63 | 18 | 84.4 | 1 | 223 | 35 | 1249 | 1310 | ORZ38750.1 P-loop containing nucleoside triphosphate hydrolase protein [Catenaria anguillulae PL171] | diamond | 189 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30362700 | 30362700 | PRJNA546018_S_NODE_38572_length_248_cov_3.481283_g38247_i0 | PRJNA546018 | 38572 | 248 | 3.481283 | 8.63358184 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 70.1 | 9.21e-12 | NR | ORZ31150.1 | 765915 | g38247 | i0 | 54 | 0.762096774193548 | 63 | 28 | 76.2 | 1 | 8 | 196 | 522 | 583 | ORZ31150.1 P-loop containing nucleoside triphosphate hydrolase protein [Catenaria anguillulae PL171] | diamond | 189 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 31657957 | 31657957 | PRJNA546018_S_NODE_7457_length_650_cov_7.015280_g7159_i0 | PRJNA546018 | 7457 | 650 | 7.01528 | 45.59932 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 94.7 | 4.57e-20 | NR | ORZ31492.1 | 765915 | g7159 | i0 | 60.8 | 0.341538461538462 | 74 | 26 | 34.2 | 3 | 17 | 238 | 24 | 94 | ORZ31492.1 hypothetical protein BCR44DRAFT_1442149 [Catenaria anguillulae PL171] | diamond | 222 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32196043 | 32196043 | PRJNA546018_S_NODE_7318_length_657_cov_12.005034_g7022_i0 | PRJNA546018 | 7318 | 657 | 12.005034 | 78.87307338 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 47 | 0.0418 | NR | KAI9183046.1 | 1313167 | g7022 | i0 | 44.6 | 0.255707762557078 | 56 | 27 | 23.7 | 1 | 319 | 474 | 314 | 369 | KAI9183046.1 hypothetical protein H9P43_003962 [Blastocladiella emersonii ATCC 22665] | diamond | 168 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 32890351 | 32890351 | PRJNA546018_S_NODE_8820_length_590_cov_10.419660_g8504_i0 | PRJNA546018 | 8820 | 590 | 10.41966 | 61.475994 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 89.7 | 4.3e-17 | NR | ORZ31205.1 | 765915 | g8504 | i0 | 62 | 0.361016949152542 | 71 | 26 | 35.6 | 1 | 255 | 464 | 312 | 382 | ORZ31205.1 FAD dependent oxidoreductase [Catenaria anguillulae PL171] | diamond | 213 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;