contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB2333" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22863 | 22863 | PRJEB2333_P_NODE_3181_length_419_cov_1.921466_g2406_i0 | PRJEB2333 | 3181 | 419 | 1.921466 | 8.05094254 | uncultured fungus | 175245 | Fungi | Fungi | 287 | 1.02e-72 | NTclustered | gi|339831059|gb|JN112072.1| | 175245 | g2406 | i0 | 99.371 | 41.8042959427208 | 159 | 0 | 38 | 1 | 1 | 159 | 263 | 420 | Uncultured fungus clone DLQAOB9C13 28S ribosomal RNA gene, partial sequence | blastn | 17516 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 22865 | 22865 | PRJEB2333_P_NODE_4601_length_158_cov_2.785124_g3824_i0 | PRJEB2333 | 4601 | 158 | 2.785124 | 4.40049592 | uncultured fungus | 175245 | Fungi | Fungi | 283 | 4.2499999999999995e-72 | NTclustered | gi|2159202025|emb|OU940232.1| | 175245 | g3824 | i0 | 99.359 | 100.746835443038 | 156 | 1 | 99 | 0 | 3 | 158 | 1284 | 1439 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01527 | blastn | 15918 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 4813968 | 4813968 | PRJEB2333_P_NODE_3164_length_422_cov_1.350649_g2389_i0 | PRJEB2333 | 3164 | 422 | 1.350649 | 5.69973878 | Eukaryota | 2759 | Fungi | Fungi | 84.2 | 1.44e-11 | NTclustered | gi|441431095|gb|JX974793.1| | 175245 | g2389 | i0 | 86.667 | 4.18720379146919 | 75 | 10 | 18 | 0 | 320 | 394 | 751 | 677 | Uncultured fungus clone D281 internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, region | blastn | 1767 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7363852 | 7363852 | PRJEB2333_P_NODE_2606_length_540_cov_11.176938_g1837_i0 | PRJEB2333 | 2606 | 540 | 11.176938 | 60.3554652 | Alternaria | 5598 | Fungi | Fungi | 540 | 9.29e-149 | NTclustered | gi|289449248|dbj|AB517938.1| | 5599 | g1837 | i0 | 99.661 | 66.7185185185185 | 295 | 1 | 77 | 0 | 1 | 295 | 876 | 582 | Alternaria alternata gene for 28S ribosomal RNA, partial sequence | blastn | 36028 | 545 | 0.990825688073395 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 7675148 | 7675148 | PRJEB2333_P_NODE_3647_length_226_cov_5.275132_g2870_i0 | PRJEB2333 | 3647 | 226 | 5.275132 | 11.92179832 | Malassezia restricta | 76775 | Fungi | Fungi | 418 | 1.7199999999999998e-112 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2870 | i0 | 100 | 100.185840707965 | 226 | 0 | 100 | 0 | 1 | 226 | 1720 | 1945 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 22642 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18837953 | 18837953 | PRJEB2333_P_NODE_3495_length_281_cov_2.200820_g2718_i0 | PRJEB2333 | 3495 | 281 | 2.20082 | 6.1843042 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 141 | 5.37e-29 | NTclustered | gi|1866582500|gb|MT730675.1| | 109932 | g2718 | i0 | 87.2 | 55.0498220640569 | 125 | 15 | 44 | 1 | 1 | 125 | 4349 | 4226 | Entophlyctis luteolus isolate JEL0129 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15469 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 18837961 | 18837961 | PRJEB2333_P_NODE_3775_length_207_cov_1.711765_g2998_i0 | PRJEB2333 | 3775 | 207 | 1.711765 | 3.54335355 | Dothideomycetes | 147541 | Fungi | Fungi | 327 | 2.69e-85 | NTclustered | gi|2749640508|ref|XR_010715598.1| | 5022 | g2998 | i0 | 99.448 | 103.328502415459 | 181 | 0 | 87 | 1 | 1 | 181 | 3248 | 3427 | Leptosphaeria maculans 28S ribosomal RNA (IAQ61_009836), rRNA | blastn | 21389 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus lingam | |
| 22663103 | 22663103 | PRJEB2333_P_NODE_3658_length_224_cov_2.663102_g2881_i0 | PRJEB2333 | 3658 | 224 | 2.663102 | 5.96534848 | Eukaryota | 2759 | Fungi | Fungi | 196 | 8.69e-46 | NTclustered | gi|73990900|emb|AM039516.1| | 211099 | g2881 | i0 | 85.492 | 88.3794642857143 | 193 | 22 | 85 | 4 | 35 | 224 | 911 | 722 | Hanseniaspora clermontiae partial tef1 gene for translation elongation factor 1-alpha, strain CBS 8821 | blastn | 19797 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora clermontiae | |
| 23938496 | 23938496 | PRJEB2333_P_NODE_3199_length_417_cov_2.023684_g2424_i0 | PRJEB2333 | 3199 | 417 | 2.023684 | 8.43876228 | Fungi | 4751 | Fungi | Fungi | 233 | 1.3299999999999998e-56 | NTclustered | gi|6715474|gb|AF218791.1|AF218791 | 5599 | g2424 | i0 | 100 | 51.4340527577938 | 126 | 0 | 59 | 0 | 1 | 126 | 1634 | 1509 | Alternaria alternata internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; 28S ribosomal RNA gene, partial sequence; and 18S ribosomal RNA gene, complete sequence | blastn | 21448 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 23938505 | 23938505 | PRJEB2333_P_NODE_3819_length_202_cov_2.351515_g3042_i0 | PRJEB2333 | 3819 | 202 | 2.351515 | 4.7500603 | Eukaryota | 2759 | Fungi | Fungi | 372 | 1.19e-98 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g3042 | i0 | 100 | 83.5792079207921 | 201 | 0 | 99 | 0 | 1 | 201 | 132 | 332 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 16883 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii |
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);;