contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA546018" 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 |
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);;