contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3293659 | 3293659 | PRJNA760976_P_NODE_39963_length_271_cov_2.262626_g39642_i0 | PRJNA760976 | 39963 | 271 | 2.262626 | 6.13171646 | Jakoba libera | 143017 | Root_unresolved | Root_unresolved | 106 | 1.88e-18 | NTclustered | gi|501595239|ref|NC_021127.1| | 143017 | g39642 | i0 | 77.528 | 1.30258302583026 | 178 | 38 | 65 | 2 | 94 | 270 | 92317 | 92493 | Jakoba libera strain ATCC 50422 mitochondrion, complete genome | blastn | 353 | 106 | 1 | Eukaryota | Discoba | Jakobida | Jakobidae | Jakoba | Jakoba libera | ||||
| 5846002 | 5846002 | PRJNA760976_P_NODE_53965_length_243_cov_0.905882_g53644_i0 | PRJNA760976 | 53965 | 243 | 0.905882 | 2.20129326 | Eutreptiella pomquetensis | 215699 | Euglenozoa | other_Eukaryota | 226 | 1.2199999999999999e-54 | NTclustered | gi|596103701|gb|KC907695.1| | 215699 | g53644 | i0 | 85.581 | 93.0534979423868 | 215 | 31 | 88 | 0 | 8 | 222 | 777 | 563 | Eutreptiella pomquetensis strain CCMP 1491 clone 2 beta-tubulin (tubB) gene, partial cds | blastn | 22612 | 226 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Eutreptiales | Eutreptiaceae | Eutreptiella | Eutreptiella pomquetensis | ||
| 6309070 | 6309070 | PRJNA760976_P_NODE_39825_length_272_cov_1.271357_g39504_i0 | PRJNA760976 | 39825 | 272 | 1.271357 | 3.45809104 | Decastava | 1911741 | Euglenozoa | other_Eukaryota | 486 | 5.7699999999999996e-133 | NTclustered | gi|937541987|gb|KP306753.1| | 1732396 | g39504 | i0 | 98.897 | 60.8125 | 272 | 3 | 100 | 0 | 1 | 272 | 1835 | 2106 | Decastava edaphica strain CCAP 1265/2 18S ribosomal RNA gene, partial sequence | blastn | 16541 | 486 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava edaphica | ||||
| 7121121 | 7121121 | PRJNA760976_P_NODE_33086_length_292_cov_1.136986_g32765_i0 | PRJNA760976 | 33086 | 292 | 1.136986 | 3.31999912 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 220 | 7.01e-53 | NTclustered | gi|2119431529|ref|XM_044691764.1| | 51637 | g32765 | i0 | 81.071 | 19.8390410958904 | 280 | 49 | 95 | 4 | 2 | 279 | 278 | 1 | Naegleria lovaniensis uncharacterized protein (C9374_002355), partial mRNA | blastn | 5793 | 220 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 8395613 | 8395613 | PRJNA760976_P_NODE_22927_length_332_cov_1.772201_g22606_i0 | PRJNA760976 | 22927 | 332 | 1.772201 | 5.88370732 | Rhynchobodo ATCC50359 | 51334 | Euglenozoa | other_Eukaryota | 274 | 6.129999999999998e-69 | NTclustered | gi|226347448|gb|FJ807264.1| | 51334 | g22606 | i0 | 82.951 | 34.144578313253 | 305 | 48 | 91 | 3 | 16 | 318 | 597 | 295 | Rhynchobodo ATCC50359 elongation factor 1 alpha gene, partial cds | blastn | 11336 | 274 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchobodo | Rhynchobodo ATCC50359 | |||
| 9670769 | 9670769 | PRJNA760976_P_NODE_25668_length_320_cov_0.910931_g25347_i0 | PRJNA760976 | 25668 | 320 | 0.910931 | 2.9149792 | Trypanosoma brucei | 5691 | Euglenozoa | other_Eukaryota | 182 | 3.669999999999999e-41 | NTclustered | gi|788015356|ref|XM_011778752.1| | 679716 | g25347 | i0 | 87.742 | 12.325 | 155 | 19 | 48 | 0 | 10 | 164 | 121 | 275 | Trypanosoma brucei gambiense DAL972 kinetoplastid membrane protein KMP-11 partial mRNA | blastn | 3944 | 182 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 17320708 | 17320708 | PRJNA760976_P_NODE_37454_length_278_cov_2.931707_g37133_i0 | PRJNA760976 | 37454 | 278 | 2.931707 | 8.15014546 | Rhynchomonas nasuta | 127150 | Euglenozoa | other_Eukaryota | 514 | 2.7199999999999996e-141 | NTclustered | gi|77994657|gb|DQ207595.1| | 127150 | g37133 | i0 | 100 | 88.1906474820144 | 278 | 0 | 100 | 0 | 1 | 278 | 1245 | 968 | Rhynchomonas nasuta strain HFCC17 18S ribosomal RNA gene, partial sequence | blastn | 24517 | 514 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchomonadidae | Rhynchomonas | Rhynchomonas nasuta | ||
| 21144857 | 21144857 | PRJNA760976_P_NODE_11857_length_422_cov_1.022923_g11537_i0 | PRJNA760976 | 11857 | 422 | 1.022923 | 4.31673506 | Herpetomonas muscarum | 5718 | Euglenozoa | other_Eukaryota | 375 | 2.12e-99 | NTclustered | gi|226347430|gb|FJ807255.1| | 5718 | g11537 | i0 | 82.938 | 98.9810426540284 | 422 | 66 | 99 | 3 | 4 | 422 | 622 | 1040 | Herpetomonas muscarum strain ATCC 30260 elongation factor 1 alpha gene, partial cds | blastn | 41770 | 375 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Herpetomonas | Herpetomonas muscarum | ||
| 23695403 | 23695403 | PRJNA760976_P_NODE_9859_length_452_cov_1.387863_g9540_i0 | PRJNA760976 | 9859 | 452 | 1.387863 | 6.27314076 | Entosiphon sp. | 1921133 | Euglenozoa | other_Eukaryota | 496 | 1.68e-135 | NTclustered | gi|1547024950|gb|MK213406.1| | 1921133 | g9540 | i0 | 86.726 | 22.8871681415929 | 452 | 52 | 99 | 7 | 1 | 450 | 1081 | 636 | Entosiphon sp. strain ESC small subunit ribosomal RNA, partial sequence | blastn | 10345 | 496 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sp. | ||
| 24968998 | 24968998 | PRJNA760976_P_NODE_4480_length_621_cov_3.239051_g4171_i0 | PRJNA760976 | 4480 | 621 | 3.239051 | 20.11450671 | Phacus orbicularis | 158829 | Euglenozoa | other_Eukaryota | 182 | 7.529999999999998e-41 | NTclustered | gi|194368888|gb|EU624018.1| | 158829 | g4171 | i0 | 85.311 | 28.2721417069243 | 177 | 24 | 28 | 2 | 446 | 621 | 1162 | 987 | Phacus orbicularis strain MI 76 large subunit ribosomal RNA gene, partial sequence | blastn | 17557 | 182 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Phacaceae | Phacus | Phacus orbicularis |
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);;