contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1674424 | 1674424 | PRJNA376117_P_NODE_19442_length_313_cov_3.041667_g19140_i0 | PRJNA376117 | 19442 | 313 | 3.041667 | 9.52041771 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 538 | 1.8399999999999993e-148 | NTclustered | gi|427188203|dbj|AB757707.1| | 56466 | g19140 | i0 | 97.749 | 16.2140575079872 | 311 | 7 | 99 | 0 | 1 | 311 | 64 | 374 | Peranema trichophorum vatb mRNA for V-type ATPase V1 subunit B, partial cds, strain: K-01 | blastn | 5075 | 538 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 2950450 | 2950450 | PRJNA376117_P_NODE_25823_length_280_cov_1.202899_g25521_i0 | PRJNA376117 | 25823 | 280 | 1.202899 | 3.3681172 | Euglena agilis | 96764 | Euglenozoa | other_Eukaryota | 198 | 3.13e-46 | NTclustered | gi|1020992084|gb|KT984750.1| | 96764 | g25521 | i0 | 81.78 | 50.4535714285714 | 236 | 43 | 84 | 0 | 45 | 280 | 33 | 268 | Euglena agilis strain ACOI 2970 clone B heat shock protein 90 (hsp90) mRNA, complete cds | blastn | 14127 | 198 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena agilis | ||
| 5503337 | 5503337 | PRJNA376117_P_NODE_20905_length_302_cov_1.672489_g20603_i0 | PRJNA376117 | 20905 | 302 | 1.672489 | 5.05091678 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 222 | 2.03e-53 | NTclustered | gi|118738152|gb|EF114757.1| | 56466 | g20603 | i0 | 98.413 | 0.417218543046358 | 126 | 2 | 42 | 0 | 177 | 302 | 1591 | 1466 | Peranema trichophorum pyruvate:NADP+ oxidoreductase (pno) mRNA, partial cds | blastn | 126 | 222 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 8726426 | 8726426 | PRJNA376117_P_NODE_37667_length_247_cov_3.241379_g37365_i0 | PRJNA376117 | 37667 | 247 | 3.241379 | 8.00620613 | Entosiphon | 101492 | Euglenozoa | other_Eukaryota | 187 | 5.87e-43 | NTclustered | gi|37542663|gb|AY061999.1| | 101493 | g37365 | i0 | 94.262 | 4.16194331983806 | 122 | 7 | 49 | 0 | 3 | 124 | 1596 | 1717 | Entosiphon sulcatum small subunit ribosomal RNA gene, partial sequence | blastn | 1028 | 187 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sulcatum | ||
| 9328271 | 9328271 | PRJNA376117_P_NODE_8048_length_472_cov_3.180451_g7747_i0 | PRJNA376117 | 8048 | 472 | 3.180451 | 15.01172872 | Peranema sp. CB 131838 | 1759665 | Euglenozoa | other_Eukaryota | 643 | 5.949999999999998e-180 | NTclustered | gi|959455953|gb|KT588860.1| | 1759665 | g7747 | i0 | 100 | 9.66737288135593 | 348 | 0 | 74 | 0 | 1 | 348 | 348 | 1 | Peranema sp. CB 131838 glyceraldehyde 3-phosphate dehydrogenase mRNA, partial cds | blastn | 4563 | 643 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema sp. CB 131838 | ||
| 12552096 | 12552096 | PRJNA376117_P_NODE_10450_length_416_cov_1.927114_g10148_i0 | PRJNA376117 | 10450 | 416 | 1.927114 | 8.01679424 | Decastava | 1911741 | Euglenozoa | other_Eukaryota | 765 | 0 | NTclustered | gi|937541987|gb|KP306753.1| | 1732396 | g10148 | i0 | 100 | 75.8581730769231 | 414 | 0 | 99 | 0 | 1 | 414 | 1697 | 2110 | Decastava edaphica strain CCAP 1265/2 18S ribosomal RNA gene, partial sequence | blastn | 31557 | 765 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava edaphica | ||||
| 13153450 | 13153450 | PRJNA376117_P_NODE_15331_length_350_cov_1.664260_g15029_i0 | PRJNA376117 | 15331 | 350 | 1.66426 | 5.82491 | Peranema sp. CB 131838 | 1759665 | Euglenozoa | other_Eukaryota | 553 | 7.429999999999998e-153 | NTclustered | gi|959456119|gb|KT718639.1| | 1759665 | g15029 | i0 | 95.143 | 5.96285714285714 | 350 | 17 | 100 | 0 | 1 | 350 | 615 | 266 | Peranema sp. CB 131838 triosephosphate isomerase isoform 2 mRNA, partial cds | blastn | 2087 | 553 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema sp. CB 131838 | ||
| 14428444 | 14428444 | PRJNA376117_P_NODE_1572_length_1286_cov_4.392415_g1375_i0 | PRJNA376117 | 1572 | 1286 | 4.392415 | 56.4864569 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 1888 | 0 | NTclustered | gi|427188201|dbj|AB757706.1| | 56466 | g1375 | i0 | 99.613 | 10.4129082426128 | 1034 | 4 | 80 | 0 | 1 | 1034 | 1034 | 1 | Peranema trichophorum rpl3 mRNA for 60S ribosomal protein L3, partial cds, strain: K-01 | blastn | 13391 | 1888 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 18251317 | 18251317 | PRJNA376117_P_NODE_1495_length_1344_cov_4.992132_g1303_i0 | PRJNA376117 | 1495 | 1344 | 4.992132 | 67.09425408 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 1851 | 0 | NTclustered | gi|226347408|gb|FJ807243.1| | 56466 | g1303 | i0 | 91.686 | 88.2864583333333 | 1323 | 110 | 98 | 0 | 1 | 1323 | 1323 | 1 | Peranema trichophorum strain CCAP 1260/1 B elongation factor 1 alpha mRNA, partial cds | blastn | 118657 | 1851 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 18251418 | 18251418 | PRJNA376117_P_NODE_2235_length_1002_cov_2.256189_g1988_i0 | PRJNA376117 | 2235 | 1002 | 2.256189 | 22.60701378 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 865 | 0 | NTclustered | gi|110589646|gb|DQ683345.1| | 56466 | g1988 | i0 | 95.88 | 53.8602794411178 | 534 | 22 | 100 | 0 | 1 | 534 | 1819 | 1286 | Peranema trichophorum Hsp90 gene, partial cds | blastn | 53968 | 865 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 20801142 | 20801142 | PRJNA376117_P_NODE_1277_length_1508_cov_20.208362_g1103_i0 | PRJNA376117 | 1277 | 1508 | 20.208362 | 304.74209896 | uncultured Peranema sp. | 1980988 | Euglenozoa | other_Eukaryota | 2747 | 0 | NTclustered | gi|1182637172|gb|KY963139.1| | 1980988 | g1103 | i0 | 99.536 | 38.8454907161804 | 1507 | 6 | 99 | 1 | 1 | 1507 | 659 | 2164 | Uncultured Peranema sp. clone SP1 small subunit ribosomal RNA gene, partial sequence | blastn | 58579 | 2747 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | uncultured Peranema sp. | |||||
| 20801147 | 20801147 | PRJNA376117_P_NODE_13237_length_374_cov_8.817276_g12935_i0 | PRJNA376117 | 13237 | 374 | 8.817276 | 32.97661224 | Trypanosoma melophagium | 715481 | Euglenozoa | other_Eukaryota | 243 | 1.97e-59 | NTclustered | gi|2787689949|ref|XM_067335212.1| | 715481 | g12935 | i0 | 83.525 | 6.35026737967914 | 261 | 41 | 70 | 2 | 86 | 345 | 278 | 19 | Trypanosoma melophagium Kinetoplastid membrane protein 11 (LSM04_003588), partial mRNA | blastn | 2375 | 243 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma melophagium | ||
| 20801186 | 20801186 | PRJNA376117_P_NODE_17537_length_329_cov_5.398438_g17235_i0 | PRJNA376117 | 17537 | 329 | 5.398438 | 17.76086102 | Peranema sp. CB 131838 | 1759665 | Euglenozoa | other_Eukaryota | 466 | 9.33e-127 | NTclustered | gi|959455953|gb|KT588860.1| | 1759665 | g17235 | i0 | 98.485 | 11.9392097264438 | 264 | 4 | 80 | 0 | 1 | 264 | 700 | 963 | Peranema sp. CB 131838 glyceraldehyde 3-phosphate dehydrogenase mRNA, partial cds | blastn | 3928 | 466 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema sp. CB 131838 | ||
| 22076261 | 22076261 | PRJNA376117_P_NODE_2018_length_1069_cov_3.411647_g1785_i0 | PRJNA376117 | 2018 | 1069 | 3.411647 | 36.47050643 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 1628 | 0 | NTclustered | gi|226347408|gb|FJ807243.1| | 56466 | g1785 | i0 | 93.931 | 44.5902712815716 | 1071 | 60 | 100 | 4 | 1 | 1069 | 1441 | 374 | Peranema trichophorum strain CCAP 1260/1 B elongation factor 1 alpha mRNA, partial cds | blastn | 47667 | 1628 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 22750524 | 22750524 | PRJNA376117_P_NODE_27238_length_275_cov_1.311881_g26936_i0 | PRJNA376117 | 27238 | 275 | 1.311881 | 3.60767275 | Entosiphon | 101492 | Euglenozoa | other_Eukaryota | 230 | 1.0899999999999995e-55 | NTclustered | gi|41400272|gb|AY425008.1| | 259048 | g26936 | i0 | 84.388 | 3.44727272727273 | 237 | 33 | 86 | 2 | 39 | 275 | 1843 | 2075 | Entosiphon sp. TCS-2003 18S ribosomal RNA gene, partial sequence | blastn | 948 | 230 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sp. TCS 2003 | ||
| 24626415 | 24626415 | PRJNA376117_P_NODE_640_length_2827_cov_19.432825_g557_i0 | PRJNA376117 | 640 | 2827 | 19.432825 | 549.36596275 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 2366 | 0 | NTclustered | gi|27461806|gb|AY130826.1| | 56466 | g557 | i0 | 99.614 | 9.74460558896357 | 1297 | 4 | 46 | 1 | 1488 | 2783 | 1297 | 1 | Peranema trichophorum voucher Carolina Biol. Supp. Co. (CBS) CE 13-1838 large subunit ribosomal RNA gene, partial sequence | blastn | 27548 | 2366 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 25299894 | 25299894 | PRJNA376117_P_NODE_26560_length_277_cov_1.887255_g26258_i0 | PRJNA376117 | 26560 | 277 | 1.887255 | 5.22769635 | Entosiphon | 101492 | Euglenozoa | other_Eukaryota | 512 | 9.73e-141 | NTclustered | gi|41400272|gb|AY425008.1| | 259048 | g26258 | i0 | 100 | 4.32490974729242 | 277 | 0 | 100 | 0 | 1 | 277 | 1745 | 2021 | Entosiphon sp. TCS-2003 18S ribosomal RNA gene, partial sequence | blastn | 1198 | 512 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sp. TCS 2003 |
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);;