contig_metadata
11 rows where bioproject = "PRJEB6054", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523221 | 25523221 | PRJEB6054_S_NODE_6265_length_207_cov_1.430233_g6176_i0 | PRJEB6054 | 6265 | 207 | 1.430233 | 2.96058231 | Candida orthopsilosis Co 9 | 273371 | Fungi | Fungi | 58.4 | 3.89e-4 | NTclustered | gi|448520311|ref|XM_003868228.1| | 1136231 | g6176 | i0 | 94.595 | 0.178743961352657 | 37 | 2 | 18 | 0 | 90 | 126 | 256 | 220 | Candida orthopsilosis Co 90-125 peptidyl-prolyl cis-trans isomerase (CORT_0B11430), partial mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida orthopsilosis | |
| 25751894 | 25751894 | PRJEB6054_S_NODE_5842_length_212_cov_1669.429379_g5753_i0 | PRJEB6054 | 5842 | 212 | 1669.429379 | 3539.19028348 | root | 1 | Root_unresolved | Root_unresolved | 281 | 2.18e-71 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g5753 | i0 | 100 | 71.7028301886792 | 152 | 0 | 72 | 0 | 1 | 152 | 553 | 704 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 15201 | 283 | 0.992932862190813 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 25887596 | 25887596 | PRJEB6054_S_NODE_2475_length_284_cov_26.598394_g2386_i0 | PRJEB6054 | 2475 | 284 | 26.598394 | 75.53943896 | Eukaryota | 2759 | Fungi | Fungi | 525 | 1.2899999999999994e-144 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g2386 | i0 | 100 | 87.3028169014084 | 284 | 0 | 100 | 0 | 1 | 284 | 308 | 25 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 24794 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 25931409 | 25931409 | PRJEB6054_S_NODE_6532_length_203_cov_6.720238_g6443_i0 | PRJEB6054 | 6532 | 203 | 6.720238 | 13.64208314 | Exophiala lecanii-corni | 91925 | Fungi | Fungi | 135 | 1.71e-27 | NTclustered | gi|1538946180|gb|CP034382.1| | 91925 | g6443 | i0 | 85.075 | 0.660098522167488 | 134 | 18 | 66 | 2 | 1 | 133 | 3405 | 3537 | Exophiala lecanii-corni strain CBS 102400 mitochondrion, complete genome | blastn | 134 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala lecanii-corni | |
| 26160043 | 26160043 | PRJEB6054_S_NODE_1493_length_334_cov_1528.187291_g1404_i0 | PRJEB6054 | 1493 | 334 | 1528.187291 | 5104.14555194 | Fusarium | 5506 | Fungi | Fungi | 488 | 2.03e-133 | NTclustered | gi|1248497271|tpe|LT906358.1| | 5507 | g1404 | i0 | 98.551 | 82.4161676646707 | 276 | 4 | 83 | 0 | 59 | 334 | 30467 | 30192 | TPA_asm: Fusarium oxysporum strain UASWS_AC1 complete mitochondrion genome | blastn | 27527 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 26160139 | 26160139 | PRJEB6054_S_NODE_7125_length_197_cov_2.814815_g7036_i0 | PRJEB6054 | 7125 | 197 | 2.814815 | 5.54518555 | Fusarium | 5506 | Fungi | Fungi | 359 | 8.98e-95 | NTclustered | gi|2172391745|gb|OM106504.1| | 29916 | g7036 | i0 | 99.492 | 100 | 197 | 1 | 100 | 0 | 1 | 197 | 540 | 736 | Fusarium sp. isolate GLBRC306 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19700 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium sp. | |
| 26203493 | 26203493 | PRJEB6054_S_NODE_13846_length_157_cov_1.303279_g13757_i0 | PRJEB6054 | 13846 | 157 | 1.303279 | 2.04614803 | Botrytis cinerea B | 40559 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1377702045|ref|XM_024690863.1| | 332648 | g13757 | i0 | 100 | 0.184713375796178 | 29 | 0 | 18 | 0 | 52 | 80 | 538 | 510 | Botrytis cinerea B05.10 hypothetical protein (BCIN_01g09830), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 26339301 | 26339301 | PRJEB6054_S_NODE_1495_length_334_cov_145.959866_g1406_i0 | PRJEB6054 | 1495 | 334 | 145.959866 | 487.50595244 | Candida pseudojiufengensis | 497109 | Fungi | Fungi | 75 | 6.72e-9 | NTclustered | gi|2325086120|ref|XM_051758727.1| | 497109 | g1406 | i0 | 87.5 | 10.7544910179641 | 64 | 8 | 19 | 0 | 43 | 106 | 1202 | 1265 | Candida pseudojiufengensis nop56 (KGF55_003885), partial mRNA | blastn | 3592 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida pseudojiufengensis | |
| 26431718 | 26431718 | PRJEB6054_S_NODE_11111_length_170_cov_2.377778_g11022_i0 | PRJEB6054 | 11111 | 170 | 2.377778 | 4.0422226 | root | 1 | Root_unresolved | Root_unresolved | 315 | 1.64e-81 | NTclustered | gi|2612872|gb|AF010303.1| | 63354 | g11022 | i0 | 100 | 100 | 170 | 0 | 100 | 0 | 1 | 170 | 663 | 832 | Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence | blastn | 17000 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotiniaceae sp. BSC-97 | ||
| 26475543 | 26475543 | PRJEB6054_S_NODE_1184_length_359_cov_3.262346_g1096_i0 | PRJEB6054 | 1184 | 359 | 3.262346 | 11.71182214 | Candida jiufengensis | 497108 | Fungi | Fungi | 89.8 | 2.59e-13 | NTclustered | gi|2325100059|ref|XM_051765490.1| | 497108 | g1096 | i0 | 77.358 | 2.74930362116992 | 159 | 30 | 43 | 4 | 201 | 356 | 328 | 173 | Candida jiufengensis uncharacterized protein (KGF54_004758), partial mRNA | blastn | 987 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida jiufengensis | |
| 32928912 | 32928912 | PRJEB6054_S_NODE_7897_length_190_cov_2.535484_g7808_i0 | PRJEB6054 | 7897 | 190 | 2.535484 | 4.8174196 | Cercophora scortea | 314031 | Fungi | Fungi | 42 | 0.0147 | NR | KAK3335352.1 | 314031 | g7808 | i0 | 39.1 | 0.726315789473684 | 46 | 28 | 72.6 | 0 | 167 | 30 | 82 | 127 | KAK3335352.1 hypothetical protein B0T19DRAFT_5808 [Cercophora scortea] | diamond | 138 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Cercophora | Cercophora scortea |
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);;