contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA964500" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3492519 | 3492519 | PRJNA964500_S_NODE_3503_length_284_cov_4.443137_g3411_i0 | PRJNA964500 | 3503 | 284 | 4.443137 | 12.61850908 | Decastava sp. | 3023511 | Euglenozoa | other_Eukaryota | 407 | 4.86e-109 | NTclustered | gi|2431695564|gb|OQ331009.1| | 3023511 | g3411 | i0 | 93.818 | 53.6021126760563 | 275 | 10 | 95 | 7 | 1 | 270 | 1004 | 1276 | Decastava sp. isolate SPO2 small subunit ribosomal RNA gene, partial sequence | blastn | 15223 | 407 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava sp. | ||||
| 6045069 | 6045069 | PRJNA964500_S_NODE_4765_length_253_cov_3.620536_g4673_i0 | PRJNA964500 | 4765 | 253 | 3.620536 | 9.15995608 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 191 | 4.66e-44 | NTclustered | gi|1002433688|ref|XR_001548756.1| | 157538 | g4673 | i0 | 83.645 | 86.4743083003953 | 214 | 24 | 82 | 10 | 5 | 212 | 56 | 264 | Leptomonas pyrrhocoris 28S ribosomal RNA (LSU-beta) rRNA | blastn | 21878 | 191 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 8594827 | 8594827 | PRJNA964500_S_NODE_4987_length_247_cov_44518.412844_g4895_i0 | PRJNA964500 | 4987 | 247 | 44518.412844 | 109960.47972468 | Keelungia nitschei | 2529305 | Euglenozoa | other_Eukaryota | 134 | 7.750000000000001e-27 | NTclustered | gi|1581142783|gb|MK567808.1| | 2529305 | g4895 | i0 | 81.287 | 298.878542510121 | 171 | 27 | 68 | 5 | 51 | 219 | 1568 | 1401 | Keelungia nitschei strain HFCC166 large subunit ribosomal RNA gene, partial sequence | blastn | 73823 | 134 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Heteronematidae | Keelungia | Keelungia nitschei | ||
| 13695437 | 13695437 | PRJNA964500_S_NODE_10671_length_182_cov_5.320261_g10579_i0 | PRJNA964500 | 10671 | 182 | 5.320261 | 9.6828750200000009 | Vahlkampfia sp. | 1874882 | Heterolobosea | other_Eukaryota | 80.5 | 7.1e-11 | NTclustered | gi|2651357786|gb|PP174301.1| | 1874882 | g10579 | i0 | 91.379 | 0.318681318681319 | 58 | 5 | 32 | 0 | 125 | 182 | 4145 | 4202 | Vahlkampfia sp. isolate 24M small subunit ribosomal RNA gene, partial sequence; 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 | 58 | 80.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia sp. | ||||
| 16244678 | 16244678 | PRJNA964500_S_NODE_2993_length_300_cov_35548.365314_g2901_i0 | PRJNA964500 | 2993 | 300 | 35548.365314 | 106645.095942 | uncultured marine diplonemid | 547051 | Euglenozoa | other_Eukaryota | 178 | 4.41e-40 | NTclustered | gi|223047901|gb|FJ032685.1| | 547051 | g2901 | i0 | 91.538 | 41.9966666666667 | 130 | 10 | 43 | 1 | 168 | 297 | 2437 | 2309 | Uncultured marine diplonemid clone Ma131_1A46 28S ribosomal RNA gene, partial sequence | blastn | 12599 | 178 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | uncultured marine diplonemid | |||||
| 17519830 | 17519830 | PRJNA964500_S_NODE_1054_length_433_cov_6.361386_g964_i0 | PRJNA964500 | 1054 | 433 | 6.361386 | 27.54480138 | Decastava edaphica | 1732396 | Euglenozoa | other_Eukaryota | 749 | 0 | NTclustered | gi|937541987|gb|KP306753.1| | 1732396 | g964 | i0 | 97.926 | 66.9214780600462 | 434 | 6 | 100 | 3 | 1 | 433 | 1975 | 1544 | Decastava edaphica strain CCAP 1265/2 18S ribosomal RNA gene, partial sequence | blastn | 28977 | 749 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava edaphica | ||||
| 18793608 | 18793608 | PRJNA964500_S_NODE_175_length_762_cov_94.982265_g144_i0 | PRJNA964500 | 175 | 762 | 94.982265 | 723.7648593 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 1098 | 0 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g144 | i0 | 94.199 | 17.6443569553806 | 724 | 35 | 95 | 7 | 7 | 728 | 3777 | 4495 | Allovahlkampfia sp. isolate S28D2 small subunit ribosomal RNA gene, partial sequence; 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 | 13445 | 1098 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 18793667 | 18793667 | PRJNA964500_S_NODE_8935_length_196_cov_4.401198_g8843_i0 | PRJNA964500 | 8935 | 196 | 4.401198 | 8.62634808 | Euglena mutabilis | 38275 | Euglenozoa | other_Eukaryota | 141 | 3.5200000000000003e-29 | NTclustered | gi|1248769137|gb|KX889672.1| | 38275 | g8843 | i0 | 80 | 103.801020408163 | 200 | 33 | 100 | 6 | 1 | 196 | 908 | 712 | Euglena mutabilis strain CCAC0131 large subunit ribosomal RNA gene, partial sequence | blastn | 20345 | 141 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena mutabilis | ||
| 23894324 | 23894324 | PRJNA964500_S_NODE_1539_length_379_cov_2.734286_g1447_i0 | PRJNA964500 | 1539 | 379 | 2.734286 | 10.36294394 | Decastava sp. | 3023511 | Euglenozoa | other_Eukaryota | 606 | 6.149999999999997e-169 | NTclustered | gi|2431695564|gb|OQ331009.1| | 3023511 | g1447 | i0 | 95.561 | 23.0052770448549 | 383 | 9 | 100 | 6 | 1 | 379 | 646 | 1024 | Decastava sp. isolate SPO2 small subunit ribosomal RNA gene, partial sequence | blastn | 8719 | 606 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava sp. |
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);;