contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1595165 | 1595165 | PRJNA1192965_P_NODE_3822_length_248_cov_0.880000_g3803_i0 | PRJNA1192965 | 3822 | 248 | 0.88 | 2.1824 | Aureobasidium namibiae | 559561 | Fungi | Fungi | 318 | 1.9999999999999996e-82 | NTclustered | gi|918803023|ref|XM_013569249.1| | 1043004 | g3803 | i0 | 90.164 | 2.95967741935484 | 244 | 24 | 98 | 0 | 5 | 248 | 677 | 920 | Aureobasidium namibiae CBS 147.97 uncharacterized protein (M436DRAFT_75259), partial mRNA | blastn | 734 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium namibiae | |
| 2871302 | 2871302 | PRJNA1192965_P_NODE_663_length_461_cov_1.469072_g644_i0 | PRJNA1192965 | 663 | 461 | 1.469072 | 6.77242192 | Lecanicillium sp. | 1756136 | Fungi | Fungi | 473 | 8.06e-129 | NTclustered | gi|2642121701|dbj|LC553291.1| | 1756136 | g644 | i0 | 86.697 | 93.7418655097614 | 436 | 46 | 93 | 10 | 32 | 461 | 342 | 771 | Lecanicillium sp. JCM 39058 EF1-alpha gene, partial sequence | blastn | 43215 | 473 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. | |
| 4147413 | 4147413 | PRJNA1192965_P_NODE_2164_length_291_cov_1.756881_g2145_i0 | PRJNA1192965 | 2164 | 291 | 1.756881 | 5.11252371 | Henningerozyma blattae | 1071379 | Fungi | Fungi | 235 | 2.4899999999999997e-57 | NTclustered | gi|444323815|ref|XM_004182500.1| | 1071380 | g2145 | i0 | 81.315 | 93.1580756013746 | 289 | 54 | 99 | 0 | 1 | 289 | 592 | 304 | Henningerozyma blattae CBS 6284 40S ribosomal protein uS7 (TBLA0J00290), partial mRNA | blastn | 27109 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Henningerozyma | Henningerozyma blattae | |
| 4147437 | 4147437 | PRJNA1192965_P_NODE_664_length_460_cov_1.816537_g645_i0 | PRJNA1192965 | 664 | 460 | 1.816537 | 8.3560702 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 850 | 0 | NTclustered | gi|160918923|gb|EU256373.1| | 4952 | g645 | i0 | 100 | 99.3673913043478 | 460 | 0 | 100 | 0 | 1 | 460 | 784 | 325 | Yarrowia lipolytica strain MSR 80 26S ribosomal RNA gene, partial sequence | blastn | 45709 | 850 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 4870463 | 4870463 | PRJNA1192965_P_NODE_3924_length_247_cov_2.643678_g3905_i0 | PRJNA1192965 | 3924 | 247 | 2.643678 | 6.52988466 | Pleosporales | 92860 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|1473247283|gb|MH860227.1| | 1892770 | g3905 | i0 | 100 | 98.5627530364372 | 247 | 0 | 100 | 0 | 1 | 247 | 981 | 735 | Pithomyces chartarum culture CBS:485.71 strain CBS 485.71 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 | 24345 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Pseudopithomyces | Pseudopithomyces chartarum | |
| 6698369 | 6698369 | PRJNA1192965_P_NODE_2726_length_269_cov_1.367347_g2707_i0 | PRJNA1192965 | 2726 | 269 | 1.367347 | 3.67816343 | Colletotrichum chrysophilum | 1836956 | Fungi | Fungi | 215 | 2.97e-51 | NTclustered | gi|2432638296|ref|XM_053174004.1| | 1836956 | g2707 | i0 | 81.181 | 13.4052044609665 | 271 | 47 | 100 | 4 | 1 | 269 | 629 | 897 | Colletotrichum chrysophilum 26S proteasome regulatory subunit 7 (RPT1), partial mRNA | blastn | 3606 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum chrysophilum | |
| 7973780 | 7973780 | PRJNA1192965_P_NODE_3547_length_250_cov_0.870056_g3528_i0 | PRJNA1192965 | 3547 | 250 | 0.870056 | 2.17514 | Scheffersomyces amazonensis | 1078765 | Fungi | Fungi | 139 | 1.6899999999999999e-28 | NTclustered | gi|2725048846|ref|XM_064884413.1| | 1078765 | g3528 | i0 | 81.25 | 4.62 | 176 | 30 | 70 | 3 | 62 | 236 | 834 | 1007 | Scheffersomyces amazonensis S-adenosylmethionine synthetase 2 (RJT21DRAFT_38816), mRNA | blastn | 1155 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces amazonensis | |
| 7973792 | 7973792 | PRJNA1192965_P_NODE_4607_length_244_cov_0.900585_g4588_i0 | PRJNA1192965 | 4607 | 244 | 0.900585 | 2.1974274 | Chaetomium tenue | 1854479 | Fungi | Fungi | 132 | 2.75e-26 | NTclustered | gi|2781226593|ref|XM_066786474.1| | 1854479 | g4588 | i0 | 79.612 | 19.8893442622951 | 206 | 25 | 80 | 12 | 44 | 239 | 1037 | 1235 | Chaetomium tenue heat shock protein 90 (F5144DRAFT_506618), mRNA | blastn | 4853 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Chaetomium | Chaetomium tenue | |
| 9248421 | 9248421 | PRJNA1192965_P_NODE_2288_length_286_cov_1.446009_g2269_i0 | PRJNA1192965 | 2288 | 286 | 1.446009 | 4.13558574 | Aspergillus citrinoterreus | 1577496 | Fungi | Fungi | 141 | 5.48e-29 | NTclustered | gi|2735172535|gb|CP155522.1| | 1577496 | g2269 | i0 | 82.424 | 8.08041958041958 | 165 | 25 | 58 | 2 | 5 | 169 | 1981229 | 1981389 | Aspergillus citrinoterreus strain CBS138921 chromosome III | blastn | 2311 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus citrinoterreus | |
| 9970516 | 9970516 | PRJNA1192965_P_NODE_3248_length_251_cov_1.730337_g3229_i0 | PRJNA1192965 | 3248 | 251 | 1.730337 | 4.34314587 | Candidozyma | 3303203 | Fungi | Fungi | 220 | 5.89e-53 | NTclustered | gi|1383851160|ref|XM_024857686.1| | 418784 | g3229 | i0 | 85.116 | 20.1792828685259 | 215 | 32 | 86 | 0 | 34 | 248 | 299 | 85 | [Candida] pseudohaemulonii 60S ribosomal protein L44 (C7M61_002308), partial mRNA | blastn | 5065 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Candidozyma | Candidozyma pseudohaemuli | |
| 13795747 | 13795747 | PRJNA1192965_P_NODE_2991_length_260_cov_0.823529_g2972_i0 | PRJNA1192965 | 2991 | 260 | 0.823529 | 2.1411754 | Pleosporaceae | 28556 | Fungi | Fungi | 475 | 1.1899999999999999e-129 | NTclustered | gi|2089999217|gb|OK036399.1| | 48100 | g2972 | i0 | 99.615 | 100 | 260 | 1 | 100 | 0 | 1 | 260 | 279 | 20 | Alternaria solani isolate AHaAsL large subunit ribosomal RNA gene, partial sequence | blastn | 26000 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria solani | |
| 15070098 | 15070098 | PRJNA1192965_P_NODE_3412_length_251_cov_0.865169_g3393_i0 | PRJNA1192965 | 3412 | 251 | 0.865169 | 2.17157419 | Trichophyton | 5550 | Fungi | Fungi | 121 | 6.149999999999999e-23 | NTclustered | gi|302653449|ref|XM_003018505.1| | 663202 | g3393 | i0 | 91.011 | 2.11155378486056 | 89 | 8 | 35 | 0 | 157 | 245 | 497 | 409 | Trichophyton verrucosum HKI 0517 RAN small monomeric GTPase (Ran), putative (TRV_07436), partial mRNA | blastn | 530 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton verrucosum | |
| 15623284 | 15623284 | PRJNA1192965_P_NODE_1973_length_302_cov_1.659389_g1954_i0 | PRJNA1192965 | 1973 | 302 | 1.659389 | 5.01135478 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 558 | 1.36e-154 | NTclustered | gi|1209454411|ref|NG_055393.1| | 4952 | g1954 | i0 | 100 | 98.0827814569536 | 302 | 0 | 100 | 0 | 1 | 302 | 1390 | 1691 | Yarrowia lipolytica NRRL YB-423 28S rRNA, partial sequence; from TYPE material | blastn | 29621 | 558 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 19446559 | 19446559 | PRJNA1192965_P_NODE_5296_length_230_cov_2.439490_g5277_i0 | PRJNA1192965 | 5296 | 230 | 2.43949 | 5.610827 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 368 | 1.7999999999999995e-97 | NTclustered | gi|1209454411|ref|NG_055393.1| | 4952 | g5277 | i0 | 99.502 | 19.9260869565217 | 201 | 1 | 87 | 0 | 30 | 230 | 3076 | 2876 | Yarrowia lipolytica NRRL YB-423 28S rRNA, partial sequence; from TYPE material | blastn | 4583 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 25268586 | 25268586 | PRJNA1192965_P_NODE_4240_length_246_cov_0.890173_g4221_i0 | PRJNA1192965 | 4240 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g4221 | i0 | 100 | 74.8577235772358 | 246 | 0 | 100 | 0 | 1 | 246 | 8913664 | 8913909 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 18415 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae |
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);;