contig_metadata
16 rows where bioproject = "PRJNA721440", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4538547 | 4538547 | PRJNA721440_S_NODE_4304_length_282_cov_5.163090_g4178_i0 | PRJNA721440 | 4304 | 282 | 5.16309 | 14.5599138 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 188 | 3.5399999999999984e-55 | NR | CDW86777.1 | 5949 | g4178 | i0 | 97.8 | 184.989361702128 | 93 | 2 | 98.9 | 0 | 281 | 3 | 77 | 169 | CDW86777.1 UNKNOWN [Stylonychia lemnae] | diamond | 52167 | 188 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 22871154 | 22871154 | PRJNA721440_S_NODE_7978_length_222_cov_3.225434_g7852_i0 | PRJNA721440 | 7978 | 222 | 3.225434 | 7.16046348 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.2e-20 | NTclustered | gi|3366652|gb|AF031320.1|AF031320 | 5911 | g7852 | i0 | 89.655 | 0.783783783783784 | 87 | 9 | 39 | 0 | 133 | 219 | 1105 | 1019 | Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds | blastn | 174 | 111 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23663182 | 23663182 | PRJNA721440_S_NODE_15579_length_174_cov_1.248000_g15453_i0 | PRJNA721440 | 15579 | 174 | 1.248 | 2.17152 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.93e-28 | NTclustered | gi|829175019|ref|XM_001017812.3| | 312017 | g15453 | i0 | 87.402 | 0.729885057471264 | 127 | 6 | 72 | 4 | 24 | 149 | 267 | 150 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 127 | 137 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27178308 | 27178308 | PRJNA721440_S_NODE_9822_length_206_cov_2.770701_g9696_i0 | PRJNA721440 | 9822 | 206 | 2.770701 | 5.70764406 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 1.69e-13 | NR | KAL4465295.1 | 5901 | g9696 | i0 | 72.3 | 1.36893203883495 | 47 | 13 | 68.4 | 0 | 201 | 61 | 1115 | 1161 | KAL4465295.1 hypothetical protein ABPG74_002009 [Tetrahymena malaccensis] | diamond | 282 | 74.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 28388910 | 28388910 | PRJNA721440_S_NODE_19326_length_163_cov_1.728070_g19200_i0 | PRJNA721440 | 19326 | 163 | 1.72807 | 2.8167541 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.04e-10 | NR | OMJ92653.1 | 5963 | g19200 | i0 | 81.3 | 1.80368098159509 | 32 | 3 | 53.4 | 1 | 1 | 87 | 101 | 132 | OMJ92653.1 hypothetical protein SteCoe_4526 [Stentor coeruleus] | diamond | 294 | 62.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 29083732 | 29083732 | PRJNA721440_S_NODE_17288_length_168_cov_1.394958_g17162_i0 | PRJNA721440 | 17288 | 168 | 1.394958 | 2.34352944 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 4.6e-18 | NR | KAL4480407.1 | 5901 | g17162 | i0 | 73.2 | 3 | 56 | 15 | 100 | 0 | 168 | 1 | 156 | 211 | KAL4480407.1 hypothetical protein ABPG74_020923 [Tetrahymena malaccensis] | diamond | 504 | 86.7 | 0.990772779700115 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 29357370 | 29357370 | PRJNA721440_S_NODE_4269_length_283_cov_2.196581_g4143_i0 | PRJNA721440 | 4269 | 283 | 2.196581 | 6.21632423 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00259 | NR | OMJ84219.1 | 5963 | g4143 | i0 | 44.4 | 0.57243816254417 | 54 | 28 | 56.2 | 2 | 170 | 12 | 9 | 61 | OMJ84219.1 hypothetical protein SteCoe_14706 [Stentor coeruleus] | diamond | 162 | 46.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 29546598 | 29546598 | PRJNA721440_S_NODE_16110_length_172_cov_1.252033_g15984_i0 | PRJNA721440 | 16110 | 172 | 1.252033 | 2.15349676 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 4.68e-4 | NR | CDW84271.1 | 5949 | g15984 | i0 | 62.9 | 1.02906976744186 | 35 | 13 | 61 | 0 | 148 | 44 | 298 | 332 | CDW84271.1 ubiquitin carboxyl-terminal hydrolase 40 [Stylonychia lemnae] | diamond | 177 | 47 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29841407 | 29841407 | PRJNA721440_S_NODE_12071_length_191_cov_1.345070_g11945_i0 | PRJNA721440 | 12071 | 191 | 1.34507 | 2.5690837 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0098 | NR | KAL4464683.1 | 5901 | g11945 | i0 | 78.3 | 0.706806282722513 | 23 | 5 | 36.1 | 0 | 115 | 183 | 304 | 326 | KAL4464683.1 hypothetical protein ABPG74_011244 [Tetrahymena malaccensis] | diamond | 135 | 43.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30188807 | 30188807 | PRJNA721440_S_NODE_6112_length_245_cov_6.316327_g5986_i0 | PRJNA721440 | 6112 | 245 | 6.316327 | 15.47500115 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.85e-12 | NR | CDW86430.1 | 5949 | g5986 | i0 | 49.2 | 1.50612244897959 | 65 | 32 | 79.6 | 1 | 45 | 239 | 303 | 366 | CDW86430.1 UNKNOWN [Stylonychia lemnae] | diamond | 369 | 72.4 | 0.994475138121547 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30305293 | 30305293 | PRJNA721440_S_NODE_2812_length_336_cov_2.073171_g2686_i0 | PRJNA721440 | 2812 | 336 | 2.073171 | 6.96585456 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 6.96e-30 | NR | XP_001023521.1 | 312017 | g2686 | i0 | 55 | 0.991071428571429 | 111 | 49 | 99.1 | 1 | 3 | 335 | 176 | 285 | XP_001023521.1 poly (3-hydroxybutyrate) depolymerase [Tetrahymena thermophila SB210] | diamond | 333 | 119 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30494509 | 30494509 | PRJNA721440_S_NODE_3313_length_313_cov_1.715909_g3187_i0 | PRJNA721440 | 3313 | 313 | 1.715909 | 5.37079517 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 4.02e-6 | NR | CDW84185.1 | 5949 | g3187 | i0 | 35.1 | 0.900958466453674 | 94 | 58 | 90.1 | 1 | 285 | 4 | 281 | 371 | CDW84185.1 ku p70 dna helicase [Stylonychia lemnae] | diamond | 282 | 55.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30557351 | 30557351 | PRJNA721440_S_NODE_7393_length_229_cov_1.155556_g7267_i0 | PRJNA721440 | 7393 | 229 | 1.155556 | 2.64622324 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 4.24e-5 | NR | XP_001022599.2 | 312017 | g7267 | i0 | 80 | 0.393013100436681 | 30 | 6 | 39.3 | 0 | 107 | 196 | 348 | 377 | XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210] | diamond | 90 | 50.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30936870 | 30936870 | PRJNA721440_S_NODE_15494_length_174_cov_2.384000_g15368_i0 | PRJNA721440 | 15494 | 174 | 2.384 | 4.14816 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 6.25e-12 | NR | CAG9316414.1 | 1481888 | g15368 | i0 | 66.7 | 3.27586206896552 | 48 | 16 | 82.8 | 0 | 171 | 28 | 287 | 334 | CAG9316414.1 unnamed protein product [Blepharisma stoltei] | diamond | 570 | 69.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 31000006 | 31000006 | PRJNA721440_S_NODE_19074_length_164_cov_0.904348_g18948_i0 | PRJNA721440 | 19074 | 164 | 0.904348 | 1.48313072 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 7.97e-18 | NR | XP_001011873.1 | 312017 | g18948 | i0 | 60.7 | 1.11585365853659 | 61 | 17 | 98.8 | 2 | 162 | 1 | 675 | 735 | XP_001011873.1 hypothetical protein TTHERM_00392970 [Tetrahymena thermophila SB210] | diamond | 183 | 85.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31136443 | 31136443 | PRJNA721440_S_NODE_18055_length_166_cov_1.658120_g17929_i0 | PRJNA721440 | 18055 | 166 | 1.65812 | 2.7524792 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 5.05e-6 | NR | CDW80950.1 | 5949 | g17929 | i0 | 47.1 | 2.76506024096386 | 51 | 27 | 92.2 | 0 | 3 | 155 | 481 | 531 | CDW80950.1 abc transporter family protein [Stylonychia lemnae] | diamond | 459 | 52.8 | 0.992424242424242 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;