contig_metadata
16 rows where bioproject = "PRJNA397736" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3630698 | 3630698 | PRJNA397736_S_NODE_2443_length_171_cov_13.359155_g2407_i0 | PRJNA397736 | 2443 | 171 | 13.359155 | 22.84415505 | Physciaceae | 50934 | Fungi | Fungi | 316 | 4.6e-82 | NTclustered | gi|1895681276|gb|MT913588.1| | 116805 | g2407 | i0 | 100 | 99.9590643274854 | 171 | 0 | 100 | 0 | 1 | 171 | 1242 | 1072 | Phaeophyscia orbicularis isolate DM1079 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 | 17093 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Phaeophyscia | Phaeophyscia orbicularis | |
| 6182979 | 6182979 | PRJNA397736_S_NODE_1065_length_277_cov_26.233871_g1029_i0 | PRJNA397736 | 1065 | 277 | 26.233871 | 72.66782267 | Pezizales | 5185 | Fungi | Fungi | 464 | 2.7599999999999994e-126 | NTclustered | gi|158934254|emb|AM748736.1| | 39416 | g1029 | i0 | 98.127 | 96.3898916967509 | 267 | 4 | 96 | 1 | 1 | 266 | 669 | 935 | Tuber melanosporum partial 18S rRNA gene, isolate M106 | blastn | 26700 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Tuber | Tuber melanosporum | |
| 7457831 | 7457831 | PRJNA397736_S_NODE_1066_length_277_cov_23.362903_g1030_i0 | PRJNA397736 | 1066 | 277 | 23.362903 | 64.71524131 | Ascomycota | 4890 | Fungi | Fungi | 425 | 1.3e-114 | NTclustered | gi|2804617|gb|U86693.1|STU86693 | 57085 | g1030 | i0 | 95.506 | 96.3754512635379 | 267 | 11 | 96 | 1 | 1 | 266 | 750 | 1016 | Sphinctrina turbinata 18S SSU ribosomal RNA, partial sequence | blastn | 26696 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Mycocaliciales | Sphinctrinaceae | Sphinctrina | Sphinctrina turbinata | |
| 7457835 | 7457835 | PRJNA397736_S_NODE_246_length_606_cov_17.464471_g214_i1 | PRJNA397736 | 246 | 606 | 17.464471 | 105.83469426 | Physciaceae | 50934 | Fungi | Fungi | 1011 | 0 | NTclustered | gi|1895681276|gb|MT913588.1| | 116805 | g214 | i1 | 96.865 | 99.1518151815181 | 606 | 15 | 99 | 3 | 1 | 604 | 484 | 1087 | Phaeophyscia orbicularis isolate DM1079 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 | 60086 | 1011 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Phaeophyscia | Phaeophyscia orbicularis | |
| 8732697 | 8732697 | PRJNA397736_S_NODE_87_length_944_cov_158.506011_g78_i0 | PRJNA397736 | 87 | 944 | 158.506011 | 1496.29674384 | root | 1 | Root_unresolved | Root_unresolved | 62.1 | 1.59e-4 | NTclustered | gi|1759050525|gb|CP039672.1| | 13684 | g78 | i0 | 97.222 | 0.578389830508475 | 36 | 1 | 4 | 0 | 1 | 36 | 1538442 | 1538407 | Parastagonospora nodorum strain Sn79 chromosome 8 | blastn | 546 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 10616032 | 10616032 | PRJNA397736_S_NODE_1569_length_221_cov_22.963542_g1533_i0 | PRJNA397736 | 1569 | 221 | 22.963542 | 50.74942782 | Physconia distorta | 114786 | Fungi | Fungi | 387 | 4.729999999999998e-103 | NTclustered | gi|54873387|gb|AY773930.1| | 114786 | g1533 | i0 | 98.19 | 101.565610859729 | 221 | 4 | 100 | 0 | 1 | 221 | 502 | 722 | Physconia distorta 26S large subunit ribosomal RNA gene, partial sequence | blastn | 22446 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Physconia | Physconia distorta | |
| 11890936 | 11890936 | PRJNA397736_S_NODE_1110_length_270_cov_11.145228_g1074_i0 | PRJNA397736 | 1110 | 270 | 11.145228 | 30.0921156 | Polyblastidium squamulosum | 2294038 | Fungi | Fungi | 357 | 4.6799999999999997e-94 | NTclustered | gi|1476663660|gb|MG257770.1| | 2294038 | g1074 | i0 | 92.4 | 96.737037037037 | 250 | 19 | 93 | 0 | 21 | 270 | 8653 | 8404 | Heterodermia squamulosa voucher 48701 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 26119 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Polyblastidium | Polyblastidium squamulosum | |
| 11890943 | 11890943 | PRJNA397736_S_NODE_630_length_366_cov_13.311573_g594_i0 | PRJNA397736 | 630 | 366 | 13.311573 | 48.72035718 | Phaeophyscia orbicularis | 116805 | Fungi | Fungi | 632 | 9.759999999999998e-177 | NTclustered | gi|1895681276|gb|MT913588.1| | 116805 | g594 | i0 | 97.814 | 100 | 366 | 8 | 100 | 0 | 1 | 366 | 2525 | 2160 | Phaeophyscia orbicularis isolate DM1079 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 | 36600 | 632 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Phaeophyscia | Phaeophyscia orbicularis | |
| 16382344 | 16382344 | PRJNA397736_S_NODE_393_length_470_cov_15.460317_g214_i3 | PRJNA397736 | 393 | 470 | 15.460317 | 72.6634899 | Fungi | 4751 | Fungi | Fungi | 737 | 0 | NTclustered | gi|1473264940|gb|MH877884.1| | 29917 | g214 | i3 | 95.106 | 100.059574468085 | 470 | 20 | 99 | 3 | 2 | 470 | 487 | 20 | Cladosporium cladosporioides culture CBS:126200 strain CBS 126200 large subunit ribosomal RNA gene, partial sequence | blastn | 47028 | 743 | 0.991924629878869 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 17657494 | 17657494 | PRJNA397736_S_NODE_2694_length_161_cov_10.356061_g2658_i0 | PRJNA397736 | 2694 | 161 | 10.356061 | 16.67325821 | Caliciales | 1302181 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|49781160|gb|AY648096.1| | 50936 | g2658 | i0 | 100 | 100 | 161 | 0 | 100 | 0 | 1 | 161 | 1033 | 1193 | Physcia aipolia strain P1 18S ribosomal RNA gene, partial sequence | blastn | 16100 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Physcia | Physcia aipolia | |
| 18931396 | 18931396 | PRJNA397736_S_NODE_1255_length_249_cov_16.100000_g1219_i0 | PRJNA397736 | 1255 | 249 | 16.1 | 40.089 | Physcia | 50935 | Fungi | Fungi | 424 | 4.15e-114 | NTclustered | gi|49781175|gb|AY648100.1| | 116813 | g1219 | i0 | 97.222 | 101.200803212851 | 252 | 4 | 100 | 2 | 1 | 249 | 3 | 254 | Physcia caesia strain P8 18S ribosomal RNA gene, partial sequence | blastn | 25199 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Physcia | Physcia caesia | |
| 18931398 | 18931398 | PRJNA397736_S_NODE_1715_length_210_cov_33.110497_g1679_i0 | PRJNA397736 | 1715 | 210 | 33.110497 | 69.5320437 | Eukaryota | 2759 | Fungi | Fungi | 372 | 1.25e-98 | NTclustered | gi|38570335|gb|L76614.1|CCURGOAA | 5570 | g1679 | i0 | 98.571 | 100 | 210 | 3 | 100 | 0 | 1 | 210 | 1374 | 1583 | Cenococcum geophilum strain 349 small subunit ribosomal RNA gene, complete sequence | blastn | 21000 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Gloniales | Gloniaceae | Cenococcum | Cenococcum geophilum | |
| 22756867 | 22756867 | PRJNA397736_S_NODE_2858_length_157_cov_2.351562_g2822_i0 | PRJNA397736 | 2858 | 157 | 2.351562 | 3.69195234 | Fungi | 4751 | Fungi | Fungi | 291 | 2.52e-74 | NTclustered | gi|908900564|gb|KT207688.1| | 5599 | g2822 | i0 | 100 | 100 | 157 | 0 | 100 | 0 | 1 | 157 | 736 | 580 | Alternaria alternata strain KUC21222 28S ribosomal RNA gene, partial sequence | blastn | 15700 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 23364207 | 23364207 | PRJNA397736_S_NODE_579_length_381_cov_9.397727_g543_i0 | PRJNA397736 | 579 | 381 | 9.397727 | 35.80533987 | Taphrina amentorum | 177208 | Fungi | Fungi | 667 | 0 | NTclustered | gi|1895681277|gb|MT913589.1| | 177208 | g543 | i0 | 98.163 | 99.9370078740157 | 381 | 7 | 100 | 0 | 1 | 381 | 1569 | 1949 | Taphrina amentorum isolate DM1088 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 38076 | 667 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Taphrinomycetes | Taphrinales | Taphrinaceae | Taphrina | Taphrina amentorum | |
| 24638529 | 24638529 | PRJNA397736_S_NODE_1240_length_252_cov_14.470852_g1204_i0 | PRJNA397736 | 1240 | 252 | 14.470852 | 36.46654704 | Phaeophyscia orbicularis | 116805 | Fungi | Fungi | 466 | 6.89e-127 | NTclustered | gi|1895681276|gb|MT913588.1| | 116805 | g1204 | i0 | 100 | 100.047619047619 | 252 | 0 | 100 | 0 | 1 | 252 | 3025 | 2774 | Phaeophyscia orbicularis isolate DM1079 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 | 25212 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Phaeophyscia | Phaeophyscia orbicularis | |
| 28117521 | 28117521 | PRJNA397736_S_NODE_1265_length_249_cov_5.318182_g1229_i0 | PRJNA397736 | 1265 | 249 | 5.318182 | 13.24227318 | Pyrenophora seminiperda CCB | 91370 | Fungi | Fungi | 56.6 | 3.16e-7 | NR | RMZ72191.1 | 1302712 | g1229 | i0 | 65.9 | 1.89156626506024 | 41 | 14 | 49.4 | 0 | 249 | 127 | 128 | 168 | RMZ72191.1 40s ribosomal s27 [Pyrenophora seminiperda CCB06] | diamond | 471 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Pyrenophora | Pyrenophora seminiperda |
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);;