contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA859990" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2511691 | 2511691 | PRJNA859990_S_NODE_3982_length_479_cov_1.403941_g3723_i0 | PRJNA859990 | 3982 | 479 | 1.403941 | 6.72487739 | Heterosporis | 157917 | Fungi | Fungi | 514 | 4.95e-141 | NTclustered | gi|448278452|gb|KC137548.1| | 1289055 | g3723 | i0 | 88.426 | 22.8997912317328 | 432 | 43 | 89 | 6 | 50 | 477 | 2179 | 2607 | Heterosporis sp. NBDP-2013a isolate MN/WAE small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10969 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 4674237 | 4674237 | PRJNA859990_S_NODE_10404_length_315_cov_2.119835_g10143_i0 | PRJNA859990 | 10404 | 315 | 2.119835 | 6.67748025 | Heterosporis anguillarum | 184033 | Fungi | Fungi | 374 | 5.539999999999998e-99 | NTclustered | gi|27448231|gb|AF387331.1| | 184033 | g10143 | i0 | 90.78 | 39.7206349206349 | 282 | 23 | 89 | 3 | 12 | 292 | 1912 | 2191 | Heterosporis anguillarum small subunit ribosomal RNA gene, internal transcribed spacer, and large subunit ribosomal RNA gene, complete sequence | blastn | 12512 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis anguillarum | |||
| 7224057 | 7224057 | PRJNA859990_S_NODE_16566_length_258_cov_1.832432_g16305_i0 | PRJNA859990 | 16566 | 258 | 1.832432 | 4.72767456 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 263 | 9.97e-66 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g16305 | i0 | 87.5 | 5.32558139534884 | 232 | 24 | 89 | 5 | 4 | 232 | 2185 | 1956 | 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 | 1374 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 9774027 | 9774027 | PRJNA859990_S_NODE_4868_length_440_cov_5.662125_g4607_i0 | PRJNA859990 | 4868 | 440 | 5.662125 | 24.91335 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 813 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g4607 | i0 | 100 | 98.85 | 440 | 0 | 100 | 0 | 1 | 440 | 889 | 1328 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 43494 | 813 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 13599510 | 13599510 | PRJNA859990_S_NODE_12091_length_296_cov_1.511211_g11830_i0 | PRJNA859990 | 12091 | 296 | 1.511211 | 4.47318456 | Vavraia culicis | 103449 | Fungi | Fungi | 363 | 1.1199999999999999e-95 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g11830 | i0 | 89.86 | 17.347972972973 | 286 | 23 | 95 | 6 | 14 | 295 | 765 | 1048 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 5135 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 18697371 | 18697371 | PRJNA859990_S_NODE_835_length_914_cov_3.718193_g643_i0 | PRJNA859990 | 835 | 914 | 3.718193 | 33.98428402 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1568 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g643 | i0 | 99.65 | 90.0251641137856 | 856 | 3 | 94 | 0 | 59 | 914 | 2 | 857 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 82283 | 1568 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;