contig_metadata
8 rows where bioproject = "PRJNA940501", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4746403 | 4746403 | PRJNA940501_S_NODE_13724_length_412_cov_5.552846_g12912_i0 | PRJNA940501 | 13724 | 412 | 5.552846 | 22.87772552 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 151 | 2.3899999999999993e-43 | NR | KAI9140816.1 | 1500003 | g12912 | i0 | 64.4 | 1.56553398058252 | 104 | 35 | 74.3 | 1 | 2 | 307 | 92 | 195 | KAI9140816.1 superoxide dismutase [Paraphysoderma sedebokerense] | diamond | 645 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 26930305 | 26930305 | PRJNA940501_S_NODE_262122_length_176_cov_1.060150_g261304_i0 | PRJNA940501 | 262122 | 176 | 1.06015 | 1.865864 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 79.3 | 1.9e-15 | NR | ORZ34106.1 | 765915 | g261304 | i0 | 62.1 | 1.97727272727273 | 58 | 21 | 98.9 | 1 | 175 | 2 | 704 | 760 | ORZ34106.1 Lon protease C-terminal proteolytic domain-domain-containing protein [Catenaria anguillulae PL171] | diamond | 348 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27758940 | 27758940 | PRJNA940501_S_NODE_167004_length_204_cov_2.434783_g166186_i0 | PRJNA940501 | 167004 | 204 | 2.434783 | 4.96695732 | Blastocladiella | 4807 | Fungi | Fungi | 50.8 | 1.17e-5 | NR | KAI9224125.1 | 64508 | g166186 | i0 | 58.5 | 1.19117647058824 | 41 | 17 | 60.3 | 0 | 203 | 81 | 101 | 141 | KAI9224125.1 ribosomal protein S19 [Blastocladiella britannica] | diamond | 243 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28036043 | 28036043 | PRJNA940501_S_NODE_22945_length_349_cov_3.081699_g22127_i0 | PRJNA940501 | 22945 | 349 | 3.081699 | 10.75512951 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 53.1 | 2.74e-5 | NR | KAI9175326.1 | 1313167 | g22127 | i0 | 49 | 0.438395415472779 | 51 | 26 | 43.8 | 0 | 257 | 105 | 662 | 712 | KAI9175326.1 ATP-dependent DNA helicase II subunit 1 [Blastocladiella emersonii ATCC 22665] | diamond | 153 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 29021948 | 29021948 | PRJNA940501_S_NODE_212288_length_189_cov_1.609589_g211470_i0 | PRJNA940501 | 212288 | 189 | 1.609589 | 3.04212321 | Fungi | 4751 | Fungi | Fungi | 45.4 | 0.00195 | NR | KAJ3347858.1 | 64505 | g211470 | i0 | 64.3 | 3.17460317460317 | 28 | 10 | 44.4 | 0 | 95 | 12 | 295 | 322 | KAJ3347858.1 Cullin-4A [Allomyces javanicus] | diamond | 600 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 30310046 | 30310046 | PRJNA940501_S_NODE_19432_length_366_cov_5.256966_g18614_i0 | PRJNA940501 | 19432 | 366 | 5.256966 | 19.24049556 | Allomyces arbusculus | 64504 | Fungi | Fungi | 150 | 5.78e-44 | NR | KAJ3373363.1 | 64504 | g18614 | i0 | 73 | 2.4672131147541 | 100 | 27 | 82 | 0 | 4 | 303 | 32 | 131 | KAJ3373363.1 60S ribosomal protein L32 [Allomyces arbusculus] | diamond | 903 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 31731809 | 31731809 | PRJNA940501_S_NODE_332177_length_161_cov_1.194915_g331359_i0 | PRJNA940501 | 332177 | 161 | 1.194915 | 1.92381315 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 88.2 | 8.71e-19 | NR | KNE69722.1 | 578462 | g331359 | i0 | 81.1 | 0.987577639751553 | 53 | 10 | 98.8 | 0 | 3 | 161 | 41 | 93 | KNE69722.1 cytoplasmic tRNA 2-thiolation protein 1 [Allomyces macrogynus ATCC 38327] | diamond | 159 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31763506 | 31763506 | PRJNA940501_S_NODE_127577_length_222_cov_1.575419_g126759_i0 | PRJNA940501 | 127577 | 222 | 1.575419 | 3.49743018 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 57 | 2.41e-7 | NR | ORZ37065.1 | 765915 | g126759 | i0 | 64.1 | 1.66216216216216 | 39 | 14 | 52.7 | 0 | 3 | 119 | 291 | 329 | ORZ37065.1 malate dehydrogenase [Catenaria anguillulae PL171] | diamond | 369 | 57 | 1 | 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);;