contig_metadata
6 rows where bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6393940 | 6393940 | PRJEB11748_P_NODE_196506_length_286_cov_22.466667_g194323_i0 | PRJEB11748 | 196506 | 286 | 22.466667 | 64.25466762 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 261 | 4.03e-65 | NTclustered | gi|1866582610|gb|MT730785.1| | 2169676 | g194323 | i0 | 85.328 | 75.9440559440559 | 259 | 31 | 89 | 6 | 32 | 286 | 3728 | 3983 | Blastocladiella sp. isolate JEL0703 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 | 21720 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 11498298 | 11498298 | PRJEB11748_P_NODE_84610_length_456_cov_2.726582_g82445_i0 | PRJEB11748 | 84610 | 456 | 2.726582 | 12.43321392 | Blastocladiella britannica | 64508 | Fungi | Fungi | 124 | 1.0699999999999999e-31 | NR | KAI9222377.1 | 64508 | g82445 | i0 | 53.2 | 0.730263157894737 | 111 | 52 | 73 | 0 | 57 | 389 | 2 | 112 | KAI9222377.1 PITH domain-containing protein [Blastocladiella britannica] | diamond | 333 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29805473 | 29805473 | PRJEB11748_P_NODE_359771_length_192_cov_29.778626_g357588_i0 | PRJEB11748 | 359771 | 192 | 29.778626 | 57.17496192 | Fungi | 4751 | Fungi | Fungi | 80.9 | 6.69e-16 | NR | ORZ36542.1 | 765915 | g357588 | i0 | 64.3 | 9.34375 | 56 | 20 | 87.5 | 0 | 14 | 181 | 423 | 478 | ORZ36542.1 T-complex protein 1 subunit gamma [Catenaria anguillulae PL171] | diamond | 1794 | 81.6 | 0.991421568627451 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32271369 | 32271369 | PRJEB11748_P_NODE_228298_length_261_cov_6.010000_g226115_i0 | PRJEB11748 | 228298 | 261 | 6.01 | 15.6861 | Allomyces | 28581 | Fungi | Fungi | 55.5 | 1.56e-6 | NR | KAJ3366950.1 | 64505 | g226115 | i0 | 45.5 | 2.31034482758621 | 55 | 29 | 62.1 | 1 | 16 | 177 | 109 | 163 | KAJ3366950.1 Strongly-conserved Zn-finger binding protein (TFIIIA) [Allomyces javanicus] | diamond | 603 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 32429523 | 32429523 | PRJEB11748_P_NODE_19759_length_1038_cov_9.353122_g18259_i0 | PRJEB11748 | 19759 | 1038 | 9.353122 | 97.08540636 | Allomyces | 28581 | Fungi | Fungi | 107 | 1.16e-21 | NR | KAJ3365597.1 | 64505 | g18259 | i0 | 36.6 | 1.08381502890173 | 183 | 98 | 50.9 | 8 | 1017 | 490 | 281 | 452 | KAJ3365597.1 hypothetical protein GGF32_008730 [Allomyces javanicus] | diamond | 1125 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 32719635 | 32719635 | PRJEB11748_P_NODE_17180_length_1124_cov_1.864534_g15796_i0 | PRJEB11748 | 17180 | 1124 | 1.864534 | 20.95736216 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 111 | 1.44e-22 | NR | KAI9144706.1 | 1500003 | g15796 | i0 | 46 | 0.597864768683274 | 113 | 61 | 30.2 | 0 | 362 | 700 | 393 | 505 | KAI9144706.1 hypothetical protein BKA69DRAFT_1053950 [Paraphysoderma sedebokerense] | diamond | 672 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;