contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB6054" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26339464 | 26339464 | PRJEB6054_S_NODE_4703_length_229_cov_1562.252577_g4614_i0 | PRJEB6054 | 4703 | 229 | 1562.252577 | 3577.55840133 | root | 1 | Root_unresolved | Root_unresolved | 70.5 | 2.88e-13 | NR | KRX07156.1 | 266149 | g4614 | i0 | 75.6 | 1.10043668122271 | 41 | 10 | 53.7 | 0 | 228 | 106 | 101 | 141 | KRX07156.1 Nucleic acid-binding, OB-fold [Pseudocohnilembus persalinus] | diamond | 252 | 71.2 | 0.990168539325843 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32911619 | 32911619 | PRJEB6054_S_NODE_10025_length_177_cov_1.373239_g9936_i0 | PRJEB6054 | 10025 | 177 | 1.373239 | 2.43063303 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.41e-10 | NR | XP_001014606.1 | 312017 | g9936 | i0 | 90.9 | 0.559322033898305 | 33 | 3 | 55.9 | 0 | 101 | 3 | 1 | 33 | XP_001014606.1 phospholipid hydroperoxide glutathione peroxidase [Tetrahymena thermophila SB210] | diamond | 99 | 63.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32911635 | 32911635 | PRJEB6054_S_NODE_12713_length_162_cov_7.236220_g12624_i0 | PRJEB6054 | 12713 | 162 | 7.23622 | 11.7226764 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 1e-11 | NR | NP_049597.1 | 5908 | g12624 | i0 | 82.9 | 0.759259259259259 | 41 | 7 | 75.9 | 0 | 126 | 4 | 467 | 507 | NP_049597.1 orf1386 [Tetrahymena pyriformis] | diamond | 123 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 32911681 | 32911681 | PRJEB6054_S_NODE_6009_length_210_cov_3.091429_g5920_i0 | PRJEB6054 | 6009 | 210 | 3.091429 | 6.4920009 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 3.96e-19 | NR | XP_001026284.1 | 312017 | g5920 | i0 | 69 | 0.828571428571429 | 58 | 15 | 78.6 | 1 | 207 | 43 | 42 | 99 | XP_001026284.1 transmembrane protein, putative [Tetrahymena thermophila SB210] | diamond | 174 | 84 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32928915 | 32928915 | PRJEB6054_S_NODE_9353_length_181_cov_12.061644_g9264_i0 | PRJEB6054 | 9353 | 181 | 12.061644 | 21.83157564 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 9.97e-20 | NR | NP_049592.1 | 5908 | g9264 | i0 | 80.7 | 0.94475138121547 | 57 | 11 | 94.5 | 0 | 173 | 3 | 95 | 151 | NP_049592.1 orf237 [Tetrahymena pyriformis] | diamond | 171 | 88.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 32946029 | 32946029 | PRJEB6054_S_NODE_9722_length_179_cov_1.638889_g9633_i0 | PRJEB6054 | 9722 | 179 | 1.638889 | 2.93361131 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 6.91e-15 | NR | XP_012654375.1 | 312017 | g9633 | i0 | 87 | 1.52513966480447 | 46 | 6 | 77.1 | 0 | 166 | 29 | 474 | 519 | XP_012654375.1 transmembrane protein, putative [Tetrahymena thermophila SB210] | diamond | 273 | 77.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32974488 | 32974488 | PRJEB6054_S_NODE_8018_length_189_cov_1.779221_g7929_i0 | PRJEB6054 | 8018 | 189 | 1.779221 | 3.36272769 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.37e-5 | NR | KAL4430457.1 | 5901 | g7929 | i0 | 46 | 1.58730158730159 | 50 | 27 | 79.4 | 0 | 162 | 13 | 284 | 333 | KAL4430457.1 hypothetical protein ABPG74_013307 [Tetrahymena malaccensis] | diamond | 300 | 51.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 32980241 | 32980241 | PRJEB6054_S_NODE_11475_length_168_cov_1.195489_g11386_i0 | PRJEB6054 | 11475 | 168 | 1.195489 | 2.00842152 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 99.8 | 8.000000000000001e-23 | NR | XP_001026871.2 | 312017 | g11386 | i0 | 94.3 | 0.946428571428571 | 53 | 3 | 94.6 | 0 | 168 | 10 | 18 | 70 | XP_001026871.2 calmodulin-domain kinase [Tetrahymena thermophila SB210] | diamond | 159 | 99.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32980310 | 32980310 | PRJEB6054_S_NODE_9699_length_179_cov_2.909722_g9610_i0 | PRJEB6054 | 9699 | 179 | 2.909722 | 5.20840238 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 4.28e-4 | NR | XP_001026228.1 | 312017 | g9610 | i0 | 57.6 | 0.988826815642458 | 59 | 24 | 98.9 | 1 | 179 | 3 | 12 | 69 | XP_001026228.1 hypothetical protein TTHERM_00780720 [Tetrahymena thermophila SB210] | diamond | 177 | 45.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32997208 | 32997208 | PRJEB6054_S_NODE_9883_length_178_cov_1.377622_g9794_i0 | PRJEB6054 | 9883 | 178 | 1.377622 | 2.45216716 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.49e-25 | NR | XP_001007768.2 | 312017 | g9794 | i0 | 88.7 | 0.893258426966292 | 53 | 6 | 89.3 | 0 | 177 | 19 | 572 | 624 | XP_001007768.2 plasma-membrane choline transporter [Tetrahymena thermophila SB210] | diamond | 159 | 107 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33014188 | 33014188 | PRJEB6054_S_NODE_11268_length_169_cov_2.679104_g11179_i0 | PRJEB6054 | 11268 | 169 | 2.679104 | 4.52768576 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 2.37e-7 | NR | AAR04353.1 | 5911 | g11179 | i0 | 92.6 | 0.479289940828402 | 27 | 2 | 47.9 | 0 | 150 | 70 | 365 | 391 | AAR04353.1 putative MAPK [Tetrahymena thermophila] | diamond | 81 | 56.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33014210 | 33014210 | PRJEB6054_S_NODE_13364_length_159_cov_1.290323_g13275_i0 | PRJEB6054 | 13364 | 159 | 1.290323 | 2.05161357 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 2.9e-7 | NR | XP_004029999.1 | 5932 | g13275 | i0 | 78.4 | 0.69811320754717 | 37 | 8 | 69.8 | 0 | 111 | 1 | 528 | 564 | XP_004029999.1 hypothetical protein IMG5_168990 [Ichthyophthirius multifiliis] | diamond | 111 | 55.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 33014268 | 33014268 | PRJEB6054_S_NODE_9532_length_180_cov_3.800000_g9443_i0 | PRJEB6054 | 9532 | 180 | 3.8 | 6.84 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 3.46e-8 | NR | KAL4434734.1 | 5901 | g9443 | i0 | 87.1 | 1.03333333333333 | 31 | 4 | 51.7 | 0 | 137 | 45 | 218 | 248 | KAL4434734.1 hypothetical protein ABPG74_017154 [Tetrahymena malaccensis] | diamond | 186 | 58.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 33031342 | 33031342 | PRJEB6054_S_NODE_11276_length_169_cov_2.388060_g11187_i0 | PRJEB6054 | 11276 | 169 | 2.38806 | 4.0358214 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1e-27 | NR | KAL4490878.1 | 2486642 | g11187 | i0 | 83.3 | 0.958579881656805 | 54 | 9 | 95.9 | 0 | 167 | 6 | 48 | 101 | KAL4490878.1 hypothetical protein ABPG72_008614 [Tetrahymena utriculariae] | diamond | 162 | 107 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 33031372 | 33031372 | PRJEB6054_S_NODE_15916_length_150_cov_1.921739_g15827_i0 | PRJEB6054 | 15916 | 150 | 1.921739 | 2.8826085 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 2.5e-8 | NR | KAL4512865.1 | 2486642 | g15827 | i0 | 55.3 | 1.9 | 47 | 21 | 94 | 0 | 150 | 10 | 84 | 130 | KAL4512865.1 hypothetical protein ABPG72_017550 [Tetrahymena utriculariae] | diamond | 285 | 57 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 33099508 | 33099508 | PRJEB6054_S_NODE_12934_length_161_cov_2.079365_g12845_i0 | PRJEB6054 | 12934 | 161 | 2.079365 | 3.34777765 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 1.44e-12 | NR | XP_012653434.1 | 312017 | g12845 | i0 | 90.9 | 1.22981366459627 | 33 | 3 | 61.5 | 0 | 161 | 63 | 149 | 181 | XP_012653434.1 60S ribosomal protein L18 [Tetrahymena thermophila SB210] | diamond | 198 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33099515 | 33099515 | PRJEB6054_S_NODE_14902_length_154_cov_1.008403_g14813_i0 | PRJEB6054 | 14902 | 154 | 1.008403 | 1.55294062 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00322 | NR | KRX00626.1 | 266149 | g14813 | i0 | 60.6 | 0.642857142857143 | 33 | 11 | 60.4 | 1 | 129 | 37 | 158 | 190 | KRX00626.1 hypothetical protein PPERSA_00853 [Pseudocohnilembus persalinus] | diamond | 99 | 44.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 33116556 | 33116556 | PRJEB6054_S_NODE_1751_length_318_cov_13.706714_g1662_i0 | PRJEB6054 | 1751 | 318 | 13.706714 | 43.58735052 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.58e-26 | NR | XP_001010031.1 | 312017 | g1662 | i0 | 88.5 | 0.575471698113208 | 61 | 7 | 57.5 | 0 | 318 | 136 | 244 | 304 | XP_001010031.1 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] | diamond | 183 | 112 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33133708 | 33133708 | PRJEB6054_S_NODE_13319_length_159_cov_1.983871_g13230_i0 | PRJEB6054 | 13319 | 159 | 1.983871 | 3.15435489 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 1.66e-4 | NR | KAL4445598.1 | 5901 | g13230 | i0 | 78.1 | 0.60377358490566 | 32 | 4 | 54.7 | 1 | 158 | 72 | 54 | 85 | KAL4445598.1 hypothetical protein ABPG74_006149 [Tetrahymena malaccensis] | diamond | 96 | 46.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 33133709 | 33133709 | PRJEB6054_S_NODE_13359_length_159_cov_1.290323_g13270_i0 | PRJEB6054 | 13359 | 159 | 1.290323 | 2.05161357 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 3.86e-18 | NR | XP_012654694.1 | 312017 | g13270 | i0 | 79.2 | 1 | 53 | 11 | 100 | 0 | 159 | 1 | 199 | 251 | XP_012654694.1 LMBR1-like motif protein [Tetrahymena thermophila SB210] | diamond | 159 | 86.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33133728 | 33133728 | PRJEB6054_S_NODE_15631_length_151_cov_2.758621_g15542_i0 | PRJEB6054 | 15631 | 151 | 2.758621 | 4.16551771 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 3.14e-11 | NR | 2XZN_5 | 5911 | g15542 | i0 | 70.8 | 0.95364238410596 | 48 | 14 | 95.4 | 0 | 150 | 7 | 71 | 118 | 2XZN_5 Chain 5, Ribosomal Protein S26e Containing Protein [Tetrahymena thermophila] | diamond | 144 | 63.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33167690 | 33167690 | PRJEB6054_S_NODE_15408_length_152_cov_2.230769_g15319_i0 | PRJEB6054 | 15408 | 152 | 2.230769 | 3.39076888 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 1.03e-4 | NR | OMJ83458.1 | 5963 | g15319 | i0 | 40.4 | 2.82236842105263 | 47 | 28 | 92.8 | 0 | 5 | 145 | 132 | 178 | OMJ83458.1 hypothetical protein SteCoe_15627 [Stentor coeruleus] | diamond | 429 | 48.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 33167710 | 33167710 | PRJEB6054_S_NODE_6632_length_202_cov_2.976048_g6543_i0 | PRJEB6054 | 6632 | 202 | 2.976048 | 6.01161696 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 1.13e-14 | NR | NP_049570.1 | 5908 | g6543 | i0 | 82.6 | 1.35148514851485 | 46 | 8 | 68.3 | 0 | 3 | 140 | 298 | 343 | NP_049570.1 orf421 [Tetrahymena pyriformis] | diamond | 273 | 77.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis |
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);;