contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA356682" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2347824 | 2347824 | PRJNA356682_P_NODE_43182_length_243_cov_0.905882_g42491_i0 | PRJNA356682 | 43182 | 243 | 0.905882 | 2.20129326 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 8.09e-6 | NR | CDW75723.1 | 5949 | g42491 | i0 | 46.2 | 0.802469135802469 | 65 | 35 | 80.2 | 0 | 33 | 227 | 418 | 482 | CDW75723.1 UNKNOWN [Stylonychia lemnae] | diamond | 195 | 53.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 15700434 | 15700434 | PRJNA356682_P_NODE_37993_length_249_cov_0.875000_g37302_i0 | PRJNA356682 | 37993 | 249 | 0.875 | 2.17875 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.8799999999999999e-31 | NR | CAD8143567.1 | 43137 | g37302 | i0 | 72.8 | 1.95180722891566 | 81 | 22 | 97.6 | 0 | 248 | 6 | 25 | 105 | CAD8143567.1 unnamed protein product [Paramecium octaurelia] | diamond | 486 | 120 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 26790114 | 26790114 | PRJNA356682_P_NODE_43181_length_243_cov_0.905882_g42490_i0 | PRJNA356682 | 43181 | 243 | 0.905882 | 2.20129326 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 7.12e-21 | NR | CAI2362122.1 | 5936 | g42490 | i0 | 53.2 | 3.82716049382716 | 77 | 36 | 95.1 | 0 | 242 | 12 | 13 | 89 | CAI2362122.1 unnamed protein product [Moneuplotes crassus] | diamond | 930 | 95.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 27106279 | 27106279 | PRJNA356682_P_NODE_21722_length_311_cov_1.932773_g21031_i0 | PRJNA356682 | 21722 | 311 | 1.932773 | 6.01092403 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 5.2e-22 | NR | XP_001010178.1 | 312017 | g21031 | i0 | 52.9 | 1.67845659163987 | 87 | 39 | 83.9 | 1 | 310 | 50 | 229 | 313 | XP_001010178.1 von willebrand factor type A (vWA) domain was originally protein [Tetrahymena thermophila SB210] | diamond | 522 | 100 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28008124 | 28008124 | PRJNA356682_P_NODE_36185_length_251_cov_0.865169_g35494_i0 | PRJNA356682 | 36185 | 251 | 0.865169 | 2.17157419 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 3.3999999999999992e-31 | NR | XP_001430446.1 | 5888 | g35494 | i0 | 83.1 | 3.09561752988048 | 65 | 11 | 77.7 | 0 | 56 | 250 | 63 | 127 | XP_001430446.1 uncharacterized protein GSPATT00032900001 [Paramecium tetraurelia] | diamond | 777 | 116 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 28022554 | 28022554 | PRJNA356682_P_NODE_43205_length_243_cov_0.905882_g42514_i0 | PRJNA356682 | 43205 | 243 | 0.905882 | 2.20129326 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.36e-9 | NR | XP_001026042.2 | 312017 | g42514 | i0 | 66.7 | 1.67901234567901 | 42 | 14 | 51.9 | 0 | 54 | 179 | 842 | 883 | XP_001026042.2 elongation factor Tu GTP-binding domain protein [Tetrahymena thermophila SB210] | diamond | 408 | 63.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28291963 | 28291963 | PRJNA356682_P_NODE_38686_length_248_cov_0.880000_g37995_i0 | PRJNA356682 | 38686 | 248 | 0.88 | 2.1824 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 3.4899999999999995e-37 | NR | CAD8060461.1 | 5886 | g37995 | i0 | 73.8 | 1.93548387096774 | 80 | 21 | 96.8 | 0 | 2 | 241 | 8 | 87 | CAD8060461.1 unnamed protein product [Paramecium primaurelia] | diamond | 480 | 140 | 0.992857142857143 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 28527799 | 28527799 | PRJNA356682_P_NODE_36207_length_251_cov_0.865169_g35516_i0 | PRJNA356682 | 36207 | 251 | 0.865169 | 2.17157419 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 9.66e-18 | NR | CAI2381318.1 | 5936 | g35516 | i0 | 55.9 | 0.812749003984064 | 68 | 30 | 81.3 | 0 | 8 | 211 | 62 | 129 | CAI2381318.1 unnamed protein product [Moneuplotes crassus] | diamond | 204 | 83.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 28748577 | 28748577 | PRJNA356682_P_NODE_44927_length_241_cov_0.916667_g44236_i0 | PRJNA356682 | 44927 | 241 | 0.916667 | 2.20916747 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 1.23e-14 | NR | XP_001016282.2 | 312017 | g44236 | i0 | 42.9 | 0.95850622406639 | 77 | 42 | 95.9 | 1 | 241 | 11 | 345 | 419 | XP_001016282.2 UPF0505 protein C16orf62-like protein, putative [Tetrahymena thermophila SB210] | diamond | 231 | 78.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28938146 | 28938146 | PRJNA356682_P_NODE_32728_length_261_cov_1.632979_g32037_i0 | PRJNA356682 | 32728 | 261 | 1.632979 | 4.26207519 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 3.36e-21 | NR | KRX10357.1 | 266149 | g32037 | i0 | 53.8 | 0.919540229885057 | 80 | 36 | 90.8 | 1 | 261 | 25 | 92 | 171 | KRX10357.1 Nucleic acid-binding, OB-fold [Pseudocohnilembus persalinus] | diamond | 240 | 94.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29001591 | 29001591 | PRJNA356682_P_NODE_41328_length_245_cov_0.895349_g40637_i0 | PRJNA356682 | 41328 | 245 | 0.895349 | 2.19360505 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 5.72e-21 | NR | XP_001014626.2 | 312017 | g40637 | i0 | 58.1 | 1.0530612244898 | 86 | 30 | 98 | 2 | 2 | 241 | 4397 | 4482 | XP_001014626.2 dynein heavy chain, cytoplasmic protein [Tetrahymena thermophila SB210] | diamond | 258 | 96.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29239406 | 29239406 | PRJNA356682_P_NODE_44909_length_241_cov_0.916667_g44218_i0 | PRJNA356682 | 44909 | 241 | 0.916667 | 2.20916747 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 1.69e-11 | NR | XP_004027587.1 | 5932 | g44218 | i0 | 48.6 | 3.5103734439834 | 72 | 37 | 89.6 | 0 | 22 | 237 | 111 | 182 | XP_004027587.1 ATP synthase delta subunit precursor, putative [Ichthyophthirius multifiliis] | diamond | 846 | 67.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29380068 | 29380068 | PRJNA356682_P_NODE_38729_length_248_cov_0.880000_g38038_i0 | PRJNA356682 | 38729 | 248 | 0.88 | 2.1824 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 4.48e-29 | NR | KAL4454916.1 | 5901 | g38038 | i0 | 76 | 1.81451612903226 | 75 | 18 | 90.7 | 0 | 23 | 247 | 502 | 576 | KAL4454916.1 hypothetical protein ABPG74_006298 [Tetrahymena malaccensis] | diamond | 450 | 119 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 29695464 | 29695464 | PRJNA356682_P_NODE_40470_length_246_cov_0.890173_g39779_i0 | PRJNA356682 | 40470 | 246 | 0.890173 | 2.18982558 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 4.18e-6 | NR | AWX67865.1 | 282688 | g39779 | i0 | 39.5 | 0.926829268292683 | 76 | 46 | 92.7 | 0 | 244 | 17 | 47 | 122 | AWX67865.1 trichocyst matrix protein T2-A [Philasterides dicentrarchi] | diamond | 228 | 53.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 29727111 | 29727111 | PRJNA356682_P_NODE_39290_length_247_cov_0.885057_g38599_i0 | PRJNA356682 | 39290 | 247 | 0.885057 | 2.18609079 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 2.45e-10 | NR | KRX02598.1 | 266149 | g38599 | i0 | 41.2 | 0.825910931174089 | 68 | 40 | 82.6 | 0 | 246 | 43 | 33 | 100 | KRX02598.1 hypothetical protein PPERSA_11938 [Pseudocohnilembus persalinus] | diamond | 204 | 62.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29775970 | 29775970 | PRJNA356682_P_NODE_37571_length_249_cov_0.875000_g36880_i0 | PRJNA356682 | 37571 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 1.33e-12 | NR | KAL4430109.1 | 5901 | g36880 | i0 | 38.5 | 2.7710843373494 | 78 | 48 | 94 | 0 | 242 | 9 | 233 | 310 | KAL4430109.1 hypothetical protein ABPG74_013556 [Tetrahymena malaccensis] | diamond | 690 | 72.8 | 0.994505494505495 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30611829 | 30611829 | PRJNA356682_P_NODE_37393_length_249_cov_1.744318_g36702_i0 | PRJNA356682 | 37393 | 249 | 1.744318 | 4.34335182 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.04 | NR | CAD8050668.1 | 65129 | g36702 | i0 | 51.4 | 0.843373493975904 | 35 | 17 | 42.2 | 0 | 3 | 107 | 99 | 133 | CAD8050668.1 unnamed protein product [Paramecium sonneborni] | diamond | 210 | 42.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 30675022 | 30675022 | PRJNA356682_P_NODE_36053_length_251_cov_0.865169_g35362_i0 | PRJNA356682 | 36053 | 251 | 0.865169 | 2.17157419 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.14e-5 | NR | XP_001453485.1 | 5888 | g35362 | i0 | 41 | 0.729083665338645 | 61 | 36 | 72.9 | 0 | 189 | 7 | 29 | 89 | XP_001453485.1 uncharacterized protein GSPATT00019781001 [Paramecium tetraurelia] | diamond | 183 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 30723831 | 30723831 | PRJNA356682_P_NODE_14294_length_374_cov_2.368771_g13604_i0 | PRJNA356682 | 14294 | 374 | 2.368771 | 8.85920354 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 9.1e-4 | NR | CAD8046551.1 | 5886 | g13604 | i0 | 46.7 | 2.2620320855615 | 60 | 31 | 48.1 | 1 | 373 | 194 | 95 | 153 | CAD8046551.1 unnamed protein product [Paramecium primaurelia] | diamond | 846 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 31686622 | 31686622 | PRJNA356682_P_NODE_40757_length_245_cov_1.779070_g40066_i0 | PRJNA356682 | 40757 | 245 | 1.77907 | 4.3587215 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 6.91e-18 | NR | XP_004030147.1 | 5932 | g40066 | i0 | 59.4 | 0.844897959183673 | 69 | 26 | 82 | 1 | 1 | 201 | 4 | 72 | XP_004030147.1 hypothetical protein IMG5_167050 [Ichthyophthirius multifiliis] | diamond | 207 | 84.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31813253 | 31813253 | PRJNA356682_P_NODE_41337_length_245_cov_0.895349_g40646_i0 | PRJNA356682 | 41337 | 245 | 0.895349 | 2.19360505 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 5.74e-25 | NR | XP_001023306.1 | 312017 | g40646 | i0 | 60.8 | 0.906122448979592 | 74 | 29 | 90.6 | 0 | 6 | 227 | 150 | 223 | XP_001023306.1 hypothetical protein TTHERM_00444440 [Tetrahymena thermophila SB210] | diamond | 222 | 103 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32604077 | 32604077 | PRJNA356682_P_NODE_34880_length_254_cov_1.541436_g34189_i0 | PRJNA356682 | 34880 | 254 | 1.541436 | 3.91524744 | Vorticella convallaria | 60850 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 2.9099999999999996e-48 | NR | AAD00995.1 | 60850 | g34189 | i0 | 95.2 | 0.992125984251969 | 84 | 4 | 99.2 | 0 | 252 | 1 | 52 | 135 | AAD00995.1 spasmin [Vorticella convallaria] | diamond | 252 | 160 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria |
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);;