contig_metadata
16 rows where bioproject = "PRJNA928559", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 902336 | 902336 | PRJNA928559_P_NODE_130021_length_311_cov_2.626050_g128452_i0 | PRJNA928559 | 130021 | 311 | 2.62605 | 8.1670155 | Catenaria sp. | 2420186 | Fungi | Fungi | 545 | 1.0899999999999999e-150 | NTclustered | gi|1866582716|gb|MT730891.1| | 2420186 | g128452 | i0 | 98.397 | 82.7266881028939 | 312 | 2 | 100 | 3 | 1 | 311 | 2938 | 3247 | Catenaria sp. isolate JEL0913 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 | 25728 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 1252932 | 1252932 | PRJNA928559_P_NODE_200581_length_248_cov_0.891429_g199012_i0 | PRJNA928559 | 200581 | 248 | 0.891429 | 2.21074392 | Eukaryota | 2759 | Fungi | Fungi | 124 | 2.11e-34 | NR | KAJ3372542.1 | 64504 | g199012 | i0 | 70.7 | 50.5766129032258 | 82 | 24 | 99.2 | 0 | 3 | 248 | 43 | 124 | KAJ3372542.1 Actin- protein 2/3 complex subunit 4 [Allomyces arbusculus] | diamond | 12543 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 5081500 | 5081500 | PRJNA928559_P_NODE_70004_length_420_cov_3.348703_g68435_i0 | PRJNA928559 | 70004 | 420 | 3.348703 | 14.0645526 | Physoderma | 109874 | Fungi | Fungi | 161 | 6.44e-35 | NTclustered | gi|311235628|ref|NG_027645.1| | 276838 | g68435 | i0 | 94.286 | 36.9119047619048 | 105 | 6 | 25 | 0 | 316 | 420 | 1720 | 1616 | Physoderma maydis DUKE DUH0007932 28S rRNA gene, partial sequence; from reference material | blastn | 15503 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Physoderma | Physoderma maydis | |
| 6007585 | 6007585 | PRJNA928559_P_NODE_70325_length_419_cov_4.416185_g68756_i0 | PRJNA928559 | 70325 | 419 | 4.416185 | 18.50381515 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 418 | 3.449999999999999e-112 | NTclustered | gi|1866582625|gb|MT730800.1| | 2169676 | g68756 | i0 | 84.706 | 65.6133651551313 | 425 | 57 | 100 | 8 | 1 | 419 | 4658 | 4236 | Blastocladiella sp. isolate JEL0735 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 | 27492 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 8556758 | 8556758 | PRJNA928559_P_NODE_33047_length_572_cov_4.621242_g31512_i0 | PRJNA928559 | 33047 | 572 | 4.621242 | 26.43350424 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 186 | 1.4899999999999995e-55 | NR | KAI9142824.1 | 1500003 | g31512 | i0 | 59.3 | 2.86363636363636 | 182 | 54 | 93.4 | 2 | 3 | 536 | 94 | 259 | KAI9142824.1 50S ribosomal protein L30e-like protein [Paraphysoderma sedebokerense] | diamond | 1638 | 186 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 8905656 | 8905656 | PRJNA928559_P_NODE_176347_length_262_cov_1.867725_g174778_i0 | PRJNA928559 | 176347 | 262 | 1.867725 | 4.8934395 | Catenariaceae | 109872 | Fungi | Fungi | 372 | 1.62e-98 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g174778 | i0 | 93.902 | 16.8549618320611 | 246 | 15 | 94 | 0 | 1 | 246 | 1728 | 1973 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 4416 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 9832030 | 9832030 | PRJNA928559_P_NODE_59108_length_452_cov_2.224274_g57541_i0 | PRJNA928559 | 59108 | 452 | 2.224274 | 10.05371848 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 201 | 6.69e-63 | NR | KAI9189827.1 | 1313167 | g57541 | i0 | 67.8 | 25.4402654867257 | 146 | 45 | 95.6 | 1 | 437 | 6 | 52 | 197 | KAI9189827.1 ribosomal 40S subunit protein S13 [Blastocladiella emersonii ATCC 22665] | diamond | 11499 | 201 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 18755262 | 18755262 | PRJNA928559_P_NODE_225235_length_217_cov_13.701389_g223666_i0 | PRJNA928559 | 225235 | 217 | 13.701389 | 29.73201413 | Physoderma maydis | 276838 | Fungi | Fungi | 111 | 3.12e-20 | NTclustered | gi|626438334|ref|NR_119547.1| | 276838 | g223666 | i0 | 86.408 | 45.668202764977 | 103 | 13 | 47 | 1 | 61 | 163 | 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 | |
| 20029745 | 20029745 | PRJNA928559_P_NODE_189156_length_252_cov_2.374302_g187587_i0 | PRJNA928559 | 189156 | 252 | 2.374302 | 5.98324104 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 255 | 1.62e-63 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g187587 | i0 | 93.605 | 67.6349206349206 | 172 | 9 | 68 | 2 | 1 | 172 | 3207 | 3376 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 17044 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 25479666 | 25479666 | PRJNA928559_P_NODE_45800_length_501_cov_5.413551_g44238_i0 | PRJNA928559 | 45800 | 501 | 5.413551 | 27.12189051 | Catenariaceae | 109872 | Fungi | Fungi | 913 | 0 | NTclustered | gi|1866582779|gb|MT730954.1| | 2420186 | g44238 | i0 | 99.799 | 102.281437125748 | 498 | 0 | 99 | 1 | 1 | 498 | 4078 | 4574 | Catenaria sp. isolate PL171 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 | 51243 | 913 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 26644732 | 26644732 | PRJNA928559_P_NODE_211981_length_243_cov_0.917647_g210412_i0 | PRJNA928559 | 211981 | 243 | 0.917647 | 2.22988221 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 57.8 | 1.95e-7 | NR | ORZ41021.1 | 765915 | g210412 | i0 | 52.5 | 0.753086419753086 | 61 | 26 | 75.3 | 2 | 240 | 58 | 713 | 770 | ORZ41021.1 hypothetical protein BCR44DRAFT_1424220 [Catenaria anguillulae PL171] | diamond | 183 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 28382812 | 28382812 | PRJNA928559_P_NODE_144826_length_293_cov_2.404545_g143257_i0 | PRJNA928559 | 144826 | 293 | 2.404545 | 7.04531685 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 92 | 2.5600000000000003e-21 | NR | KAI9138745.1 | 1500003 | g143257 | i0 | 54.9 | 1.49488054607509 | 71 | 31 | 71.7 | 1 | 212 | 3 | 34 | 104 | KAI9138745.1 hypothetical protein BKA69DRAFT_748852 [Paraphysoderma sedebokerense] | diamond | 438 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28737402 | 28737402 | PRJNA928559_P_NODE_42187_length_518_cov_22.469663_g40630_i0 | PRJNA928559 | 42187 | 518 | 22.469663 | 116.39285434 | Fungi | 4751 | Fungi | Fungi | 121 | 4.52e-32 | NR | KAI9221418.1 | 64508 | g40630 | i0 | 59.8 | 3.37065637065637 | 97 | 39 | 56.2 | 0 | 487 | 197 | 14 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1746 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31225319 | 31225319 | PRJNA928559_P_NODE_204135_length_246_cov_1.352601_g202566_i0 | PRJNA928559 | 204135 | 246 | 1.352601 | 3.32739846 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 85.5 | 3.43e-17 | NR | KAI9146593.1 | 1500003 | g202566 | i0 | 56.3 | 0.865853658536585 | 71 | 31 | 86.6 | 0 | 241 | 29 | 981 | 1051 | KAI9146593.1 Oxysterol-binding protein-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 213 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32111206 | 32111206 | PRJNA928559_P_NODE_143138_length_295_cov_2.369369_g141569_i0 | PRJNA928559 | 143138 | 295 | 2.369369 | 6.98963855 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 89.4 | 2.18e-18 | NR | KAI9142317.1 | 1500003 | g141569 | i0 | 46.3 | 1.8 | 95 | 51 | 96.6 | 0 | 1 | 285 | 326 | 420 | KAI9142317.1 peptide chain release factor eRF1/aRF1 [Paraphysoderma sedebokerense] | diamond | 531 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32245215 | 32245215 | PRJNA928559_P_NODE_184998_length_255_cov_1.335165_g183429_i0 | PRJNA928559 | 184998 | 255 | 1.335165 | 3.40467075 | Fungi | 4751 | Fungi | Fungi | 63.5 | 2.06e-9 | NR | ORZ30937.1 | 765915 | g183429 | i0 | 50 | 3.41176470588235 | 64 | 30 | 75.3 | 1 | 63 | 254 | 1727 | 1788 | ORZ30937.1 armadillo-type protein [Catenaria anguillulae PL171] | diamond | 870 | 63.9 | 0.993740219092332 | 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);;