contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB2368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22891 | 22891 | PRJEB2368_P_NODE_14781_length_160_cov_2.894309_g14462_i0 | PRJEB2368 | 14781 | 160 | 2.894309 | 4.6308944 | Candida parapsilosis | 5480 | Fungi | Fungi | 296 | 5.55e-76 | NTclustered | gi|371925444|gb|JQ062882.1| | 5480 | g14462 | i0 | 100 | 51.1125 | 160 | 0 | 100 | 0 | 1 | 160 | 22416 | 22575 | Candida parapsilosis strain CBS 1954 mitochondrion, partial genome | blastn | 8178 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida parapsilosis | |
| 986337 | 986337 | PRJEB2368_P_NODE_4061_length_392_cov_2.109859_g3749_i0 | PRJEB2368 | 4061 | 392 | 2.109859 | 8.27064728 | Microsporidium | 144516 | Fungi | Fungi | 436 | 8.859999999999998e-118 | NTclustered | gi|1031418200|gb|KU302783.1| | 1850262 | g3749 | i0 | 85.888 | 83.3341836734694 | 411 | 36 | 99 | 15 | 3 | 392 | 566 | 157 | Microsporidia sp. A1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 32667 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidia sp. A1 | |||||
| 1297113 | 1297113 | PRJEB2368_P_NODE_422_length_1274_cov_5.903800_g272_i1 | PRJEB2368 | 422 | 1274 | 5.9038 | 75.214412 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 503 | 2.99e-137 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g272 | i1 | 85.773 | 30.7103610675039 | 485 | 57 | 89 | 11 | 187 | 665 | 2533 | 3011 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 39125 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 5125347 | 5125347 | PRJEB2368_P_NODE_9265_length_287_cov_1.436000_g8947_i0 | PRJEB2368 | 9265 | 287 | 1.436 | 4.12132 | Malassezia globosa | 76773 | Fungi | Fungi | 141 | 5.510000000000001e-29 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g8947 | i0 | 100 | 4.79442508710801 | 76 | 0 | 53 | 0 | 212 | 287 | 3859 | 3784 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 1376 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 6089477 | 6089477 | PRJEB2368_P_NODE_9745_length_287_cov_1.364000_g9427_i0 | PRJEB2368 | 9745 | 287 | 1.364 | 3.91468 | Ramalina | 56479 | Fungi | Fungi | 52.8 | 0.027 | NTclustered | gi|1069417254|gb|KU496963.1| | 86786 | g9427 | i0 | 100 | 0.195121951219512 | 28 | 0 | 10 | 0 | 20 | 47 | 463 | 490 | Ramalina americana voucher TL022-D04 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Lecanorales | Ramalinaceae | Ramalina | Ramalina americana | |
| 12776486 | 12776486 | PRJEB2368_P_NODE_3051_length_473_cov_2.048165_g2751_i0 | PRJEB2368 | 3051 | 473 | 2.048165 | 9.68782045 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 339 | 3.1499999999999997e-88 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g2751 | i0 | 82.836 | 18.3298097251586 | 402 | 46 | 81 | 12 | 86 | 467 | 1848 | 2246 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8670 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 15014250 | 15014250 | PRJEB2368_P_NODE_552_length_1142_cov_3.085973_g419_i0 | PRJEB2368 | 552 | 1142 | 3.085973 | 35.24181166 | Ecytonucleospora | 3078583 | Fungi | Fungi | 1003 | 0 | NTclustered | gi|2523179590|gb|OR168077.1| | 646526 | g419 | i0 | 91.565 | 71.8809106830123 | 735 | 50 | 83 | 10 | 169 | 895 | 248 | 978 | Enterocytozoon hepatopenaei strain SHFX4 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 82088 | 1003 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei |
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);;