contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1878132 | 1878132 | PRJNA630162_P_NODE_171882_length_152_cov_3.631068_g170359_i0 | PRJNA630162 | 171882 | 152 | 3.631068 | 5.51922336 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 182 | 1.52e-41 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g170359 | i0 | 97.196 | 3.38815789473684 | 107 | 3 | 70 | 0 | 8 | 114 | 23430 | 23324 | Blastocladiella sp. mitochondrion, complete genome | blastn | 515 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 1878339 | 1878339 | PRJNA630162_P_NODE_33662_length_309_cov_10.373077_g32139_i0 | PRJNA630162 | 33662 | 309 | 10.373077 | 32.05280793 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 124 | 6.029999999999999e-24 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g32139 | i0 | 87.156 | 40.9093851132686 | 109 | 14 | 35 | 0 | 5 | 113 | 3262 | 3370 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 12641 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 4429729 | 4429729 | PRJNA630162_P_NODE_21284_length_399_cov_9.265714_g19766_i0 | PRJNA630162 | 21284 | 399 | 9.265714 | 36.970198860000004 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 132 | 4.77e-26 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g19766 | i0 | 80.105 | 13.7719298245614 | 191 | 26 | 47 | 6 | 207 | 395 | 3369 | 3189 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 5495 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 5706136 | 5706136 | PRJNA630162_P_NODE_61945_length_224_cov_27.194286_g60422_i0 | PRJNA630162 | 61945 | 224 | 27.194286 | 60.91520064 | Allomyces arbusculus | 64504 | Fungi | Fungi | 180 | 8.749999999999998e-41 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g60422 | i0 | 82.326 | 96.2723214285714 | 215 | 31 | 95 | 6 | 11 | 223 | 2674 | 2883 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 21565 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 8255647 | 8255647 | PRJNA630162_P_NODE_60147_length_227_cov_5.466292_g58624_i0 | PRJNA630162 | 60147 | 227 | 5.466292 | 12.40848284 | Coelomomyces stegomyiae | 143960 | Fungi | Fungi | 128 | 3.27e-25 | NTclustered | gi|82398116|gb|DQ273767.1| | 143960 | g58624 | i0 | 90.625 | 42.7400881057269 | 96 | 9 | 42 | 0 | 1 | 96 | 2176 | 2271 | Coelomomyces stegomyiae isolate AFTOL-ID 18 28S ribosomal RNA gene, partial sequence | blastn | 9702 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces stegomyiae | |
| 9530867 | 9530867 | PRJNA630162_P_NODE_47908_length_255_cov_1.558252_g46385_i0 | PRJNA630162 | 47908 | 255 | 1.558252 | 3.9735426 | Coelomomyces stegomyiae | 143960 | Fungi | Fungi | 104 | 6.31e-18 | NTclustered | gi|82398116|gb|DQ273767.1| | 143960 | g46385 | i0 | 88.372 | 27.3372549019608 | 86 | 10 | 34 | 0 | 6 | 91 | 383 | 468 | Coelomomyces stegomyiae isolate AFTOL-ID 18 28S ribosomal RNA gene, partial sequence | blastn | 6971 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces stegomyiae | |
| 10806599 | 10806599 | PRJNA630162_P_NODE_51629_length_245_cov_2.653061_g50106_i0 | PRJNA630162 | 51629 | 245 | 2.653061 | 6.49999945 | Catenaria sp. | 2420186 | Fungi | Fungi | 150 | 7.62e-32 | NTclustered | gi|1866582684|gb|MT730859.1| | 2420186 | g50106 | i0 | 94 | 32.3673469387755 | 100 | 5 | 75 | 1 | 8 | 107 | 4086 | 4184 | 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 | 7930 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 11354781 | 11354781 | PRJNA630162_P_NODE_25909_length_358_cov_13.407767_g24388_i0 | PRJNA630162 | 25909 | 358 | 13.407767 | 47.99980586 | Blastocladiomycota | 451459 | Fungi | Fungi | 383 | 1.0599999999999996e-101 | NTclustered | gi|1866582656|gb|MT730831.1| | 1500003 | g24388 | i0 | 86.313 | 100.58938547486 | 358 | 42 | 98 | 7 | 2 | 353 | 4332 | 3976 | Paraphysoderma sedebokerense isolate JEL0821 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 | 36011 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 12081467 | 12081467 | PRJNA630162_P_NODE_22450_length_387_cov_7.032544_g20932_i0 | PRJNA630162 | 22450 | 387 | 7.032544 | 27.21594528 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 185 | 3.489999999999999e-42 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g20932 | i0 | 86.55 | 30.9328165374677 | 171 | 20 | 44 | 2 | 216 | 386 | 3371 | 3204 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 11971 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 12081536 | 12081536 | PRJNA630162_P_NODE_27830_length_344_cov_100.867797_g26308_i0 | PRJNA630162 | 27830 | 344 | 100.867797 | 346.98522168 | Catenomyces persicinus | 281913 | Fungi | Fungi | 525 | 1.6e-144 | NTclustered | gi|82398336|gb|DQ273789.1| | 281913 | g26308 | i0 | 94.186 | 100.758720930233 | 344 | 20 | 100 | 0 | 1 | 344 | 1606 | 1949 | Catenomyces sp. JEL342 isolate AFTOL-ID 47 28S ribosomal RNA gene, partial sequence | blastn | 34661 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenomyces | Catenomyces persicinus | |
| 12630269 | 12630269 | PRJNA630162_P_NODE_13490_length_517_cov_4.164530_g12009_i0 | PRJNA630162 | 13490 | 517 | 4.16453 | 21.5306201 | Fungi | 4751 | Fungi | Fungi | 111 | 8.24e-20 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g12009 | i0 | 81.618 | 3.41392649903288 | 136 | 23 | 26 | 2 | 326 | 460 | 3368 | 3234 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 1765 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 14630834 | 14630834 | PRJNA630162_P_NODE_165352_length_159_cov_2.054545_g163829_i0 | PRJNA630162 | 165352 | 159 | 2.054545 | 3.26672655 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 108 | 2.77e-19 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g163829 | i0 | 85.577 | 1.0314465408805 | 104 | 13 | 65 | 2 | 53 | 155 | 10037 | 9935 | Blastocladiella sp. mitochondrion, complete genome | blastn | 164 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 15905356 | 15905356 | PRJNA630162_P_NODE_60713_length_226_cov_8.717514_g59190_i0 | PRJNA630162 | 60713 | 226 | 8.717514 | 19.70158164 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 156 | 1.49e-33 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g59190 | i0 | 90 | 33.3716814159292 | 120 | 12 | 53 | 0 | 6 | 125 | 3255 | 3374 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 7542 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 18454707 | 18454707 | PRJNA630162_P_NODE_77535_length_204_cov_2.748387_g76012_i0 | PRJNA630162 | 77535 | 204 | 2.748387 | 5.60670948 | Microallomyces dendroideus | 281851 | Fungi | Fungi | 76.8 | 1.06e-9 | NTclustered | gi|82398520|gb|DQ273805.1| | 281851 | g76012 | i0 | 81.308 | 1.03921568627451 | 107 | 8 | 51 | 8 | 74 | 178 | 1906 | 1810 | Microallomyces dendroideus isolate AFTOL-ID 299 28S ribosomal RNA gene, partial sequence | blastn | 212 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Microallomyces | Microallomyces dendroideus | |
| 18454754 | 18454754 | PRJNA630162_P_NODE_82555_length_198_cov_4.409396_g81032_i0 | PRJNA630162 | 82555 | 198 | 4.409396 | 8.73060408 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 97.1 | 7.82e-16 | NTclustered | gi|1866582610|gb|MT730785.1| | 2169676 | g81032 | i0 | 85.87 | 30.2070707070707 | 92 | 12 | 46 | 1 | 104 | 195 | 3987 | 3897 | Blastocladiella sp. isolate JEL0703 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 | 5981 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 19729303 | 19729303 | PRJNA630162_P_NODE_83536_length_197_cov_9.277027_g82013_i0 | PRJNA630162 | 83536 | 197 | 9.277027 | 18.27574319 | Catenomyces persicinus | 281913 | Fungi | Fungi | 326 | 9.1e-85 | NTclustered | gi|82398336|gb|DQ273789.1| | 281913 | g82013 | i0 | 97.396 | 97.3857868020305 | 192 | 4 | 97 | 1 | 1 | 192 | 1951 | 1761 | Catenomyces sp. JEL342 isolate AFTOL-ID 47 28S ribosomal RNA gene, partial sequence | blastn | 19185 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenomyces | Catenomyces persicinus | |
| 24103484 | 24103484 | PRJNA630162_P_NODE_75759_length_206_cov_7.605096_g74236_i0 | PRJNA630162 | 75759 | 206 | 7.605096 | 15.66649776 | Fungi | 4751 | Fungi | Fungi | 176 | 1.02e-39 | NTclustered | gi|1866582656|gb|MT730831.1| | 1500003 | g74236 | i0 | 83.42 | 81.4902912621359 | 193 | 28 | 92 | 2 | 2 | 191 | 4377 | 4186 | Paraphysoderma sedebokerense isolate JEL0821 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 | 16787 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;