contig_metadata
11 rows where bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 399934 | 399934 | PRJNA376117_P_NODE_31821_length_258_cov_1.421622_g31519_i0 | PRJNA376117 | 31821 | 258 | 1.421622 | 3.66778476 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 193 | 1.33e-44 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g31519 | i0 | 83.019 | 39.7751937984496 | 212 | 36 | 82 | 0 | 33 | 244 | 235 | 446 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 10262 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22750512 | 22750512 | PRJNA376117_P_NODE_25458_length_281_cov_1.355769_g25156_i0 | PRJNA376117 | 25458 | 281 | 1.355769 | 3.80971089 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 65.9 | 4.38e-10 | NR | KAJ1508800.1 | 945690 | g25156 | i0 | 42.9 | 1.04626334519573 | 98 | 50 | 98.2 | 3 | 280 | 5 | 4 | 101 | KAJ1508800.1 MCM DNA helicase complex subunit [Coelomomyces lativittatus] | diamond | 294 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 24626068 | 24626068 | PRJNA376117_P_NODE_25260_length_282_cov_0.976077_g24958_i0 | PRJNA376117 | 25260 | 282 | 0.976077 | 2.75253714 | Eukaryota | 2759 | Fungi | Fungi | 96.3 | 9.33e-21 | NR | ABH04243.1 | 4808 | g24958 | i0 | 63.6 | 5.51063829787234 | 77 | 22 | 75.5 | 1 | 282 | 70 | 634 | 710 | ABH04243.1 heat shock protein 90 kDa [Blastocladiella emersonii] | diamond | 1554 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 24626090 | 24626090 | PRJNA376117_P_NODE_26980_length_276_cov_1.295567_g26678_i0 | PRJNA376117 | 26980 | 276 | 1.295567 | 3.57576492 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 162 | 5.2699999999999995e-45 | NR | ORZ38782.1 | 765915 | g26678 | i0 | 83.7 | 9.95652173913044 | 92 | 15 | 100 | 0 | 276 | 1 | 290 | 381 | ORZ38782.1 T-complex protein 1 zeta subunit [Catenaria anguillulae PL171] | diamond | 2748 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27471340 | 27471340 | PRJNA376117_P_NODE_45043_length_233_cov_2.406250_g44741_i0 | PRJNA376117 | 45043 | 233 | 2.40625 | 5.6065625 | Blastocladiales | 4805 | Fungi | Fungi | 96.7 | 2.2e-23 | NR | KAI9216663.1 | 64508 | g44741 | i0 | 61.4 | 3.60515021459227 | 70 | 27 | 90.1 | 0 | 212 | 3 | 1 | 70 | KAI9216663.1 ribosomal protein L24e-domain-containing protein [Blastocladiella britannica] | diamond | 840 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27770078 | 27770078 | PRJNA376117_P_NODE_31704_length_258_cov_1.983784_g31402_i0 | PRJNA376117 | 31704 | 258 | 1.983784 | 5.11816272 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 48.5 | 4.19e-4 | NR | KAI9145570.1 | 1500003 | g31402 | i0 | 25.6 | 1 | 86 | 61 | 100 | 1 | 258 | 1 | 476 | 558 | KAI9145570.1 hypothetical protein BKA69DRAFT_443944 [Paraphysoderma sedebokerense] | diamond | 258 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29807578 | 29807578 | PRJNA376117_P_NODE_23111_length_289_cov_1.421296_g22809_i0 | PRJNA376117 | 23111 | 289 | 1.421296 | 4.10754544 | Fungi | 4751 | Fungi | Fungi | 100 | 1.13e-22 | NR | KAI9142630.1 | 1500003 | g22809 | i0 | 52.1 | 4.00692041522491 | 96 | 43 | 98.6 | 2 | 3 | 287 | 29 | 122 | KAI9142630.1 hypothetical protein BKA69DRAFT_1027453 [Paraphysoderma sedebokerense] | diamond | 1158 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30611871 | 30611871 | PRJNA376117_P_NODE_41073_length_244_cov_0.900585_g40771_i0 | PRJNA376117 | 41073 | 244 | 0.900585 | 2.1974274 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 84.3 | 8.05e-17 | NR | KAI9143926.1 | 1500003 | g40771 | i0 | 77.4 | 1.37704918032787 | 53 | 12 | 65.2 | 0 | 161 | 3 | 4 | 56 | KAI9143926.1 hypothetical protein BKA69DRAFT_1036643 [Paraphysoderma sedebokerense] | diamond | 336 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32319884 | 32319884 | PRJNA376117_P_NODE_33519_length_251_cov_2.224719_g33217_i0 | PRJNA376117 | 33519 | 251 | 2.224719 | 5.58404469 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 132 | 9.01e-34 | NR | KAI9140968.1 | 1500003 | g33217 | i0 | 81.5 | 12.7051792828685 | 81 | 15 | 96.8 | 0 | 8 | 250 | 717 | 797 | KAI9140968.1 hypothetical protein BKA69DRAFT_1029027 [Paraphysoderma sedebokerense] | diamond | 3189 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32683993 | 32683993 | PRJNA376117_P_NODE_29600_length_266_cov_1.917098_g29298_i0 | PRJNA376117 | 29600 | 266 | 1.917098 | 5.09948068 | Fungi | 4751 | Fungi | Fungi | 146 | 3.58e-39 | NR | KNE59317.1 | 578462 | g29298 | i0 | 72.7 | 5.8984962406015 | 88 | 24 | 99.2 | 0 | 265 | 2 | 182 | 269 | KNE59317.1 hypothetical protein AMAG_03618 [Allomyces macrogynus ATCC 38327] | diamond | 1569 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32761530 | 32761530 | PRJNA376117_P_NODE_43000_length_242_cov_1.017751_g42698_i0 | PRJNA376117 | 43000 | 242 | 1.017751 | 2.46295742 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 55.5 | 1.11e-6 | NR | KAI9183370.1 | 1313167 | g42698 | i0 | 49 | 0.607438016528926 | 49 | 24 | 59.5 | 1 | 151 | 8 | 42 | 90 | KAI9183370.1 hypothetical protein H9P43_004287 [Blastocladiella emersonii ATCC 22665] | diamond | 147 | 55.5 | 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);;