contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1241156" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29094772 | 29094772 | PRJNA1241156_S_NODE_34988_length_316_cov_2.864469_g34528_i0 | PRJNA1241156 | 34988 | 316 | 2.864469 | 9.05172204 | Naumovozyma dairenensis CBS 421 | 1071378 | Fungi | Fungi | 44.7 | 0.0188 | NR | XP_003668149.1 | 1071378 | g34528 | i0 | 37.3 | 1.4620253164557 | 51 | 32 | 48.4 | 0 | 134 | 286 | 217 | 267 | XP_003668149.1 uncharacterized protein NDAI_0A07520 [Naumovozyma dairenensis CBS 421] | diamond | 462 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Naumovozyma | Naumovozyma dairenensis | |
| 29094777 | 29094777 | PRJNA1241156_S_NODE_65508_length_242_cov_4.201005_g65048_i0 | PRJNA1241156 | 65508 | 242 | 4.201005 | 10.1664321 | Aspergillus lentulus | 293939 | Fungi | Fungi | 44.3 | 0.0104 | NR | KAF4187276.1 | 293939 | g65048 | i0 | 42 | 0.619834710743802 | 50 | 29 | 62 | 0 | 162 | 13 | 350 | 399 | KAF4187276.1 hypothetical protein CNMCM8694_005641 [Aspergillus lentulus] | diamond | 150 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus lentulus | |
| 29126487 | 29126487 | PRJNA1241156_S_NODE_40309_length_301_cov_6.558140_g39849_i0 | PRJNA1241156 | 40309 | 301 | 6.55814 | 19.7400014 | Cirrosporium novae-zelandiae | 1130053 | Fungi | Fungi | 43.5 | 0.0387 | NR | KAI9737909.1 | 1130053 | g39849 | i0 | 41.7 | 0.598006644518272 | 60 | 31 | 56.8 | 2 | 9 | 179 | 599 | 657 | KAI9737909.1 MAG: hypothetical protein M1834_009279 [Cirrosporium novae-zelandiae] | diamond | 180 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Xylobotryomycetes | Xylobotryales | Cirrosporiaceae | Cirrosporium | Cirrosporium novae-zelandiae | |
| 29315654 | 29315654 | PRJNA1241156_S_NODE_37589_length_309_cov_2.285714_g37129_i0 | PRJNA1241156 | 37589 | 309 | 2.285714 | 7.06285626 | Saccharomyces paradoxus | 27291 | Fungi | Fungi | 124 | 8.110000000000001e-33 | NR | XP_033768208.1 | 27291 | g37129 | i0 | 89.9 | 2.43689320388349 | 89 | 9 | 86.4 | 0 | 269 | 3 | 2 | 90 | XP_033768208.1 Dat1 [Saccharomyces paradoxus] | diamond | 753 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces paradoxus | |
| 29947259 | 29947259 | PRJNA1241156_S_NODE_55051_length_264_cov_2.628959_g54591_i0 | PRJNA1241156 | 55051 | 264 | 2.628959 | 6.94045176 | Apiosordaria backusii | 314023 | Fungi | Fungi | 42.7 | 0.045 | NR | KAK0741742.1 | 314023 | g54591 | i0 | 36.5 | 0.840909090909091 | 74 | 46 | 84.1 | 1 | 41 | 262 | 4 | 76 | KAK0741742.1 hypothetical protein B0T21DRAFT_119077 [Apiosordaria backusii] | diamond | 222 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Apiosordaria | Apiosordaria backusii | |
| 30768737 | 30768737 | PRJNA1241156_S_NODE_43934_length_292_cov_1.718876_g43474_i0 | PRJNA1241156 | 43934 | 292 | 1.718876 | 5.01911792 | Stachybotrys chartarum IBT 4 | 74722 | Fungi | Fungi | 43.5 | 0.0326 | NR | KFA52435.1 | 1280524 | g43474 | i0 | 31.7 | 0.616438356164384 | 60 | 37 | 60.6 | 2 | 233 | 57 | 190 | 246 | KFA52435.1 hypothetical protein S40293_11584 [Stachybotrys chartarum IBT 40293] | diamond | 180 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Stachybotrys | Stachybotrys chartarum | |
| 31179106 | 31179106 | PRJNA1241156_S_NODE_31395_length_326_cov_3.925795_g30935_i0 | PRJNA1241156 | 31395 | 326 | 3.925795 | 12.7980917 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 170 | 3.36e-49 | NR | WPG98869.1 | 150365 | g30935 | i0 | 95.3 | 0.782208588957055 | 85 | 4 | 78.2 | 0 | 3 | 257 | 301 | 385 | WPG98869.1 Hypothetical protein R9X50_00166700 [Acrodontium crateriforme] | diamond | 255 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme |
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);;