contig_metadata
11 rows where bioproject = "PRJNA797655", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 786296 | 786296 | PRJNA797655_S_NODE_252301_length_157_cov_2.061404_g251696_i0 | PRJNA797655 | 252301 | 157 | 2.061404 | 3.23640428 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1620148648|ref|XM_028678292.1| | 85471 | g251696 | i0 | 96.97 | 0.75796178343948994 | 33 | 0 | 21 | 1 | 87 | 119 | 7414 | 7383 | Plasmodium relictum conserved Plasmodium protein, unknown function (PRELSG_1248400), partial mRNA | blastn | 119 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 7160569 | 7160569 | PRJNA797655_S_NODE_120406_length_227_cov_66.054348_g119801_i0 | PRJNA797655 | 120406 | 227 | 66.054348 | 149.94336996 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.25e-106 | NTclustered | gi|1624698142|ref|XM_029013939.1| | 189622 | g119801 | i0 | 98.238 | 219.378854625551 | 227 | 4 | 100 | 0 | 1 | 227 | 255 | 29 | Babesia ovata LINE-1 type transposase domain-containing 1-like protein (BOVATA_050220), partial mRNA | blastn | 49799 | 398 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 8439656 | 8439656 | PRJNA797655_S_NODE_263007_length_153_cov_2.672727_g262402_i0 | PRJNA797655 | 263007 | 153 | 2.672727 | 4.08927231 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 3.2899999999999992e-43 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g262402 | i0 | 88.889 | 18.4575163398693 | 153 | 15 | 100 | 1 | 1 | 153 | 5 | 155 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 2824 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 10992053 | 10992053 | PRJNA797655_S_NODE_55369_length_304_cov_3.459770_g54764_i0 | PRJNA797655 | 55369 | 304 | 3.45977 | 10.5177008 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 5.88e-29 | NTclustered | gi|697888195|ref|XM_009691046.1| | 869250 | g54764 | i0 | 94.565 | 0.302631578947368 | 92 | 4 | 30 | 1 | 185 | 276 | 91 | 1 | Theileria orientalis strain Shintoku ATP-dependent helicase partial mRNA | blastn | 92 | 141 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 12262844 | 12262844 | PRJNA797655_S_NODE_157670_length_201_cov_2.082278_g157065_i0 | PRJNA797655 | 157670 | 201 | 2.082278 | 4.18537878 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.04e-4 | NTclustered | gi|916428201|ref|XM_013379877.1| | 5802 | g157065 | i0 | 94.737 | 0.328358208955224 | 38 | 2 | 19 | 0 | 163 | 200 | 832 | 795 | Eimeria tenella ATPase 2, putative (ETH_00041590), partial mRNA | blastn | 66 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 13541971 | 13541971 | PRJNA797655_S_NODE_64391_length_289_cov_3.101626_g63786_i0 | PRJNA797655 | 64391 | 289 | 3.101626 | 8.96369914 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 2.32e-102 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g63786 | i0 | 91.003 | 21.8719723183391 | 289 | 20 | 100 | 5 | 1 | 289 | 296 | 14 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6321 | 385 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 16091217 | 16091217 | PRJNA797655_S_NODE_73473_length_276_cov_2.467811_g72868_i0 | PRJNA797655 | 73473 | 276 | 2.467811 | 6.81115836 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.025 | NTclustered | gi|347451407|gb|JF759282.1| | 5833 | g72868 | i0 | 100 | 0.304347826086957 | 28 | 0 | 10 | 0 | 48 | 75 | 656 | 629 | Plasmodium falciparum isolate 18_Seq5-C varC gene, partial sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 19069001 | 19069001 | PRJNA797655_S_NODE_20435_length_411_cov_1.739130_g19838_i0 | PRJNA797655 | 20435 | 411 | 1.73913 | 7.1478243 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 1.26e-86 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g19838 | i0 | 86.452 | 347.739659367397 | 310 | 35 | 74 | 5 | 1 | 304 | 325 | 17 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 142921 | 335 | 0.994029850746269 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 22460608 | 22460608 | PRJNA797655_S_NODE_160258_length_199_cov_111.307692_g159653_i0 | PRJNA797655 | 160258 | 199 | 111.307692 | 221.50230708 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.51e-97 | NTclustered | gi|1624698142|ref|XM_029013939.1| | 189622 | g159653 | i0 | 100 | 225.954773869347 | 199 | 0 | 100 | 0 | 1 | 199 | 227 | 29 | Babesia ovata LINE-1 type transposase domain-containing 1-like protein (BOVATA_050220), partial mRNA | blastn | 44965 | 368 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 25011104 | 25011104 | PRJNA797655_S_NODE_199280_length_179_cov_1.757353_g198675_i0 | PRJNA797655 | 199280 | 179 | 1.757353 | 3.14566187 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.94e-72 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g198675 | i0 | 95.506 | 29.2178770949721 | 178 | 6 | 99 | 1 | 1 | 178 | 334 | 159 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 5230 | 283 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 27243516 | 27243516 | PRJNA797655_S_NODE_104163_length_242_cov_1.788945_g103558_i0 | PRJNA797655 | 104163 | 242 | 1.788945 | 4.3292469 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00541 | NR | SBT55413.1 | 864142 | g103558 | i0 | 54.2 | 0.59504132231405 | 48 | 22 | 59.5 | 0 | 2 | 145 | 324 | 371 | SBT55413.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 144 | 45.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale |
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);;