contig_metadata
16 rows where bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7273219 | 7273219 | PRJNA914897_P_NODE_4006_length_997_cov_8.872294_g3715_i0 | PRJNA914897 | 4006 | 997 | 8.872294 | 88.45677118 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 225 | 4.24e-68 | NR | KAI9145247.1 | 1500003 | g3715 | i0 | 51.6 | 1.91073219658977 | 244 | 102 | 73.4 | 3 | 995 | 264 | 2 | 229 | KAI9145247.1 ribosomal L28e protein family-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1905 | 225 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 15278970 | 15278970 | PRJNA914897_P_NODE_40872_length_244_cov_0.900585_g40448_i0 | PRJNA914897 | 40872 | 244 | 0.900585 | 2.1974274 | Blastocladiales | 4805 | Fungi | Fungi | 131 | 3.35e-36 | NR | KAI9215784.1 | 64508 | g40448 | i0 | 74.1 | 9.95901639344262 | 81 | 21 | 99.6 | 0 | 243 | 1 | 123 | 203 | KAI9215784.1 GTP cyclohydrolase 1 [Blastocladiella britannica] | diamond | 2430 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 25120923 | 25120923 | PRJNA914897_P_NODE_21620_length_360_cov_1.174216_g21196_i0 | PRJNA914897 | 21620 | 360 | 1.174216 | 4.2271776 | Opisthokonta | 33154 | Fungi | Fungi | 90.1 | 1.27e-18 | NR | KNE61320.1 | 578462 | g21196 | i0 | 58 | 8.69166666666667 | 69 | 29 | 57.5 | 0 | 353 | 147 | 91 | 159 | KNE61320.1 DNA repair protein RAD51 [Allomyces macrogynus ATCC 38327] | diamond | 3129 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 26644474 | 26644474 | PRJNA914897_P_NODE_41701_length_242_cov_1.822485_g41277_i0 | PRJNA914897 | 41701 | 242 | 1.822485 | 4.4104137 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 59.7 | 3.93e-8 | NR | KAI9146593.1 | 1500003 | g41277 | i0 | 50 | 0.545454545454545 | 44 | 22 | 54.5 | 0 | 237 | 106 | 1008 | 1051 | KAI9146593.1 Oxysterol-binding protein-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 132 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 26771322 | 26771322 | PRJNA914897_P_NODE_13141_length_501_cov_1.114486_g12719_i0 | PRJNA914897 | 13141 | 501 | 1.114486 | 5.58357486 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 82.8 | 4.84e-15 | NR | KAJ1507537.1 | 945690 | g12719 | i0 | 37.1 | 1.67065868263473 | 140 | 77 | 80.2 | 3 | 412 | 11 | 24 | 158 | KAJ1507537.1 hypothetical protein HMI55_000739 [Coelomomyces lativittatus] | diamond | 837 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26929639 | 26929639 | PRJNA914897_P_NODE_14942_length_461_cov_0.935567_g14520_i0 | PRJNA914897 | 14942 | 461 | 0.935567 | 4.31296387 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 109 | 1.5499999999999998e-24 | NR | KAJ1515131.1 | 945690 | g14520 | i0 | 39.5 | 1.98481561822126 | 152 | 78 | 95 | 4 | 447 | 10 | 29 | 172 | KAJ1515131.1 Phosphoacetylglucosamine Mutase [Coelomomyces lativittatus] | diamond | 915 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 27277548 | 27277548 | PRJNA914897_P_NODE_40603_length_244_cov_1.350877_g40179_i0 | PRJNA914897 | 40603 | 244 | 1.350877 | 3.29613988 | Allomyces arbusculus | 64504 | Fungi | Fungi | 48.1 | 4.79e-4 | NR | KAJ3368813.1 | 64504 | g40179 | i0 | 46.5 | 1.08196721311475 | 43 | 23 | 52.9 | 0 | 80 | 208 | 201 | 243 | KAJ3368813.1 Chitin synthase, class 2 [Allomyces arbusculus] | diamond | 264 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 27972105 | 27972105 | PRJNA914897_P_NODE_32085_length_276_cov_1.650246_g31661_i0 | PRJNA914897 | 32085 | 276 | 1.650246 | 4.55467896 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 62.4 | 5.68e-9 | NR | KAI9140365.1 | 1500003 | g31661 | i0 | 38.4 | 5.31521739130435 | 86 | 46 | 93.5 | 1 | 275 | 18 | 182 | 260 | KAI9140365.1 mitochondrial carrier domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1467 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28603686 | 28603686 | PRJNA914897_P_NODE_27207_length_308_cov_3.276596_g26783_i0 | PRJNA914897 | 27207 | 308 | 3.276596 | 10.09191568 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 93.6 | 5.5800000000000005e-22 | NR | ORZ39709.1 | 765915 | g26783 | i0 | 50.5 | 0.925324675324675 | 95 | 47 | 92.5 | 0 | 289 | 5 | 6 | 100 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 285 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29045760 | 29045760 | PRJNA914897_P_NODE_14448_length_470_cov_6.486146_g14026_i0 | PRJNA914897 | 14448 | 470 | 6.486146 | 30.4848862 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 120 | 1e-31 | NR | ORZ39709.1 | 765915 | g14026 | i0 | 46.5 | 2.38723404255319 | 127 | 68 | 81.1 | 0 | 10 | 390 | 1 | 127 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 1122 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29084715 | 29084715 | PRJNA914897_P_NODE_11468_length_547_cov_1.649789_g11048_i0 | PRJNA914897 | 11468 | 547 | 1.649789 | 9.02434583 | Opisthokonta | 33154 | Fungi | Fungi | 117 | 1.3999999999999996e-29 | NR | ORZ30338.1 | 765915 | g11048 | i0 | 40 | 2.61608775137112 | 155 | 87 | 85 | 3 | 79 | 543 | 28 | 176 | ORZ30338.1 NEDD8-conjugating enzyme UBC12 [Catenaria anguillulae PL171] | diamond | 1431 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29140619 | 29140619 | PRJNA914897_P_NODE_32989_length_271_cov_1.297980_g32565_i0 | PRJNA914897 | 32989 | 271 | 1.29798 | 3.5175258 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 70.1 | 1.68e-12 | NR | KAI9189817.1 | 1313167 | g32565 | i0 | 43.5 | 0.763837638376384 | 69 | 39 | 76.4 | 0 | 242 | 36 | 70 | 138 | KAI9189817.1 hypothetical protein H9P43_001250 [Blastocladiella emersonii ATCC 22665] | diamond | 207 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 29708319 | 29708319 | PRJNA914897_P_NODE_3850_length_1019_cov_2.700846_g3565_i0 | PRJNA914897 | 3850 | 1019 | 2.700846 | 27.52162074 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 82.4 | 4.02e-13 | NR | KAI9137664.1 | 1500003 | g3565 | i0 | 40.4 | 0.662414131501472 | 109 | 65 | 32.1 | 0 | 360 | 34 | 659 | 767 | KAI9137664.1 acyltransferase family-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 675 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30277646 | 30277646 | PRJNA914897_P_NODE_17092_length_420_cov_1.553314_g16670_i0 | PRJNA914897 | 17092 | 420 | 1.553314 | 6.5239188 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 86.7 | 1.31e-16 | NR | KNE59610.1 | 578462 | g16670 | i0 | 41.6 | 2.46428571428571 | 113 | 61 | 77.1 | 1 | 420 | 97 | 1320 | 1432 | KNE59610.1 hypothetical protein AMAG_03868 [Allomyces macrogynus ATCC 38327] | diamond | 1035 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31169130 | 31169130 | PRJNA914897_P_NODE_33615_length_267_cov_2.453608_g33191_i0 | PRJNA914897 | 33615 | 267 | 2.453608 | 6.55113336 | Allomyces | 28581 | Fungi | Fungi | 47 | 0.00162 | NR | KAJ3371194.1 | 64504 | g33191 | i0 | 48.6 | 1.60674157303371 | 35 | 18 | 39.3 | 0 | 115 | 11 | 585 | 619 | KAJ3371194.1 hypothetical protein GGF31_003617 [Allomyces arbusculus] | diamond | 429 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 32687116 | 32687116 | PRJNA914897_P_NODE_19280_length_388_cov_1.663492_g18858_i0 | PRJNA914897 | 19280 | 388 | 1.663492 | 6.45434896 | Fungi | 4751 | Fungi | Fungi | 72.8 | 5.87e-12 | NR | KAI9217856.1 | 64508 | g18858 | i0 | 35.5 | 4.67783505154639 | 121 | 69 | 88.1 | 4 | 383 | 42 | 767 | 885 | KAI9217856.1 hypothetical protein BC828DRAFT_408119 [Blastocladiella britannica] | diamond | 1815 | 73.2 | 0.994535519125683 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica |
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);;