contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15123336 | 15123336 | PRJNA473641_P_NODE_17632_length_251_cov_0.865169_g17549_i0 | PRJNA473641 | 17632 | 251 | 0.865169 | 2.17157419 | Pseudocercospora eumusae | 321146 | Fungi | Fungi | 175 | 2e-49 | NR | KXT01155.1 | 321146 | g17549 | i0 | 100 | 7.9362549800796804 | 83 | 0 | 99.2 | 0 | 3 | 251 | 481 | 563 | KXT01155.1 hypothetical protein AC578_602 [Pseudocercospora eumusae] | diamond | 1992 | 175 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora eumusae | |
| 19570814 | 19570814 | PRJNA473641_P_NODE_23096_length_244_cov_0.900585_g23013_i0 | PRJNA473641 | 23096 | 244 | 0.900585 | 2.1974274 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 92 | 2.32e-20 | NR | KAF7188228.1 | 685502 | g23013 | i0 | 94 | 0.614754098360656 | 50 | 3 | 61.5 | 0 | 91 | 240 | 1 | 50 | KAF7188228.1 Eukaryotic translation initiation factor 3 subunit J [Pseudocercospora fuligena] | diamond | 150 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 26918005 | 26918005 | PRJNA473641_P_NODE_23522_length_244_cov_0.900585_g23439_i0 | PRJNA473641 | 23522 | 244 | 0.900585 | 2.1974274 | Bipolaris maydis C5 | 701091 | Fungi | Fungi | 65.9 | 1.54e-10 | NR | EMD94057.1 | 701091 | g23439 | i0 | 62.8 | 3.24590163934426 | 43 | 16 | 52.9 | 0 | 114 | 242 | 30 | 72 | EMD94057.1 hypothetical protein COCHEDRAFT_1201876 [Bipolaris maydis C5] | diamond | 792 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris maydis | |
| 26997274 | 26997274 | PRJNA473641_P_NODE_18902_length_249_cov_0.875000_g18819_i0 | PRJNA473641 | 18902 | 249 | 0.875 | 2.17875 | Pseudocercospora | 131324 | Fungi | Fungi | 97.1 | 2.4e-23 | NR | KXT18522.1 | 113226 | g18819 | i0 | 70.8 | 2.34939759036145 | 65 | 18 | 78.3 | 1 | 3 | 197 | 99 | 162 | KXT18522.1 hypothetical protein AC579_2237, partial [Pseudocercospora musae] | diamond | 585 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora musae | |
| 28118358 | 28118358 | PRJNA473641_P_NODE_20545_length_247_cov_0.885057_g20462_i0 | PRJNA473641 | 20545 | 247 | 0.885057 | 2.18609079 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 137 | 1.29e-37 | NR | KAF7194133.1 | 685502 | g20462 | i0 | 80.7 | 1.0080971659919 | 83 | 15 | 99.6 | 1 | 1 | 246 | 218 | 300 | KAF7194133.1 hypothetical protein HII31_04541 [Pseudocercospora fuligena] | diamond | 249 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 28276201 | 28276201 | PRJNA473641_P_NODE_23066_length_244_cov_0.900585_g22983_i0 | PRJNA473641 | 23066 | 244 | 0.900585 | 2.1974274 | Cyphellophora europaea CBS 1 | 293227 | Fungi | Fungi | 83.2 | 2.13e-16 | NR | XP_008715106.1 | 1220924 | g22983 | i0 | 55 | 0.983606557377049 | 80 | 35 | 97.1 | 1 | 6 | 242 | 496 | 575 | XP_008715106.1 uncharacterized protein HMPREF1541_02529 [Cyphellophora europaea CBS 101466] | diamond | 240 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Cyphellophoraceae | Cyphellophora | Cyphellophora europaea | |
| 28623843 | 28623843 | PRJNA473641_P_NODE_24867_length_242_cov_0.911243_g24784_i0 | PRJNA473641 | 24867 | 242 | 0.911243 | 2.20520806 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 90.9 | 4.16e-19 | NR | KAF7190318.1 | 685502 | g24784 | i0 | 70.7 | 0.929752066115702 | 75 | 13 | 83.1 | 3 | 42 | 242 | 57 | 130 | KAF7190318.1 hypothetical protein HII31_08649 [Pseudocercospora fuligena] | diamond | 225 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 28718465 | 28718465 | PRJNA473641_P_NODE_6167_length_375_cov_1.523179_g6084_i0 | PRJNA473641 | 6167 | 375 | 1.523179 | 5.71192125 | Alyxoria varia | 91480 | Fungi | Fungi | 44.7 | 0.0322 | NR | KAI9670001.1 | 91480 | g6084 | i0 | 37.1 | 0.56 | 70 | 37 | 52.8 | 2 | 291 | 94 | 308 | 374 | KAI9670001.1 MAG: tRNA-specific adenosine deaminase subunit tad3 [Alyxoria varia] | diamond | 210 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Arthoniomycetes | Arthoniales | Lecanographaceae | Alyxoria | Alyxoria varia | |
| 28781330 | 28781330 | PRJNA473641_P_NODE_20627_length_247_cov_0.885057_g20544_i0 | PRJNA473641 | 20627 | 247 | 0.885057 | 2.18609079 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 150 | 1.29e-40 | NR | KAF7194438.1 | 685502 | g20544 | i0 | 95.1 | 0.995951417004049 | 82 | 4 | 99.6 | 0 | 246 | 1 | 466 | 547 | KAF7194438.1 Dihydroxyacetone kinase 1 [Pseudocercospora fuligena] | diamond | 246 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 29223737 | 29223737 | PRJNA473641_P_NODE_19269_length_249_cov_0.875000_g19186_i0 | PRJNA473641 | 19269 | 249 | 0.875 | 2.17875 | Pseudocercospora eumusae | 321146 | Fungi | Fungi | 82 | 1.95e-17 | NR | KXS99900.1 | 321146 | g19186 | i0 | 50 | 1.53012048192771 | 64 | 32 | 77.1 | 0 | 239 | 48 | 102 | 165 | KXS99900.1 hypothetical protein AC578_914 [Pseudocercospora eumusae] | diamond | 381 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora eumusae | |
| 29286586 | 29286586 | PRJNA473641_P_NODE_7689_length_346_cov_1.780220_g7606_i0 | PRJNA473641 | 7689 | 346 | 1.78022 | 6.1595612 | Fulvia fulva | 5499 | Fungi | Fungi | 70.5 | 1.69e-13 | NR | XP_047764672.1 | 5499 | g7606 | i0 | 61.4 | 0.494219653179191 | 57 | 20 | 49.4 | 1 | 52 | 222 | 8 | 62 | XP_047764672.1 Avr9 [Fulvia fulva] | diamond | 171 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 29318193 | 29318193 | PRJNA473641_P_NODE_17049_length_251_cov_0.865169_g16966_i0 | PRJNA473641 | 17049 | 251 | 0.865169 | 2.17157419 | Colletotrichum abscissum | 1671311 | Fungi | Fungi | 91.3 | 1.2300000000000002e-21 | NR | KAI3558882.1 | 1671311 | g16966 | i0 | 55.1 | 0.932270916334661 | 78 | 32 | 92 | 3 | 12 | 242 | 24 | 99 | KAI3558882.1 hypothetical protein CABS02_00922 [Colletotrichum abscissum] | diamond | 234 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum abscissum | |
| 29444334 | 29444334 | PRJNA473641_P_NODE_22690_length_245_cov_0.895349_g22607_i0 | PRJNA473641 | 22690 | 245 | 0.895349 | 2.19360505 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 140 | 2.9999999999999996e-39 | NR | XP_064754086.1 | 1690604 | g22607 | i0 | 79 | 1.98367346938776 | 81 | 17 | 99.2 | 0 | 3 | 245 | 53 | 133 | XP_064754086.1 plasma membrane heat shock protein [Lithohypha guttulata] | diamond | 486 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 29444339 | 29444339 | PRJNA473641_P_NODE_6610_length_366_cov_1.051195_g6527_i0 | PRJNA473641 | 6610 | 366 | 1.051195 | 3.8473737 | Lasiodiplodia theobromae | 45133 | Fungi | Fungi | 71.6 | 7.91e-12 | NR | XP_035368743.1 | 45133 | g6527 | i0 | 43 | 1.40983606557377 | 86 | 44 | 68.9 | 2 | 293 | 42 | 227 | 309 | XP_035368743.1 2OG-Fe oxygenase [Lasiodiplodia theobromae] | diamond | 516 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Lasiodiplodia | Lasiodiplodia theobromae | |
| 29823233 | 29823233 | PRJNA473641_P_NODE_13931_length_277_cov_1.509804_g13848_i0 | PRJNA473641 | 13931 | 277 | 1.509804 | 4.18215708 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 91.7 | 5.51e-20 | NR | KAF7197282.1 | 685502 | g13848 | i0 | 85.2 | 0.660649819494585 | 61 | 9 | 66.1 | 0 | 183 | 1 | 1 | 61 | KAF7197282.1 Short-chain dehydrogenase/reductase aba4 [Pseudocercospora fuligena] | diamond | 183 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 29855117 | 29855117 | PRJNA473641_P_NODE_18311_length_250_cov_0.870056_g18228_i0 | PRJNA473641 | 18311 | 250 | 0.870056 | 2.17514 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 60.8 | 4.37e-9 | NR | KAF7196994.1 | 685502 | g18228 | i0 | 36 | 1.332 | 111 | 25 | 97.2 | 3 | 1 | 243 | 83 | 177 | KAF7196994.1 hypothetical protein HII31_01694 [Pseudocercospora fuligena] | diamond | 333 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 30044495 | 30044495 | PRJNA473641_P_NODE_17551_length_251_cov_0.865169_g17468_i0 | PRJNA473641 | 17551 | 251 | 0.865169 | 2.17157419 | Exophiala bonariae | 1690606 | Fungi | Fungi | 58.9 | 8.24e-8 | NR | XP_064711830.1 | 1690606 | g17468 | i0 | 66.7 | 0.872509960159363 | 39 | 13 | 46.6 | 0 | 119 | 3 | 275 | 313 | XP_064711830.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Exophiala bonariae] | diamond | 219 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala bonariae | |
| 30202335 | 30202335 | PRJNA473641_P_NODE_24092_length_243_cov_0.905882_g24009_i0 | PRJNA473641 | 24092 | 243 | 0.905882 | 2.20129326 | Pseudocercospora fuligena | 685502 | Fungi | Fungi | 145 | 7.879999999999999e-40 | NR | KAF7187429.1 | 685502 | g24009 | i0 | 95 | 0.987654320987654 | 80 | 4 | 98.8 | 0 | 242 | 3 | 62 | 141 | KAF7187429.1 Zinc finger protein [Pseudocercospora fuligena] | diamond | 240 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fuligena | |
| 31371955 | 31371955 | PRJNA473641_P_NODE_12796_length_287_cov_1.439252_g12713_i0 | PRJNA473641 | 12796 | 287 | 1.439252 | 4.13065324 | Orbilia brochopaga | 3140254 | Fungi | Fungi | 83.2 | 3.71e-16 | NR | KAK6338639.1 | 3140254 | g12713 | i0 | 42.6 | 0.982578397212544 | 94 | 51 | 98.3 | 1 | 2 | 283 | 447 | 537 | KAK6338639.1 hypothetical protein TWF696_009450 [Orbilia brochopaga] | diamond | 282 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia brochopaga | |
| 31371957 | 31371957 | PRJNA473641_P_NODE_19156_length_249_cov_0.875000_g19073_i0 | PRJNA473641 | 19156 | 249 | 0.875 | 2.17875 | Pseudocercospora eumusae | 321146 | Fungi | Fungi | 92 | 1.35e-19 | NR | KXS95072.1 | 321146 | g19073 | i0 | 69.3 | 0.903614457831325 | 75 | 18 | 90.4 | 1 | 247 | 23 | 386 | 455 | KXS95072.1 hypothetical protein AC578_9573 [Pseudocercospora eumusae] | diamond | 225 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora eumusae | |
| 31498461 | 31498461 | PRJNA473641_P_NODE_13896_length_278_cov_0.917073_g13813_i0 | PRJNA473641 | 13896 | 278 | 0.917073 | 2.54946294 | Candidozyma auris | 498019 | Fungi | Fungi | 75.1 | 2.4e-13 | NR | QWW22638.1 | 498019 | g13813 | i0 | 55.6 | 5.17985611510791 | 63 | 28 | 68 | 0 | 86 | 274 | 39 | 101 | QWW22638.1 hypothetical protein CA7LBN_001384 [Candidozyma auris] | diamond | 1440 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Candidozyma | Candidozyma auris | |
| 31751205 | 31751205 | PRJNA473641_P_NODE_2037_length_585_cov_3.138672_g1955_i0 | PRJNA473641 | 2037 | 585 | 3.138672 | 18.3612312 | Fulvia fulva | 5499 | Fungi | Fungi | 52.4 | 4.89e-5 | NR | XP_047764613.1 | 5499 | g1955 | i0 | 51.8 | 0.287179487179487 | 56 | 24 | 27.2 | 1 | 535 | 377 | 1 | 56 | XP_047764613.1 uncharacterized protein CLAFUR5_10231 [Fulvia fulva] | diamond | 168 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 32479232 | 32479232 | PRJNA473641_P_NODE_23459_length_244_cov_0.900585_g23376_i0 | PRJNA473641 | 23459 | 244 | 0.900585 | 2.1974274 | Pseudocercospora eumusae | 321146 | Fungi | Fungi | 160 | 1.5499999999999996e-43 | NR | KXS96183.1 | 321146 | g23376 | i0 | 97.5 | 0.983606557377049 | 80 | 2 | 98.4 | 0 | 3 | 242 | 1424 | 1503 | KXS96183.1 hypothetical protein AC578_2670 [Pseudocercospora eumusae] | diamond | 240 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora eumusae |
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);;