contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA540466" and tax_phylum = "Apicomplexa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5611626 | 5611626 | PRJNA540466_S_NODE_16605_length_431_cov_1.592179_g16058_i0 | PRJNA540466 | 16605 | 431 | 1.592179 | 6.86229149 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 1.0299999999999999e-82 | NTclustered | gi|209883067|ref|XM_002142926.1| | 441375 | g16058 | i0 | 97.838 | 0.4292343387471 | 185 | 4 | 43 | 0 | 247 | 431 | 254 | 70 | Cryptosporidium muris RN66 uncharacterized protein (CMU_004300), partial mRNA | blastn | 185 | 320 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 5612141 | 5612141 | PRJNA540466_S_NODE_9645_length_541_cov_8.177350_g9122_i0 | PRJNA540466 | 9645 | 541 | 8.17735 | 44.2394635 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 4.8499999999999996e-67 | NTclustered | gi|2787707067|ref|XM_067346846.1| | 1280935 | g9122 | i0 | 85.227 | 24.1959334565619 | 264 | 35 | 48 | 3 | 280 | 541 | 425 | 164 | Cryptosporidium sp. chipmunk genotype I calmodulin (ELE39_003701), partial mRNA | blastn | 13090 | 268 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I | ||
| 11986908 | 11986908 | PRJNA540466_S_NODE_53010_length_258_cov_1.545946_g52461_i0 | PRJNA540466 | 53010 | 258 | 1.545946 | 3.98854068 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 1.8e-8 | NTclustered | gi|1620167164|ref|XM_028681516.1| | 880535 | g52461 | i0 | 90.909 | 0.213178294573643 | 55 | 4 | 21 | 1 | 95 | 149 | 1136 | 1083 | Plasmodium sp. gorilla clade G2 conserved protein, unknown function (PADL01_0817200), partial mRNA | blastn | 55 | 73.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 17696387 | 17696387 | PRJNA540466_S_NODE_32454_length_317_cov_3.663934_g31905_i0 | PRJNA540466 | 32454 | 317 | 3.663934 | 11.61467078 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.8700000000000003e-27 | NTclustered | gi|1145261860|ref|XM_012909009.2| | 5854 | g31905 | i0 | 87.395 | 5.1608832807571 | 119 | 13 | 37 | 2 | 4 | 121 | 84 | 201 | Plasmodium reichenowi 40S ribosomal protein S27, putative partial mRNA | blastn | 1636 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 18359563 | 18359563 | PRJNA540466_S_NODE_38815_length_294_cov_1.389140_g38266_i0 | PRJNA540466 | 38815 | 294 | 1.38914 | 4.0840716 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.027 | NTclustered | gi|1620141828|ref|XM_028676858.1| | 85471 | g38266 | i0 | 100 | 0.0952380952380952 | 28 | 0 | 10 | 0 | 260 | 287 | 1392 | 1365 | Plasmodium relictum transcription factor with AP2 domain(s), putative (AP2-O), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 20244930 | 20244930 | PRJNA540466_S_NODE_51976_length_260_cov_1.663102_g51427_i0 | PRJNA540466 | 51976 | 260 | 1.663102 | 4.3240652 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.33e-49 | NTclustered | gi|527100028|dbj|AK441278.1| | 5865 | g51427 | i0 | 83.406 | 84.0807692307692 | 229 | 34 | 87 | 4 | 1 | 227 | 664 | 890 | Babesia bovis BBOV_III011800 mRNA for ribosomal protein L2 family protein, complete cds, clone: XBBk012367, strain: Texas | blastn | 21861 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 23460005 | 23460005 | PRJNA540466_S_NODE_1239_length_958_cov_9.723164_g1063_i0 | PRJNA540466 | 1239 | 958 | 9.723164 | 93.14791112 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.027 | NTclustered | gi|1620130649|ref|XM_028673638.1| | 5849 | g1063 | i0 | 100 | 0.0605427974947808 | 29 | 0 | 3 | 0 | 502 | 530 | 9964 | 9992 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00484800), partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 23460414 | 23460414 | PRJNA540466_S_NODE_57819_length_249_cov_3.363636_g57270_i0 | PRJNA540466 | 57819 | 249 | 3.363636 | 8.37545364 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|1931714186|ref|XM_008627441.2| | 54757 | g57270 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 156 | 183 | 631 | 604 | Plasmodium vinckei vinckei conserved Plasmodium membrane protein, unknown function (PVVCY_0500690), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei |
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);;