contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430865 | 430865 | PRJNA436017_P_NODE_27161_length_156_cov_6.252101_g26863_i0 | PRJNA436017 | 27161 | 156 | 6.252101 | 9.75327756 | Physoderma maydis | 276838 | Fungi | Fungi | 111 | 2.09e-20 | NTclustered | gi|626438334|ref|NR_119547.1| | 276838 | g26863 | i0 | 86.408 | 63.525641025641 | 103 | 13 | 66 | 1 | 54 | 156 | 296 | 195 | Physoderma maydis DUKE DUH0007932 ITS region; from reference material | blastn | 9910 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Physoderma | Physoderma maydis | |
| 6808759 | 6808759 | PRJNA436017_P_NODE_826_length_1014_cov_1.566018_g688_i0 | PRJNA436017 | 826 | 1014 | 1.566018 | 15.87942252 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 601 | 8.14e-167 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g688 | i0 | 86.449 | 5.00986193293886 | 583 | 37 | 77 | 26 | 443 | 1005 | 23109 | 23669 | Blastocladiella sp. mitochondrion, complete genome | blastn | 5080 | 601 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 9359099 | 9359099 | PRJNA436017_P_NODE_7208_length_331_cov_4.176871_g6911_i0 | PRJNA436017 | 7208 | 331 | 4.176871 | 13.82544301 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 178 | 4.929999999999999e-40 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g6911 | i0 | 96.296 | 33.2809667673716 | 108 | 4 | 33 | 0 | 1 | 108 | 3269 | 3376 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 11016 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 13842639 | 13842639 | PRJNA436017_P_NODE_5851_length_371_cov_2.544910_g5555_i0 | PRJNA436017 | 5851 | 371 | 2.54491 | 9.4416161 | Catenariaceae | 109872 | Fungi | Fungi | 684 | 0 | NTclustered | gi|1866582799|gb|MT730974.1| | 2420186 | g5555 | i0 | 100 | 98.0808625336927 | 370 | 0 | 99 | 0 | 2 | 371 | 4520 | 4151 | Catenaria sp. isolate UM1556 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 | 36388 | 684 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 14459491 | 14459491 | PRJNA436017_P_NODE_15792_length_208_cov_1.333333_g15494_i0 | PRJNA436017 | 15792 | 208 | 1.333333 | 2.77333264 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 303 | 4.56e-78 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g15494 | i0 | 97.74 | 17.9567307692308 | 177 | 2 | 84 | 2 | 27 | 201 | 14518 | 14342 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 3735 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 19556457 | 19556457 | PRJNA436017_P_NODE_10456_length_266_cov_1.995633_g10158_i0 | PRJNA436017 | 10456 | 266 | 1.995633 | 5.30838378 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 440 | 4.439999999999998e-119 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g10158 | i0 | 96.642 | 48.0601503759398 | 268 | 4 | 100 | 4 | 1 | 266 | 14880 | 15144 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 12784 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 19556493 | 19556493 | PRJNA436017_P_NODE_12456_length_239_cov_2.257426_g12158_i0 | PRJNA436017 | 12456 | 239 | 2.257426 | 5.39524814 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 316 | 6.9e-82 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g12158 | i0 | 95.918 | 23.3179916317992 | 196 | 6 | 82 | 2 | 1 | 195 | 15333 | 15527 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 5573 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 24040900 | 24040900 | PRJNA436017_P_NODE_7539_length_323_cov_3.853147_g7242_i0 | PRJNA436017 | 7539 | 323 | 3.853147 | 12.44566481 | Catenaria | 109875 | Fungi | Fungi | 592 | 1.4499999999999999e-164 | NTclustered | gi|321173773|gb|HQ888754.1| | 945976 | g7242 | i0 | 99.69 | 67.5944272445821 | 323 | 1 | 100 | 0 | 1 | 323 | 377 | 699 | Catenaria sp. JEL 339 28S ribosomal RNA gene, partial sequence | blastn | 21833 | 592 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. JEL 339 | |
| 24657005 | 24657005 | PRJNA436017_P_NODE_16300_length_204_cov_1.802395_g16002_i0 | PRJNA436017 | 16300 | 204 | 1.802395 | 3.6768858 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 220 | 4.61e-53 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g16002 | i0 | 98.4 | 44.9950980392157 | 125 | 2 | 85 | 0 | 1 | 125 | 14543 | 14667 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 9179 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 24657156 | 24657156 | PRJNA436017_P_NODE_24360_length_165_cov_1.765625_g24062_i0 | PRJNA436017 | 24360 | 165 | 1.765625 | 2.91328125 | Allomyces macrogynus | 28583 | Fungi | Fungi | 231 | 1.65e-56 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g24062 | i0 | 93.082 | 24.5575757575758 | 159 | 9 | 96 | 2 | 7 | 165 | 1141 | 985 | Allomyces macrogynus mitochondrion, complete genome | blastn | 4052 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus |
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);;