contig_metadata
10 rows where bioproject = "PRJNA1063685", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179375 | 179375 | PRJNA1063685_S_NODE_13621_length_578_cov_70.627723_g13100_i0 | PRJNA1063685 | 13621 | 578 | 70.627723 | 408.22823894 | Blastocladiella britannica | 64508 | Fungi | Fungi | 195 | 2.25e-60 | NR | KAI9222637.1 | 64508 | g13100 | i0 | 62.1 | 4.17301038062284 | 161 | 60 | 83.6 | 1 | 52 | 534 | 1 | 160 | KAI9222637.1 60S ribosomal protein L21-A [Blastocladiella britannica] | diamond | 2412 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 179601 | 179601 | PRJNA1063685_S_NODE_34841_length_397_cov_6.077160_g34299_i0 | PRJNA1063685 | 34841 | 397 | 6.07716 | 24.1263252 | Eukaryota | 2759 | Fungi | Fungi | 149 | 4.609999999999999e-43 | NR | KAI9216354.1 | 64508 | g34299 | i0 | 64.8 | 9.30226700251889 | 108 | 38 | 81.6 | 0 | 335 | 12 | 4 | 111 | KAI9216354.1 ribosomal protein L34e-domain-containing protein [Blastocladiella britannica] | diamond | 3693 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 4006347 | 4006347 | PRJNA1063685_S_NODE_824_length_1183_cov_11.205405_g624_i0 | PRJNA1063685 | 824 | 1183 | 11.205405 | 132.55994115 | Allomyces | 28581 | Fungi | Fungi | 311 | 1.2899999999999999e-95 | NR | KAJ3366379.1 | 64505 | g624 | i0 | 47.4 | 1.99577345731192 | 399 | 168 | 95.1 | 9 | 1 | 1125 | 123 | 503 | KAJ3366379.1 Protein phosphatase PP2A regulatory subunit B [Allomyces javanicus] | diamond | 2361 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 5282242 | 5282242 | PRJNA1063685_S_NODE_25845_length_459_cov_6.533679_g25304_i0 | PRJNA1063685 | 25845 | 459 | 6.533679 | 29.98958661 | Eukaryota | 2759 | Fungi | Fungi | 244 | 3.21e-80 | NR | KAI9143261.1 | 1500003 | g25304 | i0 | 79.1 | 3.8562091503268 | 148 | 31 | 96.7 | 0 | 449 | 6 | 16 | 163 | KAI9143261.1 ADP-ribosylation factor family-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1770 | 245 | 0.995918367346939 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 6115093 | 6115093 | PRJNA1063685_S_NODE_3325_length_799_cov_5.962810_g2930_i0 | PRJNA1063685 | 3325 | 799 | 5.96281 | 47.6428519 | Blastocladiomycota | 451459 | Fungi | Fungi | 122 | 1.65e-27 | NR | KAI9219409.1 | 64508 | g2930 | i0 | 44.2 | 2.37672090112641 | 165 | 83 | 62 | 4 | 3 | 497 | 198 | 353 | KAI9219409.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Blastocladiella britannica] | diamond | 1899 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27058863 | 27058863 | PRJNA1063685_S_NODE_73442_length_243_cov_1.358824_g72899_i0 | PRJNA1063685 | 73442 | 243 | 1.358824 | 3.30194232 | Opisthokonta | 33154 | Fungi | Fungi | 122 | 3.63e-30 | NR | KAJ1509030.1 | 945690 | g72899 | i0 | 72 | 16.9135802469136 | 82 | 19 | 96.3 | 1 | 10 | 243 | 262 | 343 | KAJ1509030.1 hypothetical protein HMI55_000123 [Coelomomyces lativittatus] | diamond | 4110 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 27066982 | 27066982 | PRJNA1063685_S_NODE_11382_length_608_cov_19.304673_g10867_i0 | PRJNA1063685 | 11382 | 608 | 19.304673 | 117.37241184 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 64.3 | 4.48e-8 | NR | KAI9189991.1 | 1313167 | g10867 | i0 | 32.3 | 0.641447368421053 | 130 | 85 | 64.1 | 3 | 25 | 414 | 1213 | 1339 | KAI9189991.1 hypothetical protein H9P43_001424 [Blastocladiella emersonii ATCC 22665] | diamond | 390 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27974819 | 27974819 | PRJNA1063685_S_NODE_19905_length_510_cov_76.686499_g19367_i0 | PRJNA1063685 | 19905 | 510 | 76.686499 | 391.1011449 | Eukaryota | 2759 | Fungi | Fungi | 149 | 1.3399999999999996e-42 | NR | KAI9216354.1 | 64508 | g19367 | i0 | 59.4 | 4.76470588235294 | 128 | 52 | 75.3 | 0 | 65 | 448 | 4 | 131 | KAI9216354.1 ribosomal protein L34e-domain-containing protein [Blastocladiella britannica] | diamond | 2430 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28330331 | 28330331 | PRJNA1063685_S_NODE_32906_length_409_cov_3.175595_g32364_i0 | PRJNA1063685 | 32906 | 409 | 3.175595 | 12.98818355 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 155 | 7.83e-41 | NR | KAI9136298.1 | 1500003 | g32364 | i0 | 60.2 | 0.975550122249389 | 133 | 52 | 97.6 | 1 | 2 | 400 | 629 | 760 | KAI9136298.1 vacuolar protein 14 C-terminal Fig4p binding-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 399 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28519965 | 28519965 | PRJNA1063685_S_NODE_27907_length_444_cov_6.404313_g27366_i0 | PRJNA1063685 | 27907 | 444 | 6.404313 | 28.43514972 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 68.6 | 2.36e-10 | NR | KNE66874.1 | 578462 | g27366 | i0 | 63 | 1.25675675675676 | 54 | 20 | 36.5 | 0 | 239 | 78 | 258 | 311 | KNE66874.1 hypothetical protein AMAG_11351 [Allomyces macrogynus ATCC 38327] | diamond | 558 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus |
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);;