contig_metadata
4 rows where bioproject = "PRJNA1255065", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2911132 | 2911132 | PRJNA1255065_P_NODE_53723_length_271_cov_1.873874_g51496_i0 | PRJNA1255065 | 53723 | 271 | 1.873874 | 5.07819854 | Microsporidia sp. | 1984797 | Fungi | Fungi | 250 | 8.21e-62 | NTclustered | gi|2126689602|gb|OL312656.1| | 1984797 | g51496 | i0 | 83.696 | 96.9778597785978 | 276 | 33 | 99 | 10 | 3 | 271 | 3 | 273 | Microsporidia sp. isolate Micro3 small subunit ribosomal RNA gene, partial sequence | blastn | 26281 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidia sp. | |||||
| 11256562 | 11256562 | PRJNA1255065_P_NODE_35649_length_394_cov_1.881159_g33428_i0 | PRJNA1255065 | 35649 | 394 | 1.881159 | 7.41176646 | Fungi | 4751 | Fungi | Fungi | 183 | 1.28e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g33428 | i0 | 95.652 | 30.550761421319802 | 115 | 4 | 29 | 1 | 230 | 344 | 5537 | 5650 | Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, 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 | 12037 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 22036488 | 22036488 | PRJNA1255065_P_NODE_111518_length_168_cov_0.873950_g109290_i0 | PRJNA1255065 | 111518 | 168 | 0.87395 | 1.468236 | Encephalitozoon romaleae | 571949 | Fungi | Fungi | 95.3 | 2.31e-15 | NTclustered | gi|210076707|gb|FJ026013.1| | 571949 | g109290 | i0 | 79.333 | 0.892857142857143 | 150 | 20 | 84 | 9 | 10 | 150 | 465 | 612 | Encephalitozoon sp. SJ-2008 16S small subunit ribosomal RNA gene, partial sequence; 16S-23S internal transcribed spacer, complete sequence; and 23S large subunit ribosomal RNA gene, partial sequence | blastn | 150 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon romaleae | |||
| 22730102 | 22730102 | PRJNA1255065_P_NODE_33098_length_422_cov_1.109920_g30879_i0 | PRJNA1255065 | 33098 | 422 | 1.10992 | 4.6838624 | Encephalitozoon | 6033 | Fungi | Fungi | 281 | 4.76e-71 | NTclustered | gi|1253338741|ref|XR_002670131.1| | 876142 | g30879 | i0 | 79.021 | 9.94075829383886 | 429 | 76 | 100 | 11 | 1 | 422 | 1110 | 689 | Encephalitozoon intestinalis ATCC 50506 5.8S-23S ribosomal RNA (Eint_010010), rRNA | blastn | 4195 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis |
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);;