contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1242190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1625612 | 1625612 | PRJNA1242190_S_NODE_4782_length_373_cov_1.983333_g4775_i0 | PRJNA1242190 | 4782 | 373 | 1.983333 | 7.39783209 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 176 | 2.02e-39 | NTclustered | gi|2086737472|ref|XM_043280055.1| | 182096 | g4775 | i0 | 82.212 | 6.35388739946381 | 208 | 33 | 55 | 3 | 1 | 206 | 76 | 281 | Aspergillus chevalieri 60S ribosomal protein eL42 (RPL44), partial mRNA | blastn | 2370 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 5454288 | 5454288 | PRJNA1242190_S_NODE_10205_length_270_cov_2.862944_g10198_i0 | PRJNA1242190 | 10205 | 270 | 2.862944 | 7.7299488 | Candida oxycetoniae | 497107 | Fungi | Fungi | 84.2 | 8.78e-12 | NTclustered | gi|2272265527|ref|XM_049326192.1| | 497107 | g10198 | i0 | 92.982 | 1.02962962962963 | 57 | 4 | 21 | 0 | 7 | 63 | 346 | 402 | Candida oxycetoniae RPL23A (KGF56_004724), partial mRNA | blastn | 278 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida oxycetoniae | |
| 6728725 | 6728725 | PRJNA1242190_S_NODE_6126_length_336_cov_3.863118_g6119_i0 | PRJNA1242190 | 6126 | 336 | 3.863118 | 12.98007648 | Sordaria macrospora | 5147 | Fungi | Fungi | 86.1 | 3.13e-12 | NTclustered | gi|2749654334|ref|XM_003344831.2| | 5147 | g6119 | i0 | 90.625 | 0.49702380952381 | 64 | 6 | 19 | 0 | 204 | 267 | 598 | 535 | Sordaria macrospora 60S ribosomal protein eL18 (SMAC4_06165), mRNA | blastn | 167 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Sordaria | Sordaria macrospora | |
| 6728735 | 6728735 | PRJNA1242190_S_NODE_6586_length_327_cov_3.082677_g6579_i0 | PRJNA1242190 | 6586 | 327 | 3.082677 | 10.08035379 | Sordaria macrospora | 5147 | Fungi | Fungi | 102 | 3.01e-17 | NTclustered | gi|2749654334|ref|XM_003344831.2| | 5147 | g6579 | i0 | 95.312 | 6.7737003058104 | 64 | 3 | 20 | 0 | 111 | 174 | 535 | 598 | Sordaria macrospora 60S ribosomal protein eL18 (SMAC4_06165), mRNA | blastn | 2215 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Sordaria | Sordaria macrospora | |
| 8703897 | 8703897 | PRJNA1242190_S_NODE_4167_length_394_cov_2.663551_g4160_i0 | PRJNA1242190 | 4167 | 394 | 2.663551 | 10.49439094 | Debaryomycetaceae | 766764 | Fungi | Fungi | 113 | 1.7e-20 | NTclustered | gi|2083595464|ref|XM_043191105.1| | 45513 | g4160 | i0 | 85.981 | 13.9010152284264 | 107 | 13 | 27 | 2 | 100 | 205 | 51 | 156 | Scheffersomyces spartinae 60S ribosomal protein L39 (RPL39), partial mRNA | blastn | 5477 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces spartinae | |
| 9279153 | 9279153 | PRJNA1242190_S_NODE_5628_length_349_cov_1.199275_g5621_i0 | PRJNA1242190 | 5628 | 349 | 1.199275 | 4.18546975 | Kuraishia capsulata | 317047 | Fungi | Fungi | 54.7 | 0.009 | NTclustered | gi|1247152413|ref|XM_022602865.1| | 1382522 | g5621 | i0 | 100 | 0.0830945558739255 | 29 | 0 | 8 | 0 | 20 | 48 | 1124 | 1152 | Kuraishia capsulata CBS 1993 uncharacterized protein (KUCA_T00002598001), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Kuraishia | Kuraishia capsulata | |
| 10554998 | 10554998 | PRJNA1242190_S_NODE_2969_length_448_cov_2.157333_g2962_i0 | PRJNA1242190 | 2969 | 448 | 2.157333 | 9.66485184 | Debaryomyces fabryi | 58627 | Fungi | Fungi | 233 | 1.44e-56 | NTclustered | gi|998534082|ref|XM_015609769.1| | 58627 | g2962 | i0 | 83.27 | 6.40401785714286 | 263 | 34 | 58 | 9 | 160 | 417 | 387 | 130 | Debaryomyces fabryi 40S ribosomal protein S13 (AC631_00939), partial mRNA | blastn | 2869 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces fabryi | |
| 13104703 | 13104703 | PRJNA1242190_S_NODE_10471_length_267_cov_1.608247_g10464_i0 | PRJNA1242190 | 10471 | 267 | 1.608247 | 4.29401949 | Lipomyces japonicus | 56871 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2781543605|ref|XM_066928808.1| | 56871 | g10464 | i0 | 100 | 0.112359550561798 | 30 | 0 | 11 | 0 | 16 | 45 | 1010 | 981 | Lipomyces japonicus uncharacterized protein (V1514DRAFT_338271), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces japonicus | |
| 14380039 | 14380039 | PRJNA1242190_S_NODE_3452_length_425_cov_1.491477_g3445_i0 | PRJNA1242190 | 3452 | 425 | 1.491477 | 6.33877725 | Aspergillus alliaceus | 209559 | Fungi | Fungi | 104 | 1.11e-17 | NTclustered | gi|1800286102|ref|XM_032042410.1| | 209559 | g3445 | i0 | 96.774 | 14.7670588235294 | 62 | 2 | 15 | 0 | 1 | 62 | 708 | 769 | Aspergillus alliaceus 60S ribosomal protein uL2 (BDW43DRAFT_280407), mRNA | blastn | 6276 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus alliaceus | |
| 25277263 | 25277263 | PRJNA1242190_S_NODE_8600_length_292_cov_1.698630_g8593_i0 | PRJNA1242190 | 8600 | 292 | 1.69863 | 4.9599996 | Ascomycota | 4890 | Fungi | Fungi | 106 | 2.05e-18 | NTclustered | gi|126133435|ref|XM_001383206.1| | 322104 | g8593 | i0 | 84.071 | 3.76027397260274 | 113 | 15 | 38 | 3 | 128 | 238 | 138 | 27 | Scheffersomyces stipitis CBS 6054 60S ribosomal protein L39 (RPL39B), partial mRNA | blastn | 1098 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces stipitis |
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);;