contig_metadata
16 rows where bioproject = "PRJNA613025", tax_phylum = "Apicomplexa" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3142324 | 3142324 | PRJNA613025_S_NODE_1023_length_2235_cov_3.654620_g990_i0 | PRJNA613025 | 1023 | 2235 | 3.65462 | 81.680757 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 1434 | 0 | NTclustered | gi|209883069|ref|XM_002142927.1| | 441375 | g990 | i0 | 98.522 | 0.36331096196868 | 812 | 12 | 36 | 0 | 216 | 1027 | 812 | 1 | Cryptosporidium muris RN66 uncharacterized protein (CMU_004310), partial mRNA | blastn | 812 | 1434 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 5695054 | 5695054 | PRJNA613025_S_NODE_10705_length_373_cov_1.151235_g10552_i0 | PRJNA613025 | 10705 | 373 | 1.151235 | 4.29410655 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.93e-137 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g10552 | i0 | 94.207 | 58.970509383378 | 328 | 19 | 100 | 0 | 5 | 332 | 298909 | 299236 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 21996 | 501 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6252433 | 6252433 | PRJNA613025_S_NODE_14405_length_289_cov_1.675000_g14251_i0 | PRJNA613025 | 14405 | 289 | 1.675 | 4.84075 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.01e-145 | NTclustered | gi|166084454|gb|EF024977.1| | 404735 | g14251 | i0 | 99.654 | 101.429065743945 | 289 | 1 | 100 | 0 | 1 | 289 | 1013 | 725 | Eimeriidae environmental sample clone Elev_18S_1525 18S ribosomal RNA gene, partial sequence | blastn | 29313 | 529 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 9520486 | 9520486 | PRJNA613025_S_NODE_7568_length_496_cov_3.539150_g7416_i0 | PRJNA613025 | 7568 | 496 | 3.53915 | 17.554184 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 773 | 0 | NTclustered | gi|209883090|ref|XM_002142934.1| | 441375 | g7416 | i0 | 94.758 | 1.85887096774194 | 496 | 26 | 100 | 0 | 1 | 496 | 831 | 336 | Cryptosporidium muris RN66 uncharacterized protein (CMU_002460), partial mRNA | blastn | 922 | 773 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 10077294 | 10077294 | PRJNA613025_S_NODE_25648_length_185_cov_1.794118_g25494_i0 | PRJNA613025 | 25648 | 185 | 1.794118 | 3.3191183 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.39e-70 | NTclustered | gi|166084454|gb|EF024977.1| | 404735 | g25494 | i0 | 94.022 | 59.5297297297297 | 184 | 10 | 99 | 1 | 2 | 184 | 1499 | 1316 | Eimeriidae environmental sample clone Elev_18S_1525 18S ribosomal RNA gene, partial sequence | blastn | 11013 | 278 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 13345618 | 13345618 | PRJNA613025_S_NODE_12991_length_316_cov_4.322097_g12837_i0 | PRJNA613025 | 12991 | 316 | 4.322097 | 13.65782652 | uncultured Gregarina | 2480866 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.16e-43 | NTclustered | gi|1496531432|gb|MG766260.1| | 2480866 | g12837 | i0 | 91.367 | 42.4050632911392 | 139 | 11 | 44 | 1 | 2 | 140 | 1126 | 1263 | Uncultured Gregarina small subunit ribosomal RNA gene, partial sequence | blastn | 13400 | 189 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | uncultured Gregarina | ||||
| 14620575 | 14620575 | PRJNA613025_S_NODE_15532_length_271_cov_1.337838_g15378_i0 | PRJNA613025 | 15532 | 271 | 1.337838 | 3.62554098 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 4.07e-15 | NTclustered | gi|820693004|tpe|LN714485.1| | 572307 | g15378 | i0 | 86.364 | 0.933579335793358 | 88 | 10 | 32 | 2 | 45 | 131 | 854667 | 854581 | TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome | blastn | 253 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14621043 | 14621043 | PRJNA613025_S_NODE_5072_length_677_cov_3.890127_g4931_i0 | PRJNA613025 | 5072 | 677 | 3.890127 | 26.33615979 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 588 | 4.1599999999999997e-163 | NTclustered | gi|209883090|ref|XM_002142934.1| | 441375 | g4931 | i0 | 97.935 | 2.82422451994092 | 339 | 7 | 50 | 0 | 339 | 677 | 1 | 339 | Cryptosporidium muris RN66 uncharacterized protein (CMU_002460), partial mRNA | blastn | 1912 | 588 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 14621091 | 14621091 | PRJNA613025_S_NODE_6592_length_555_cov_3.928854_g6442_i0 | PRJNA613025 | 6592 | 555 | 3.928854 | 21.8051397 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 1.2800000000000002e-122 | NTclustered | gi|209883067|ref|XM_002142926.1| | 441375 | g6442 | i0 | 98.819 | 0.457657657657658 | 254 | 3 | 46 | 0 | 115 | 368 | 1 | 254 | Cryptosporidium muris RN66 uncharacterized protein (CMU_004300), partial mRNA | blastn | 254 | 453 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 17169491 | 17169491 | PRJNA613025_S_NODE_1614_length_1619_cov_4.542675_g1563_i0 | PRJNA613025 | 1614 | 1619 | 4.542675 | 73.54590825 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 1969 | 0 | NTclustered | gi|209883104|ref|XM_002142938.1| | 441375 | g1563 | i0 | 98.057 | 1.65719579987647 | 1132 | 22 | 70 | 0 | 1 | 1132 | 1132 | 1 | Cryptosporidium muris RN66 uncharacterized protein (CMU_004200), partial mRNA | blastn | 2683 | 1969 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 19718215 | 19718215 | PRJNA613025_S_NODE_18896_length_230_cov_1.403315_g18742_i0 | PRJNA613025 | 18896 | 230 | 1.403315 | 3.2276245 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 9.42e-11 | NTclustered | gi|1931714359|ref|XR_552297.2| | 54757 | g18742 | i0 | 87.324 | 15.4565217391304 | 71 | 8 | 30 | 1 | 103 | 172 | 4032 | 4102 | Plasmodium vinckei vinckei ribosomal RNA (PVVCY_0502190), rRNA | blastn | 3555 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 20994173 | 20994173 | PRJNA613025_S_NODE_28757_length_172_cov_0.943089_g28603_i0 | PRJNA613025 | 28757 | 172 | 0.943089 | 1.62211308 | Theileria sp. CAAS-2005 | 346098 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 6.66e-6 | NTclustered | gi|75875723|gb|DQ187375.1| | 346098 | g28603 | i0 | 93.023 | 0.25 | 43 | 3 | 25 | 0 | 109 | 151 | 470 | 428 | Theileria sp. CAAS-2005 clone 23 unknown protein mRNA, partial cds | blastn | 43 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria sp. CAAS-2005 | ||
| 24817919 | 24817919 | PRJNA613025_S_NODE_17280_length_247_cov_1.545455_g17126_i0 | PRJNA613025 | 17280 | 247 | 1.545455 | 3.81727385 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.75e-36 | NTclustered | gi|697890192|ref|XM_009692043.1| | 869250 | g17126 | i0 | 80.275 | 0.882591093117409 | 218 | 43 | 88 | 0 | 12 | 229 | 169 | 386 | Theileria orientalis strain Shintoku ribosomal protein L23 partial mRNA | blastn | 218 | 165 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30851556 | 30851556 | PRJNA613025_S_NODE_19774_length_222_cov_1.173410_g19620_i0 | PRJNA613025 | 19774 | 222 | 1.17341 | 2.6049702 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.14e-8 | NR | TRY50678.1 | 756076 | g19620 | i0 | 40.8 | 2.71621621621622 | 76 | 43 | 100 | 1 | 1 | 222 | 305 | 380 | TRY50678.1 Elongation factor EF1-gamma (Glutathione S-transferase family) [Cryptosporidium tyzzeri] | diamond | 603 | 60.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium tyzzeri | ||
| 31597527 | 31597527 | PRJNA613025_S_NODE_29216_length_170_cov_1.256198_g29062_i0 | PRJNA613025 | 29216 | 170 | 1.256198 | 2.1355366 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 4.26e-12 | NR | OEH79924.1 | 88456 | g29062 | i0 | 86.1 | 3.24705882352941 | 36 | 5 | 63.5 | 0 | 63 | 170 | 188 | 223 | OEH79924.1 glycyl-tRNA synthetase [Cyclospora cayetanensis] | diamond | 552 | 69.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31692152 | 31692152 | PRJNA613025_S_NODE_32677_length_163_cov_0.894737_g32523_i0 | PRJNA613025 | 32677 | 163 | 0.894737 | 1.45842131 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 1.92e-16 | NR | XP_003884403.1 | 572307 | g32523 | i0 | 71.2 | 1.91411042944785 | 52 | 15 | 95.7 | 0 | 156 | 1 | 45 | 96 | XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool] | diamond | 312 | 77 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum |
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);;