contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4499199 | 4499199 | PRJNA690592_S_NODE_166184_length_264_cov_2.005236_g165170_i0 | PRJNA690592 | 166184 | 264 | 2.005236 | 5.29382304 | Vittaforma corneae | 42399 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g165170 | i0 | 97.059 | 1.36742424242424 | 34 | 0 | 13 | 1 | 232 | 264 | 1849 | 1882 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 361 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 5007408 | 5007408 | PRJNA690592_S_NODE_4944_length_1203_cov_43.961947_g4307_i1 | PRJNA690592 | 4944 | 1203 | 43.961947 | 528.86222241 | Fungi | 4751 | Fungi | Fungi | 183 | 4.17e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g4307 | i1 | 95.652 | 11.2959268495428 | 115 | 4 | 10 | 1 | 1003 | 1117 | 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 | 13589 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 6283077 | 6283077 | PRJNA690592_S_NODE_5065_length_1192_cov_43.580876_g4307_i2 | PRJNA690592 | 5065 | 1192 | 43.580876 | 519.48404192 | Fungi | 4751 | Fungi | Fungi | 183 | 4.13e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g4307 | i2 | 95.652 | 11.4001677852349 | 115 | 4 | 10 | 1 | 87 | 201 | 5650 | 5537 | 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 | 13589 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 11382589 | 11382589 | PRJNA690592_S_NODE_4789_length_1215_cov_44.304729_g4307_i0 | PRJNA690592 | 4789 | 1215 | 44.304729 | 538.30245735 | Fungi | 4751 | Fungi | Fungi | 183 | 4.22e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g4307 | i0 | 95.652 | 11.1843621399177 | 115 | 4 | 9 | 1 | 1015 | 1129 | 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 | 13589 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 15207524 | 15207524 | PRJNA690592_S_NODE_12232_length_833_cov_49.352632_g11411_i0 | PRJNA690592 | 12232 | 833 | 49.352632 | 411.10742456 | Fungi | 4751 | Fungi | Fungi | 183 | 2.849999999999999e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g11411 | i0 | 95.652 | 15.5738295318127 | 115 | 4 | 14 | 1 | 87 | 201 | 5650 | 5537 | 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 | 12973 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 21581288 | 21581288 | PRJNA690592_S_NODE_5077_length_1191_cov_34.769231_g4307_i3 | PRJNA690592 | 5077 | 1191 | 34.769231 | 414.10154121 | Fungi | 4751 | Fungi | Fungi | 183 | 4.13e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g4307 | i3 | 95.652 | 11.4097397145256 | 115 | 4 | 10 | 1 | 87 | 201 | 5650 | 5537 | 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 | 13589 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae |
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);;