contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA908278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890429 | 890429 | PRJNA908278_P_NODE_5721_length_489_cov_10.091346_g5618_i0 | PRJNA908278 | 5721 | 489 | 10.091346 | 49.34668194 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 845 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g5618 | i0 | 99.567 | 89.5685071574642 | 462 | 2 | 94 | 0 | 1 | 462 | 1519 | 1980 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 43799 | 845 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 3440958 | 3440958 | PRJNA908278_P_NODE_1503_length_888_cov_19.260123_g1421_i0 | PRJNA908278 | 1503 | 888 | 19.260123 | 171.02989224 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1570 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g1421 | i0 | 99.65 | 93.0495495495496 | 857 | 3 | 100 | 0 | 32 | 888 | 2 | 858 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 82628 | 1570 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 8543212 | 8543212 | PRJNA908278_P_NODE_25107_length_258_cov_1.513514_g25004_i0 | PRJNA908278 | 25107 | 258 | 1.513514 | 3.90486612 | Nematocida minor | 1912983 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|2323916580|ref|XM_051478277.1| | 1912983 | g25004 | i0 | 100 | 0.108527131782946 | 28 | 0 | 11 | 0 | 168 | 195 | 614 | 641 | Nematocida minor nuclear export mediator factor NEMF (NEMIN01_2335), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida minor | ||||
| 8543361 | 8543361 | PRJNA908278_P_NODE_6107_length_474_cov_21.620948_g6004_i0 | PRJNA908278 | 6107 | 474 | 21.620948 | 102.48329352 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 870 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g6004 | i0 | 99.789 | 98.9198312236287 | 474 | 1 | 100 | 0 | 1 | 474 | 860 | 1333 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 46888 | 870 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 9818228 | 9818228 | PRJNA908278_P_NODE_31288_length_246_cov_0.890173_g31185_i0 | PRJNA908278 | 31288 | 246 | 0.890173 | 2.18982558 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g31185 | i0 | 100 | 7.24390243902439 | 246 | 0 | 100 | 0 | 1 | 246 | 2167 | 1922 | 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 | 1782 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 9818324 | 9818324 | PRJNA908278_P_NODE_628_length_1236_cov_7.201204_g581_i0 | PRJNA908278 | 628 | 1236 | 7.201204 | 89.00688144 | Pleistophora mulleri | 249366 | Fungi | Fungi | 1197 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g581 | i0 | 84.554 | 21.7912621359223 | 1256 | 139 | 99 | 50 | 17 | 1236 | 1855 | 3091 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 26934 | 1197 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 25116196 | 25116196 | PRJNA908278_P_NODE_14060_length_334_cov_1.180077_g13957_i0 | PRJNA908278 | 14060 | 334 | 1.180077 | 3.94145718 | Glugea plecoglossi | 40978 | Fungi | Fungi | 292 | 1.7e-74 | NTclustered | gi|30088591|gb|AY138804.1| | 40978 | g13957 | i0 | 82.675 | 5.66766467065868 | 329 | 57 | 99 | 0 | 6 | 334 | 467 | 795 | Glugea plecoglossi alpha-tubulin (atub) gene, partial cds | blastn | 1893 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea plecoglossi |
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);;