contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB12296" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26044916 | 26044916 | PRJEB12296_S_NODE_10485_length_171_cov_1.389706_g10453_i0 | PRJEB12296 | 10485 | 171 | 1.389706 | 2.37639726 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 70.5 | 2e-14 | NR | ORZ29652.1 | 765915 | g10453 | i0 | 67.4 | 0.807017543859649 | 46 | 15 | 80.7 | 0 | 169 | 32 | 21 | 66 | ORZ29652.1 ribosomal protein S28e, partial [Catenaria anguillulae PL171] | diamond | 138 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 26423140 | 26423140 | PRJEB12296_S_NODE_1727_length_309_cov_407.835766_g1695_i0 | PRJEB12296 | 1727 | 309 | 407.835766 | 1260.21251694 | Eukaryota | 2759 | Fungi | Fungi | 68.6 | 6.7e-13 | NR | ORY35885.1 | 71784 | g1695 | i0 | 66 | 0.970873786407767 | 50 | 17 | 48.5 | 0 | 281 | 132 | 17 | 66 | ORY35885.1 40S ribosomal protein S30 [Naematelia encephala] | diamond | 300 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 32925175 | 32925175 | PRJEB12296_S_NODE_5161_length_209_cov_4.258621_g5129_i0 | PRJEB12296 | 5161 | 209 | 4.258621 | 8.90051789 | Syncephalis fuscata | 1851187 | Fungi | Fungi | 44.3 | 0.00257 | NR | KAI9597338.1 | 1851187 | g5129 | i0 | 41.3 | 0.660287081339713 | 46 | 27 | 66 | 0 | 195 | 58 | 86 | 131 | KAI9597338.1 cofilin [Syncephalis fuscata] | diamond | 138 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis fuscata | |
| 32939436 | 32939436 | PRJEB12296_S_NODE_3393_length_244_cov_1.880383_g3361_i0 | PRJEB12296 | 3393 | 244 | 1.880383 | 4.58813452 | Xylaria | 37991 | Fungi | Fungi | 59.3 | 2.42e-8 | NR | KAI0547676.1 | 42375 | g3361 | i0 | 58.7 | 6.86065573770492 | 46 | 19 | 56.6 | 0 | 1 | 138 | 24 | 69 | KAI0547676.1 60s acidic ribosomal protein-domain-containing protein, partial [Xylaria curta] | diamond | 1674 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria curta | |
| 32976672 | 32976672 | PRJEB12296_S_NODE_5555_length_204_cov_3.023669_g5523_i0 | PRJEB12296 | 5555 | 204 | 3.023669 | 6.16828476 | Absidia glauca | 4829 | Fungi | Fungi | 44.3 | 0.00282 | NR | SAM04041.1 | 4829 | g5523 | i0 | 39.6 | 0.705882352941177 | 48 | 29 | 70.6 | 0 | 2 | 145 | 90 | 137 | SAM04041.1 hypothetical protein [Absidia glauca] | diamond | 144 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia glauca | |
| 32976705 | 32976705 | PRJEB12296_S_NODE_9723_length_174_cov_2.762590_g9691_i0 | PRJEB12296 | 9723 | 174 | 2.76259 | 4.8069066 | Dinochytrium kinnereticum | 1774096 | Fungi | Fungi | 62.4 | 3.18e-10 | NR | KAJ3220030.1 | 1774096 | g9691 | i0 | 62.2 | 1.53448275862069 | 45 | 17 | 77.6 | 0 | 13 | 147 | 118 | 162 | KAJ3220030.1 60S ribosomal protein L12 [Dinochytrium kinnereticum] | diamond | 267 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Dinochytrium | Dinochytrium kinnereticum | |
| 33010652 | 33010652 | PRJEB12296_S_NODE_3180_length_250_cov_4.376744_g3148_i0 | PRJEB12296 | 3180 | 250 | 4.376744 | 10.94186 | Cercophora scortea | 314031 | Fungi | Fungi | 43.9 | 0.00572 | NR | KAK3335352.1 | 314031 | g3148 | i0 | 38.3 | 0.564 | 47 | 29 | 56.4 | 0 | 68 | 208 | 81 | 127 | KAK3335352.1 hypothetical protein B0T19DRAFT_5808 [Cercophora scortea] | diamond | 141 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Cercophora | Cercophora scortea | |
| 33010666 | 33010666 | PRJEB12296_S_NODE_4708_length_216_cov_2.386740_g4676_i0 | PRJEB12296 | 4708 | 216 | 2.38674 | 5.1553584 | Puccinia striiformis f. sp. tritici | 168172 | Fungi | Fungi | 40.4 | 0.0355 | NR | XP_047797933.1 | 168172 | g4676 | i0 | 82.1 | 0.777777777777778 | 28 | 5 | 38.9 | 0 | 12 | 95 | 54 | 81 | XP_047797933.1 hypothetical protein Pst134EA_028829 [Puccinia striiformis f. sp. tritici] | diamond | 168 | 40.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 33044703 | 33044703 | PRJEB12296_S_NODE_15021_length_158_cov_5.178862_g14989_i0 | PRJEB12296 | 15021 | 158 | 5.178862 | 8.18260196 | Coemansia brasiliensis | 2650707 | Fungi | Fungi | 43.1 | 0.00601 | NR | KAJ2848156.1 | 2650707 | g14989 | i0 | 61.1 | 2.73417721518987 | 36 | 14 | 68.4 | 0 | 51 | 158 | 60 | 95 | KAJ2848156.1 hypothetical protein IWW36_003466, partial [Coemansia brasiliensis] | diamond | 432 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia brasiliensis |
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);;