contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9436960 | 9436960 | PRJNA541476_P_NODE_25208_length_262_cov_1.634921_g25002_i0 | PRJNA541476 | 25208 | 262 | 1.634921 | 4.28349302 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.97e-5 | NTclustered | gi|82705688|ref|XM_721979.1| | 5861 | g25002 | i0 | 97.222 | 1.51908396946565 | 36 | 1 | 14 | 0 | 227 | 262 | 1172 | 1137 | Plasmodium yoelii conserved Plasmodium protein, unknown function (PY17X_0912100), partial mRNA | blastn | 398 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 10712569 | 10712569 | PRJNA541476_P_NODE_1529_length_960_cov_3.632469_g1381_i0 | PRJNA541476 | 1529 | 960 | 3.632469 | 34.8717024 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.027 | NTclustered | gi|916505125|ref|XM_013497709.1| | 44415 | g1381 | i0 | 96.875 | 0.0333333333333333 | 32 | 1 | 3 | 0 | 316 | 347 | 820 | 851 | Eimeria mitis uncharacterized protein (EMH_0059720), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 11987575 | 11987575 | PRJNA541476_P_NODE_29530_length_251_cov_1.443820_g29324_i0 | PRJNA541476 | 29530 | 251 | 1.44382 | 3.6239882 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.28e-49 | NTclustered | gi|1084892469|ref|XM_018787044.1| | 647221 | g29324 | i0 | 82.041 | 32.808764940239 | 245 | 44 | 98 | 0 | 4 | 248 | 505 | 749 | Plasmodium gaboni putative 26S protease regulatory subunit 8 partial mRNA | blastn | 8235 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 14537192 | 14537192 | PRJNA541476_P_NODE_12452_length_331_cov_1.732558_g12246_i0 | PRJNA541476 | 12452 | 331 | 1.732558 | 5.73476698 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916498997|ref|XM_013494864.1| | 44415 | g12246 | i0 | 100 | 8.52567975830816 | 30 | 0 | 9 | 0 | 280 | 309 | 432 | 461 | Eimeria mitis uncharacterized protein (EMH_0034390), partial mRNA | blastn | 2822 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 14537691 | 14537691 | PRJNA541476_P_NODE_32132_length_249_cov_0.880682_g31926_i0 | PRJNA541476 | 32132 | 249 | 0.880682 | 2.19289818 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|209877626|ref|XM_002140219.1| | 441375 | g31926 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 50 | 77 | 366 | 393 | Cryptosporidium muris RN66 uncharacterized protein (CMU_016560), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 17086140 | 17086140 | PRJNA541476_P_NODE_23134_length_269_cov_3.943878_g22928_i0 | PRJNA541476 | 23134 | 269 | 3.943878 | 10.60903182 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.88e-13 | NTclustered | gi|2785757340|ref|XM_067215922.1| | 5824 | g22928 | i0 | 83.505 | 1.44981412639405 | 97 | 15 | 36 | 1 | 15 | 111 | 1208 | 1303 | Plasmodium brasilianum 50S ribosomal protein L1 (MKS88_000484), partial mRNA | blastn | 390 | 89.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 17696508 | 17696508 | PRJNA541476_P_NODE_6394_length_447_cov_1.248663_g6191_i0 | PRJNA541476 | 6394 | 447 | 1.248663 | 5.58152361 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|2785763772|ref|XM_067216866.1| | 5824 | g6191 | i0 | 97.143 | 1.98434004474273 | 35 | 0 | 8 | 1 | 349 | 382 | 2231 | 2197 | Plasmodium brasilianum uncharacterized protein (MKS88_003745), partial mRNA | blastn | 887 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum |
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);;