contig_metadata
11 rows where bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6399838 | 6399838 | PRJEB17675_P_NODE_6706_length_361_cov_2.269939_g6403_i0 | PRJEB17675 | 6706 | 361 | 2.269939 | 8.19447979 | Fungi | 4751 | Fungi | Fungi | 132 | 2.8200000000000002e-36 | NR | KAJ3373676.1 | 64504 | g6403 | i0 | 80.8 | 16.8531855955679 | 78 | 15 | 64.8 | 0 | 3 | 236 | 91 | 168 | KAJ3373676.1 60S ribosomal protein L15 [Allomyces arbusculus] | diamond | 6084 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 22973682 | 22973682 | PRJEB17675_P_NODE_7139_length_347_cov_2.967949_g6835_i0 | PRJEB17675 | 7139 | 347 | 2.967949 | 10.29878303 | Fungi | 4751 | Fungi | Fungi | 168 | 3.77e-49 | NR | KAI9218401.1 | 64508 | g6835 | i0 | 64.3 | 15.9077809798271 | 115 | 41 | 99.4 | 0 | 347 | 3 | 116 | 230 | KAI9218401.1 60S ribosomal protein L2 [Blastocladiella britannica] | diamond | 5520 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 22973684 | 22973684 | PRJEB17675_P_NODE_8099_length_319_cov_1.545775_g7795_i0 | PRJEB17675 | 8099 | 319 | 1.545775 | 4.93102225 | Fungi | 4751 | Fungi | Fungi | 188 | 2.97e-59 | NR | KAI9216707.1 | 64508 | g7795 | i0 | 89.8 | 18.4420062695925 | 98 | 10 | 92.2 | 0 | 3 | 296 | 51 | 148 | KAI9216707.1 ubiquitin-conjugating enzyme [Blastocladiella britannica] | diamond | 5883 | 188 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 26589676 | 26589676 | PRJEB17675_P_NODE_16301_length_199_cov_1.109756_g15997_i0 | PRJEB17675 | 16301 | 199 | 1.109756 | 2.20841444 | Blastocladiella britannica | 64508 | Fungi | Fungi | 86.7 | 2.44e-19 | NR | KAI9218293.1 | 64508 | g15997 | i0 | 67.2 | 0.919597989949749 | 61 | 19 | 92 | 1 | 196 | 14 | 105 | 164 | KAI9218293.1 hypothetical protein BC828DRAFT_222752 [Blastocladiella britannica] | diamond | 183 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 26969752 | 26969752 | PRJEB17675_P_NODE_19662_length_176_cov_1.134752_g19358_i0 | PRJEB17675 | 19662 | 176 | 1.134752 | 1.99716352 | Blastocladiella britannica | 64508 | Fungi | Fungi | 44.3 | 0.00426 | NR | KAI9222836.1 | 64508 | g19358 | i0 | 53.8 | 0.664772727272727 | 39 | 16 | 63.1 | 1 | 174 | 64 | 48 | 86 | KAI9222836.1 hypothetical protein BC828DRAFT_377442 [Blastocladiella britannica] | diamond | 117 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27001314 | 27001314 | PRJEB17675_P_NODE_19682_length_176_cov_1.021277_g19378_i0 | PRJEB17675 | 19682 | 176 | 1.021277 | 1.79744752 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 92.4 | 4.75e-20 | NR | KAI9139907.1 | 1500003 | g19378 | i0 | 72.4 | 0.988636363636364 | 58 | 16 | 98.9 | 0 | 174 | 1 | 324 | 381 | KAI9139907.1 FAD binding domain-containing protein, partial [Paraphysoderma sedebokerense] | diamond | 174 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28264757 | 28264757 | PRJEB17675_P_NODE_17886_length_187_cov_1.315789_g17582_i0 | PRJEB17675 | 17886 | 187 | 1.315789 | 2.46052543 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 91.7 | 2.96e-20 | NR | KNE64043.1 | 578462 | g17582 | i0 | 76.4 | 0.882352941176471 | 55 | 13 | 88.2 | 0 | 22 | 186 | 184 | 238 | KNE64043.1 arginase [Allomyces macrogynus ATCC 38327] | diamond | 165 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30412632 | 30412632 | PRJEB17675_P_NODE_25213_length_151_cov_1.034483_g24909_i0 | PRJEB17675 | 25213 | 151 | 1.034483 | 1.56206933 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 50.1 | 9.16e-6 | NR | KAI9184500.1 | 1313167 | g24909 | i0 | 48 | 0.993377483443709 | 50 | 22 | 97.4 | 2 | 149 | 3 | 43 | 89 | KAI9184500.1 hypothetical protein H9P43_003553 [Blastocladiella emersonii ATCC 22665] | diamond | 150 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30823050 | 30823050 | PRJEB17675_P_NODE_20994_length_168_cov_1.804511_g20690_i0 | PRJEB17675 | 20994 | 168 | 1.804511 | 3.03157848 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 93.2 | 1.99e-20 | NR | KAI9136275.1 | 1500003 | g20690 | i0 | 75.5 | 1.92857142857143 | 53 | 13 | 94.6 | 0 | 162 | 4 | 206 | 258 | KAI9136275.1 pyridoxal-phosphate dependent enzyme [Paraphysoderma sedebokerense] | diamond | 324 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31163874 | 31163874 | PRJEB17675_P_NODE_6435_length_370_cov_4.438806_g6132_i0 | PRJEB17675 | 6435 | 370 | 4.438806 | 16.4235822 | Eukaryota | 2759 | Fungi | Fungi | 147 | 9.22e-41 | NR | KAI9223593.1 | 64508 | g6132 | i0 | 71.4 | 12.7702702702703 | 105 | 30 | 85.1 | 0 | 317 | 3 | 1 | 105 | KAI9223593.1 hypothetical protein BC828DRAFT_403026 [Blastocladiella britannica] | diamond | 4725 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32720006 | 32720006 | PRJEB17675_P_NODE_4140_length_482_cov_2.400447_g3846_i0 | PRJEB17675 | 4140 | 482 | 2.400447 | 11.57015454 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 139 | 1.4699999999999998e-35 | NR | KNE54594.1 | 578462 | g3846 | i0 | 50.3 | 1.74273858921162 | 151 | 71 | 92.1 | 4 | 34 | 477 | 9 | 158 | KNE54594.1 hypothetical protein AMAG_00559 [Allomyces macrogynus ATCC 38327] | diamond | 840 | 139 | 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);;