contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1130737 | 1130737 | PRJNA561212_P_NODE_1301_length_947_cov_15.881007_g1136_i0 | PRJNA561212 | 1301 | 947 | 15.881007 | 150.39313629 | Allomyces | 28581 | Fungi | Fungi | 1543 | 0 | NTclustered | gi|362410325|gb|JN941230.1| | 28583 | g1136 | i0 | 99.297 | 63.6409714889124 | 854 | 5 | 90 | 1 | 63 | 916 | 1 | 853 | Allomyces macrogynus strain WT Burma 3-35 28S ribosomal RNA (LSU) gene, partial sequence | blastn | 60268 | 1543 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 1821148 | 1821148 | PRJNA561212_P_NODE_26162_length_239_cov_8.530120_g25951_i0 | PRJNA561212 | 26162 | 239 | 8.53012 | 20.3869868 | Allomyces macrogynus | 28583 | Fungi | Fungi | 411 | 3.079999999999999e-110 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g25951 | i0 | 99.556 | 2.35564853556485 | 225 | 1 | 94 | 0 | 10 | 234 | 310 | 86 | Allomyces macrogynus mitochondrion, complete genome | blastn | 563 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 4372979 | 4372979 | PRJNA561212_P_NODE_6524_length_431_cov_161.075419_g6313_i0 | PRJNA561212 | 6524 | 431 | 161.075419 | 694.23505589 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 279 | 1.7500000000000002e-70 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g6313 | i0 | 94.054 | 45.707656612529 | 185 | 9 | 43 | 2 | 10 | 194 | 3194 | 3376 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 19700 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 5649360 | 5649360 | PRJNA561212_P_NODE_685_length_1238_cov_16.476395_g572_i0 | PRJNA561212 | 685 | 1238 | 16.476395 | 203.9777701 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 1018 | 0 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g572 | i0 | 90.262 | 21.0129240710824 | 801 | 47 | 90 | 20 | 5 | 797 | 15511 | 14734 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 26014 | 1018 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 9473808 | 9473808 | PRJNA561212_P_NODE_11428_length_328_cov_1.152941_g11217_i0 | PRJNA561212 | 11428 | 328 | 1.152941 | 3.78164648 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 357 | 5.84e-94 | NTclustered | gi|117422543|gb|EF064248.1| | 4808 | g11217 | i0 | 90.943 | 76.1067073170732 | 265 | 24 | 81 | 0 | 10 | 274 | 311 | 47 | Blastocladiella emersonii beta-tubulin mRNA, complete cds | blastn | 24963 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 10749818 | 10749818 | PRJNA561212_P_NODE_449_length_1470_cov_1.997137_g358_i0 | PRJNA561212 | 449 | 1470 | 1.997137 | 29.3579139 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 1869 | 0 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g358 | i0 | 90.767 | 73.4387755102041 | 1408 | 118 | 95 | 10 | 51 | 1452 | 1473 | 72 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 107955 | 1869 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 10749891 | 10749891 | PRJNA561212_P_NODE_8689_length_372_cov_19.852843_g8478_i0 | PRJNA561212 | 8689 | 372 | 19.852843 | 73.85257596 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 298 | 4.12e-76 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g8478 | i0 | 96.175 | 49.25 | 183 | 6 | 49 | 1 | 10 | 191 | 3199 | 3381 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 18321 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 13299525 | 13299525 | PRJNA561212_P_NODE_23531_length_246_cov_14.300578_g23320_i0 | PRJNA561212 | 23531 | 246 | 14.300578 | 35.17942188 | Allomyces arbusculus | 64504 | Fungi | Fungi | 412 | 8.85e-111 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g23320 | i0 | 99.127 | 89.4308943089431 | 229 | 2 | 93 | 0 | 9 | 237 | 2693 | 2465 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 22000 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 13299579 | 13299579 | PRJNA561212_P_NODE_3411_length_597_cov_18.729008_g3205_i0 | PRJNA561212 | 3411 | 597 | 18.729008 | 111.81217776 | Allomyces macrogynus | 28583 | Fungi | Fungi | 1048 | 0 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g3205 | i0 | 99.31 | 12.787269681742 | 580 | 3 | 97 | 1 | 9 | 588 | 1546 | 2124 | Allomyces macrogynus mitochondrion, complete genome | blastn | 7634 | 1048 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 13299666 | 13299666 | PRJNA561212_P_NODE_8691_length_372_cov_11.936455_g8480_i0 | PRJNA561212 | 8691 | 372 | 11.936455 | 44.4036126 | Allomyces arbusculus | 64504 | Fungi | Fungi | 649 | 0 | NTclustered | gi|296035081|ref|NG_017166.1| | 64504 | g8480 | i0 | 99.718 | 93.0860215053764 | 354 | 1 | 95 | 0 | 10 | 363 | 358 | 5 | Allomyces arbusculus UCBMG Brazil 2 18S rRNA gene, partial sequence; from reference material | blastn | 34628 | 649 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 15848097 | 15848097 | PRJNA561212_P_NODE_1133_length_1005_cov_8.577253_g978_i0 | PRJNA561212 | 1133 | 1005 | 8.577253 | 86.20139265 | Allomyces macrogynus | 28583 | Fungi | Fungi | 257 | 2.01e-63 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g978 | i0 | 85.091 | 11.3054726368159 | 275 | 16 | 68 | 14 | 420 | 674 | 801 | 532 | Allomyces macrogynus mitochondrion, complete genome | blastn | 11362 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 15848218 | 15848218 | PRJNA561212_P_NODE_1773_length_814_cov_23.441296_g1585_i0 | PRJNA561212 | 1773 | 814 | 23.441296 | 190.81214944 | Allomyces arbusculus | 64504 | Fungi | Fungi | 1328 | 0 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g1585 | i0 | 96.415 | 85.8366093366093 | 809 | 22 | 99 | 5 | 1 | 806 | 1381 | 2185 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 69871 | 1328 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 17123287 | 17123287 | PRJNA561212_P_NODE_9074_length_365_cov_1.119863_g8863_i0 | PRJNA561212 | 9074 | 365 | 1.119863 | 4.08749995 | Allomyces arbusculus | 64504 | Fungi | Fungi | 603 | 7.629999999999998e-168 | NTclustered | gi|358030853|dbj|AB609160.1| | 64504 | g8863 | i0 | 97.191 | 96.3698630136986 | 356 | 10 | 98 | 0 | 10 | 365 | 1287 | 1642 | Allomyces arbusculus EF2 gene for translation elongation factor 2, partial cds, strain: BL002 | blastn | 35175 | 603 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 18397436 | 18397436 | PRJNA561212_P_NODE_6455_length_433_cov_78.877778_g6244_i0 | PRJNA561212 | 6455 | 433 | 78.877778 | 341.54077874 | Catenophlyctis variabilis | 945688 | Fungi | Fungi | 763 | 0 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g6244 | i0 | 99.76 | 99.2263279445727 | 416 | 1 | 96 | 0 | 9 | 424 | 2963 | 2548 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 42965 | 763 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 18982075 | 18982075 | PRJNA561212_P_NODE_11095_length_332_cov_30.826255_g10884_i0 | PRJNA561212 | 11095 | 332 | 30.826255 | 102.3431666 | Catenariaceae | 109872 | Fungi | Fungi | 577 | 4.169999999999999e-160 | NTclustered | gi|321173723|gb|HQ888704.1| | 109876 | g10884 | i0 | 100 | 87.6626506024096 | 312 | 0 | 94 | 0 | 12 | 323 | 346 | 35 | Catenaria anguillulae strain BR105 18S ribosomal RNA gene, partial sequence | blastn | 29104 | 577 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 20257227 | 20257227 | PRJNA561212_P_NODE_6456_length_433_cov_27.141667_g6245_i0 | PRJNA561212 | 6456 | 433 | 27.141667 | 117.52341811 | Allomyces | 28581 | Fungi | Fungi | 767 | 0 | NTclustered | gi|777407|gb|U23936.1|AMU23936 | 28583 | g6245 | i0 | 100 | 94.1039260969977 | 415 | 0 | 96 | 0 | 10 | 424 | 1191 | 777 | Allomyces macrogynus small subunit ribosomal RNA (rns) gene, complete sequence | blastn | 40747 | 767 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 23497592 | 23497592 | PRJNA561212_P_NODE_10519_length_341_cov_0.992537_g10308_i0 | PRJNA561212 | 10519 | 341 | 0.992537 | 3.38455117 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 281 | 3.78e-71 | NTclustered | gi|111054102|gb|DQ787196.1| | 4808 | g10308 | i0 | 82.857 | 93.5425219941349 | 315 | 52 | 92 | 2 | 18 | 331 | 2999 | 2686 | Blastocladiella emersonii heat shock protein 90 kDa (hsp90) gene, complete cds | blastn | 31898 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii |
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);;