contig_metadata
17 rows where bioproject = "PRJEB7799", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21815645 | 21815645 | PRJEB7799_P_NODE_178_length_386_cov_72.246499_g172_i0 | PRJEB7799 | 178 | 386 | 72.246499 | 278.87148614 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1e-17 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g172 | i0 | 88.043 | 3.25647668393782 | 92 | 6 | 24 | 5 | 108 | 198 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1257 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25526490 | 25526490 | PRJEB7799b_S_NODE_33_length_337_cov_39.983444_g32_i0 | PRJEB7799 | 33 | 337 | 39.983444 | 134.74420628 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.66e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g32 | i0 | 88.043 | 3.6053412462908 | 92 | 6 | 27 | 5 | 65 | 155 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1215 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25527062 | 25527062 | PRJEB7799f_S_NODE_4201_length_172_cov_3.321168_g4185_i0 | PRJEB7799 | 4201 | 172 | 3.321168 | 5.71240896 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 5.04e-22 | NTclustered | gi|1085197446|ref|XR_001974451.1| | 508771 | g4185 | i0 | 87.379 | 4.84302325581395 | 103 | 11 | 59 | 2 | 1 | 102 | 77 | 178 | Toxoplasma gondii ME49 28S ribosomal RNA rRNA | blastn | 833 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 25616962 | 25616962 | PRJEB7799k_S_NODE_17_length_560_cov_451.299048_g15_i0 | PRJEB7799 | 17 | 560 | 451.299048 | 2527.2746688 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 1.4299999999999996e-52 | NTclustered | gi|3323386|gb|U85705.1|IFU85705 | 482539 | g15 | i0 | 92.763 | 27.1946428571429 | 152 | 11 | 27 | 0 | 409 | 560 | 850 | 1001 | Isospora felis 28S large subunit ribosomal RNA gene, complete sequence | blastn | 15229 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 25662454 | 25662454 | PRJEB7799b_S_NODE_330_length_214_cov_8.575419_g329_i0 | PRJEB7799 | 330 | 214 | 8.575419 | 18.35139666 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.42e-23 | NTclustered | gi|1085197446|ref|XR_001974451.1| | 508771 | g329 | i0 | 87.156 | 4.11214953271028 | 109 | 12 | 50 | 2 | 85 | 192 | 178 | 71 | Toxoplasma gondii ME49 28S ribosomal RNA rRNA | blastn | 880 | 122 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 25662545 | 25662545 | PRJEB7799c_S_NODE_218_length_551_cov_265.808140_g201_i0 | PRJEB7799 | 218 | 551 | 265.80814 | 1464.6028514 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.48e-17 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g201 | i0 | 88.043 | 4.2486388384755 | 92 | 6 | 17 | 5 | 105 | 195 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 2341 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25800419 | 25800419 | PRJEB7799n_S_NODE_11355_length_156_cov_1.735537_g11318_i0 | PRJEB7799 | 11355 | 156 | 1.735537 | 2.70743772 | Plasmodium berghei ANKA | 5823 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.05e-35 | NTclustered | gi|1843566470|ref|XM_034568516.1| | 5823 | g11318 | i0 | 88.722 | 13.3525641025641 | 133 | 13 | 85 | 2 | 24 | 155 | 411 | 280 | Plasmodium berghei ANKA histone H3, putative (PBANKA_0108800), partial mRNA | blastn | 2083 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 25801058 | 25801058 | PRJEB7799p_S_NODE_19611_length_165_cov_3.030769_g19588_i0 | PRJEB7799 | 19611 | 165 | 3.030769 | 5.00076885 | Platyproteum noduliferae | 2903131 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.77e-6 | NTclustered | gi|2250018225|dbj|LC663666.1| | 2903131 | g19588 | i0 | 97.368 | 0.23030303030303 | 38 | 1 | 23 | 0 | 128 | 165 | 3340 | 3303 | Platyproteum noduliferae P1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 38 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Archigregarinorida | Selenidiidae | Platyproteum | Platyproteum noduliferae | ||
| 25936927 | 25936927 | PRJEB7799o_S_NODE_236_length_359_cov_5.385802_g228_i0 | PRJEB7799 | 236 | 359 | 5.385802 | 19.33502918 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 2.52e-33 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g228 | i0 | 77.055 | 40.9693593314763 | 292 | 53 | 81 | 9 | 24 | 312 | 1344 | 1624 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 14708 | 156 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 26070965 | 26070965 | PRJEB7799c_S_NODE_589_length_390_cov_5.783099_g566_i0 | PRJEB7799 | 589 | 390 | 5.783099 | 22.5540861 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 2.78e-28 | NTclustered | gi|1085197446|ref|XR_001974451.1| | 508771 | g566 | i0 | 88.235 | 2.44871794871795 | 119 | 11 | 30 | 3 | 248 | 364 | 178 | 61 | Toxoplasma gondii ME49 28S ribosomal RNA rRNA | blastn | 955 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 26071222 | 26071222 | PRJEB7799e_S_NODE_2165_length_293_cov_35.112403_g2088_i0 | PRJEB7799 | 2165 | 293 | 35.112403 | 102.87934079 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 7.4e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g2088 | i0 | 88.043 | 4.19453924914676 | 92 | 6 | 31 | 5 | 174 | 264 | 243 | 330 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1229 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26071257 | 26071257 | PRJEB7799e_S_NODE_6557_length_194_cov_3.515723_g6480_i0 | PRJEB7799 | 6557 | 194 | 3.515723 | 6.82050262 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.26e-23 | NTclustered | gi|1085197446|ref|XR_001974451.1| | 508771 | g6480 | i0 | 87.156 | 4.5360824742268004 | 109 | 12 | 56 | 2 | 16 | 123 | 71 | 178 | Toxoplasma gondii ME49 28S ribosomal RNA rRNA | blastn | 880 | 122 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 26207630 | 26207630 | PRJEB7799f_S_NODE_142_length_487_cov_18.820796_g128_i0 | PRJEB7799 | 142 | 487 | 18.820796 | 91.65727652 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.29e-17 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g128 | i0 | 88.043 | 5.04106776180698 | 92 | 6 | 19 | 5 | 52 | 142 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 2455 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26344819 | 26344819 | PRJEB7799n_S_NODE_5239_length_204_cov_16.402367_g5202_i0 | PRJEB7799 | 5239 | 204 | 16.402367 | 33.46082868 | Platyproteum noduliferae | 2903131 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 1.77e-7 | NTclustered | gi|2250018225|dbj|LC663666.1| | 2903131 | g5202 | i0 | 97.5 | 0.196078431372549 | 40 | 1 | 20 | 0 | 165 | 204 | 3340 | 3301 | Platyproteum noduliferae P1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 40 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Archigregarinorida | Selenidiidae | Platyproteum | Platyproteum noduliferae | ||
| 26433290 | 26433290 | PRJEB7799l_S_NODE_1351_length_345_cov_26.064516_g1322_i0 | PRJEB7799 | 1351 | 345 | 26.064516 | 89.9225802 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 5.13e-45 | NTclustered | gi|8927036|gb|AF076872.1|AF076872 | 482539 | g1322 | i0 | 92.029 | 40.0869565217391 | 138 | 11 | 40 | 0 | 1 | 138 | 569 | 432 | Isospora felis large subunit ribosomal RNA gene, partial sequence | blastn | 13830 | 195 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 32913777 | 32913777 | PRJEB7799p_S_NODE_4305_length_245_cov_558.147619_g4282_i0 | PRJEB7799 | 4305 | 245 | 558.147619 | 1367.46166655 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 3.45e-8 | NR | UVC54537.1 | 68886 | g4282 | i0 | 58 | 0.612244897959184 | 50 | 21 | 61.2 | 0 | 244 | 95 | 166 | 215 | UVC54537.1 60S ribosomal L1/L10a protein [Theileria orientalis] | diamond | 150 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32974784 | 32974784 | PRJEB7799p_S_NODE_5418_length_228_cov_2.378238_g5395_i0 | PRJEB7799 | 5418 | 228 | 2.378238 | 5.42238264 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 2.12e-14 | NR | XP_013229778.1 | 5802 | g5395 | i0 | 66.1 | 3.11842105263158 | 59 | 20 | 77.6 | 0 | 225 | 49 | 41 | 99 | XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella] | diamond | 711 | 72.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella |
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);;