contig_metadata
12 rows where bioproject = "PRJNA784298", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2041390 | 2041390 | PRJNA784298_P_NODE_7922_length_447_cov_4.318182_g7721_i0 | PRJNA784298 | 7922 | 447 | 4.318182 | 19.30227354 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 793 | 0 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g7721 | i0 | 98.661 | 81.1834451901566 | 448 | 5 | 100 | 1 | 1 | 447 | 611 | 164 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 36289 | 793 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 8418555 | 8418555 | PRJNA784298_P_NODE_3647_length_668_cov_2.438655_g3451_i0 | PRJNA784298 | 3647 | 668 | 2.438655 | 16.2902154 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 966 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g3451 | i0 | 92.836 | 62.2065868263473 | 670 | 43 | 100 | 4 | 1 | 668 | 1965 | 1299 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 41554 | 966 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 12244951 | 12244951 | PRJNA784298_P_NODE_2310_length_837_cov_5.560209_g2130_i0 | PRJNA784298 | 2310 | 837 | 5.560209 | 46.53894933 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 1338 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g2130 | i0 | 95.59 | 27.5925925925926 | 839 | 29 | 100 | 7 | 1 | 837 | 2781 | 1949 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 23095 | 1338 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 13519192 | 13519192 | PRJNA784298_P_NODE_26851_length_241_cov_0.916667_g26650_i0 | PRJNA784298 | 26851 | 241 | 0.916667 | 2.20916747 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 3.46e-39 | NR | XP_001031773.1 | 312017 | g26650 | i0 | 93.7 | 0.983402489626556 | 79 | 5 | 98.3 | 0 | 239 | 3 | 203 | 281 | XP_001031773.1 methylthioribose kinase [Tetrahymena thermophila SB210] | diamond | 237 | 147 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 17343500 | 17343500 | PRJNA784298_P_NODE_14334_length_329_cov_3.851562_g14133_i0 | PRJNA784298 | 14334 | 329 | 3.851562 | 12.671638980000001 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 3.3099999999999994e-136 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14133 | i0 | 93.939 | 37.9088145896657 | 330 | 18 | 100 | 2 | 1 | 329 | 358 | 30 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12472 | 497 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19892065 | 19892065 | PRJNA784298_P_NODE_1136_length_1222_cov_5.310705_g1010_i0 | PRJNA784298 | 1136 | 1222 | 5.310705 | 64.8968151 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 1670 | 0 | NTclustered | gi|11466252|ref|NC_000862.1| | 5908 | g1010 | i0 | 91.368 | 58.8011456628478 | 1228 | 95 | 99 | 10 | 2 | 1222 | 32604 | 33827 | Tetrahymena pyriformis mitochondrion, complete genome | blastn | 71855 | 1670 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 19892105 | 19892105 | PRJNA784298_P_NODE_15436_length_317_cov_1.110656_g15235_i0 | PRJNA784298 | 15436 | 317 | 1.110656 | 3.52077952 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 7.319999999999998e-88 | NTclustered | gi|118379397|ref|XM_001022864.1| | 312017 | g15235 | i0 | 85.893 | 1.00630914826498 | 319 | 41 | 100 | 4 | 1 | 317 | 168 | 484 | Tetrahymena thermophila SB210 60S ribosomal protein L13 partial mRNA | blastn | 319 | 337 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23718166 | 23718166 | PRJNA784298_P_NODE_20839_length_269_cov_17.653061_g20638_i0 | PRJNA784298 | 20839 | 269 | 17.653061 | 47.48673409 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 4.66e-94 | NTclustered | gi|829158923|ref|XM_012796529.1| | 312017 | g20638 | i0 | 96.729 | 3.46468401486989 | 214 | 7 | 80 | 0 | 9 | 222 | 50 | 263 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 932 | 357 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 24164804 | 24164804 | PRJNA784298_P_NODE_14899_length_322_cov_11.746988_g14698_i0 | PRJNA784298 | 14899 | 322 | 11.746988 | 37.82530136 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 2.41e-162 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g14698 | i0 | 99.379 | 88.4503105590062 | 322 | 2 | 100 | 0 | 1 | 322 | 1597 | 1918 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 28481 | 584 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 28957918 | 28957918 | PRJNA784298_P_NODE_23748_length_251_cov_0.865169_g23547_i0 | PRJNA784298 | 23748 | 251 | 0.865169 | 2.17157419 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 2.31e-20 | NR | KAL4436246.1 | 5901 | g23547 | i0 | 72.7 | 1.97211155378486 | 55 | 14 | 64.5 | 1 | 188 | 27 | 1 | 55 | KAL4436246.1 hypothetical protein ABPG74_015837 [Tetrahymena malaccensis] | diamond | 495 | 92.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30622222 | 30622222 | PRJNA784298_P_NODE_27613_length_232_cov_2.421384_g27412_i0 | PRJNA784298 | 27613 | 232 | 2.421384 | 5.61761088 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 2.37e-28 | NR | XP_001015806.1 | 312017 | g27412 | i0 | 73.3 | 0.969827586206897 | 75 | 20 | 97 | 0 | 7 | 231 | 1 | 75 | XP_001015806.1 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 225 | 114 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31033382 | 31033382 | PRJNA784298_P_NODE_25595_length_245_cov_0.895349_g25394_i0 | PRJNA784298 | 25595 | 245 | 0.895349 | 2.19360505 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 8.06e-33 | NR | XP_001030006.1 | 312017 | g25394 | i0 | 92.2 | 0.783673469387755 | 64 | 5 | 78.4 | 0 | 194 | 3 | 62 | 125 | XP_001030006.1 ornithine decarboxylase antizyme protein [Tetrahymena thermophila SB210] | diamond | 192 | 122 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;