contig_metadata
11 rows where bioproject = "PRJEB3181", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5158343 | 5158343 | PRJEB3181_P_NODE_5945_length_337_cov_8.624183_g5689_i0 | PRJEB3181 | 5945 | 337 | 8.624183 | 29.06349671 | Hepatozoon canis | 110120 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.8199999999999999e-34 | NTclustered | gi|1584069862|gb|MH615006.1| | 110120 | g5689 | i0 | 83.051 | 51.8367952522255 | 177 | 28 | 52 | 2 | 3 | 178 | 4487 | 4312 | Hepatozoon canis isolate 9992 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 17469 | 159 | 1 | Eukaryota | Sar | Apicomplexa | Hepatozoidae | Hepatozoon | Hepatozoon canis | ||||
| 7708338 | 7708338 | PRJEB3181_S_NODE_12887_length_180_cov_1.834483_g12594_i0 | PRJEB3181 | 12887 | 180 | 1.834483 | 3.3020694 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|2795621892|ref|XM_068064976.1| | 483139 | g12594 | i0 | 100 | 0.155555555555556 | 28 | 0 | 16 | 0 | 4 | 31 | 2867 | 2894 | Cystoisospora suis uncharacterized protein (CSUI_004792), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 12809491 | 12809491 | PRJEB3181_P_NODE_23091_length_169_cov_2.195652_g22826_i0 | PRJEB3181 | 23091 | 169 | 2.195652 | 3.71065188 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.3600000000000002e-27 | NTclustered | gi|1620142820|ref|XM_028677298.1| | 85471 | g22826 | i0 | 89.623 | 23.2603550295858 | 106 | 11 | 63 | 0 | 64 | 169 | 224 | 119 | Plasmodium relictum ubiquitin-60S ribosomal protein L40, putative (PRELSG_1104600), partial mRNA | blastn | 3931 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 17907585 | 17907585 | PRJEB3181_P_NODE_24475_length_163_cov_1.939394_g24210_i0 | PRJEB3181 | 24475 | 163 | 1.939394 | 3.16121222 | Siedleckia cf. nematoides | 2107686 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.73e-11 | NTclustered | gi|1360360838|gb|MH061198.1| | 2107686 | g24210 | i0 | 79.167 | 1.07975460122699 | 120 | 23 | 73 | 2 | 4 | 122 | 3871 | 3753 | Siedleckia cf. nematoides isolate WSBS 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 176 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Siedleckiidae | Siedleckia | Siedleckia cf. nematoides | ||
| 19181512 | 19181512 | PRJEB3181_S_NODE_13036_length_179_cov_1.909722_g12743_i0 | PRJEB3181 | 13036 | 179 | 1.909722 | 3.41840238 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 1.16e-8 | NTclustered | gi|1027957244|ref|XM_736644.2| | 31271 | g12743 | i0 | 95.556 | 0.251396648044693 | 45 | 2 | 25 | 0 | 53 | 97 | 1587 | 1543 | Plasmodium chabaudi chabaudi T-complex protein 1 subunit epsilon, putative (PCHAS_1218900), partial mRNA | blastn | 45 | 73.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 20456763 | 20456763 | PRJEB3181_P_NODE_22597_length_171_cov_3.214286_g22332_i0 | PRJEB3181 | 22597 | 171 | 3.214286 | 5.49642906 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|914996824|ref|XM_013391613.1| | 5801 | g22332 | i0 | 100 | 0.16374269005848 | 28 | 0 | 16 | 0 | 97 | 124 | 345 | 372 | Eimeria acervulina 60S acidic ribosomal protein P1, putative partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 27602183 | 27602183 | PRJEB3181_P_NODE_28264_length_150_cov_1.478992_g27999_i0 | PRJEB3181 | 28264 | 150 | 1.478992 | 2.218488 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 1.08e-19 | NR | XP_029220420.1 | 94643 | g27999 | i0 | 80 | 4 | 50 | 10 | 100 | 0 | 1 | 150 | 130 | 179 | XP_029220420.1 ribosomal protein RPS5 [Besnoitia besnoiti] | diamond | 600 | 87 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29432997 | 29432997 | PRJEB3181_S_NODE_8590_length_215_cov_2.338889_g8297_i0 | PRJEB3181 | 8590 | 215 | 2.338889 | 5.02861135 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 1.0799999999999999e-24 | NR | VWU51230.1 | 2600580 | g8297 | i0 | 71.8 | 1.98139534883721 | 71 | 20 | 99.1 | 0 | 215 | 3 | 18 | 88 | VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 426 | 98.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 29559462 | 29559462 | PRJEB3181_P_NODE_16930_length_202_cov_8.292398_g16666_i0 | PRJEB3181 | 16930 | 202 | 8.292398 | 16.75064396 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 5.64e-11 | NR | XP_012648114.1 | 1133968 | g16666 | i0 | 57.4 | 6.62376237623762 | 54 | 19 | 80.2 | 1 | 3 | 164 | 194 | 243 | XP_012648114.1 small subunit ribosomal protein S3Ae [Babesia microti strain RI] | diamond | 1338 | 66.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 30311630 | 30311630 | PRJEB3181_P_NODE_11092_length_255_cov_3.674107_g10828_i0 | PRJEB3181 | 11092 | 255 | 3.674107 | 9.36897285 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 7.62e-17 | NR | CAL7859112.1 | 1344799 | g10828 | i0 | 64.1 | 3.02352941176471 | 64 | 23 | 75.3 | 0 | 251 | 60 | 36 | 99 | CAL7859112.1 unnamed protein product [Sarcocystis calchasi] | diamond | 771 | 79.7 | 0.991217063989962 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 30563566 | 30563566 | PRJEB3181_P_NODE_12153_length_243_cov_4.825472_g11889_i0 | PRJEB3181 | 12153 | 243 | 4.825472 | 11.72589696 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.64e-16 | NR | KAK1936904.1 | 32595 | g11889 | i0 | 77.8 | 4 | 54 | 12 | 66.7 | 0 | 243 | 82 | 167 | 220 | KAK1936904.1 putative 40S ribosomal protein S5 [Babesia divergens] | diamond | 972 | 80.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia divergens |
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);;