contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA609258" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 586337 | 586337 | PRJNA609258_P_NODE_12181_length_557_cov_1.719008_g11804_i0 | PRJNA609258 | 12181 | 557 | 1.719008 | 9.57487456 | Microsporidium sp. EM.L-11 | 1821049 | Fungi | Fungi | 625 | 2.579999999999999e-174 | NTclustered | gi|1012430364|gb|KT956059.1| | 1821049 | g11804 | i0 | 86.988 | 98.6086175942549 | 561 | 65 | 100 | 7 | 1 | 557 | 804 | 248 | Microsporidium sp. EM.L-11 small subunit ribosomal RNA gene, partial sequence | blastn | 54925 | 625 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. EM.L-11 | ||||
| 587064 | 587064 | PRJNA609258_P_NODE_31261_length_333_cov_3.892308_g30876_i0 | PRJNA609258 | 31261 | 333 | 3.892308 | 12.96138564 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 544 | 4.25e-150 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g30876 | i0 | 96.131 | 107.546546546547 | 336 | 8 | 99 | 3 | 2 | 333 | 3994 | 3660 | 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 | 35813 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 3137407 | 3137407 | PRJNA609258_P_NODE_1663_length_1367_cov_14.251932_g1517_i0 | PRJNA609258 | 1663 | 1367 | 14.251932 | 194.82391044 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 1609 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g1517 | i0 | 89.609 | 85.1814191660571 | 1280 | 114 | 93 | 15 | 16 | 1283 | 1273 | 1 | 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 | 116443 | 1609 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 3138902 | 3138902 | PRJNA609258_P_NODE_59463_length_242_cov_5.526627_g59078_i0 | PRJNA609258 | 59463 | 242 | 5.526627 | 13.37443734 | Vittaforma corneae | 42399 | Fungi | Fungi | 150 | 7.509999999999998e-32 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g59078 | i0 | 82.857 | 25.9793388429752 | 175 | 22 | 71 | 6 | 1 | 172 | 2192 | 2361 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 6287 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 14615728 | 14615728 | PRJNA609258_P_NODE_2232_length_1230_cov_4.998271_g2045_i0 | PRJNA609258 | 2232 | 1230 | 4.998271 | 61.4787333 | Endoreticulatus sp. CHW-2004 Taiwan | 262393 | Fungi | Fungi | 289 | 8.790000000000001e-73 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g2045 | i0 | 72.866 | 8.88943089430894 | 1113 | 200 | 88 | 71 | 1 | 1079 | 1159 | 115 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 10934 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 16449965 | 16449965 | PRJNA609258_P_NODE_32533_length_326_cov_1.541502_g32148_i0 | PRJNA609258 | 32533 | 326 | 1.541502 | 5.02529652 | Microsporidium | 144516 | Fungi | Fungi | 270 | 7.77e-68 | NTclustered | gi|272477433|gb|FJ756115.1| | 698185 | g32148 | i0 | 89.72 | 9.57668711656442 | 214 | 19 | 65 | 3 | 4 | 215 | 215 | 3 | Microsporidium sp. BPAR14 PAR1 small subunit ribosomal RNA gene, partial sequence | blastn | 3122 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BPAR14 PAR1 | ||||
| 17165973 | 17165973 | PRJNA609258_P_NODE_814_length_1684_cov_24.068901_g747_i0 | PRJNA609258 | 814 | 1684 | 24.068901 | 405.32029284 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 736 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g747 | i0 | 84.739 | 12.854513064133 | 747 | 100 | 92 | 14 | 928 | 1667 | 2468 | 1729 | 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 | 21647 | 736 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 19714071 | 19714071 | PRJNA609258_P_NODE_44876_length_270_cov_1.517766_g44491_i0 | PRJNA609258 | 44876 | 270 | 1.517766 | 4.0979682 | Microsporidium sp. PL03 | 3072851 | Fungi | Fungi | 163 | 1.1e-35 | NTclustered | gi|2571792811|gb|OR500624.1| | 3072851 | g44491 | i0 | 81.731 | 44.137037037037 | 208 | 27 | 76 | 8 | 66 | 270 | 1158 | 959 | Microsporidium sp. PL03 isolate AT.p2G4 small subunit ribosomal RNA gene, partial sequence | blastn | 11917 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. PL03 |
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);;