contig_metadata
12 rows where bioproject = "PRJNA663960" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4456658 | 4456658 | PRJNA663960_S_NODE_35664_length_204_cov_0.974522_g35428_i0 | PRJNA663960 | 35664 | 204 | 0.974522 | 1.98802488 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g35428 | i0 | 100 | 0.279411764705882 | 29 | 0 | 14 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 8281927 | 8281927 | PRJNA663960_S_NODE_34107_length_208_cov_1.875776_g33871_i0 | PRJNA663960 | 34107 | 208 | 1.875776 | 3.90161408 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g33871 | i0 | 100 | 0.278846153846154 | 30 | 0 | 14 | 0 | 1 | 30 | 9 | 38 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 58 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 8282121 | 8282121 | PRJNA663960_S_NODE_61487_length_158_cov_1.378378_g61251_i0 | PRJNA663960 | 61487 | 158 | 1.378378 | 2.17783724 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.65e-16 | NTclustered | gi|829193802|ref|XM_001024808.3| | 312017 | g61251 | i0 | 89.61 | 10.6075949367089 | 77 | 8 | 49 | 0 | 80 | 156 | 910 | 834 | Tetrahymena thermophila SB210 serine/threonine-protein phosphatase PP1 partial mRNA | blastn | 1676 | 99 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12108027 | 12108027 | PRJNA663960_S_NODE_28010_length_229_cov_1.598901_g27774_i0 | PRJNA663960 | 28010 | 229 | 1.598901 | 3.66148329 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g27774 | i0 | 100 | 0.122270742358079 | 28 | 0 | 12 | 0 | 202 | 229 | 39 | 12 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 13382679 | 13382679 | PRJNA663960_S_NODE_21031_length_260_cov_1.755869_g20795_i0 | PRJNA663960 | 21031 | 260 | 1.755869 | 4.5652594 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 4.55e-84 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g20795 | i0 | 91.286 | 20.2346153846154 | 241 | 15 | 100 | 5 | 1 | 239 | 66 | 302 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 5261 | 324 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 13382801 | 13382801 | PRJNA663960_S_NODE_37551_length_199_cov_0.980263_g37315_i0 | PRJNA663960 | 37551 | 199 | 0.980263 | 1.95072337 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g37315 | i0 | 100 | 0.28643216080402 | 29 | 0 | 15 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 17206768 | 17206768 | PRJNA663960_S_NODE_32354_length_214_cov_0.916168_g32118_i0 | PRJNA663960 | 32354 | 214 | 0.916168 | 1.96059952 | Phalacroma oxytoxoides | 447216 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|2742502725|gb|PP905714.1| | 447216 | g32118 | i0 | 100 | 0.261682242990654 | 28 | 0 | 13 | 0 | 187 | 214 | 1225 | 1198 | Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Dinophyceae | Dinophysales | Dinophysaceae | Phalacroma | Phalacroma oxytoxoides | |||
| 17206845 | 17206845 | PRJNA663960_S_NODE_42974_length_186_cov_1.000000_g42738_i0 | PRJNA663960 | 42974 | 186 | 1 | 1.86 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g42738 | i0 | 100 | 0.306451612903226 | 29 | 0 | 16 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 18481183 | 18481183 | PRJNA663960_S_NODE_42955_length_186_cov_1.100719_g42719_i0 | PRJNA663960 | 42955 | 186 | 1.100719 | 2.04733734 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.016 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g42719 | i0 | 100 | 0.150537634408602 | 28 | 0 | 15 | 0 | 1 | 28 | 10 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 19755583 | 19755583 | PRJNA663960_S_NODE_21636_length_257_cov_1.700000_g21400_i0 | PRJNA663960 | 21636 | 257 | 1.7 | 4.369 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g21400 | i0 | 100 | 0.221789883268482 | 29 | 0 | 11 | 0 | 229 | 257 | 37 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 24854949 | 24854949 | PRJNA663960_S_NODE_28600_length_227_cov_1.416667_g28364_i0 | PRJNA663960 | 28600 | 227 | 1.416667 | 3.21583409 | Hematodinium sp. | 173654 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|357196844|emb|HE610736.1| | 173654 | g28364 | i0 | 100 | 0.123348017621145 | 28 | 0 | 12 | 0 | 1 | 28 | 2 | 29 | Hematodinium sp. mitochondrial partial small subunit ribosomal RNA (ssu rRNA gene), clone 16 | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Dinophyceae | Syndiniales | Syndiniaceae | Hematodinium | Hematodinium sp. | |||
| 29134314 | 29134314 | PRJNA663960_S_NODE_16369_length_286_cov_3.000000_g16133_i0 | PRJNA663960 | 16369 | 286 | 3 | 8.58 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00369 | NR | CAA67111.1 | 5855 | g16133 | i0 | 49.1 | 0.576923076923077 | 55 | 27 | 57.7 | 1 | 1 | 165 | 44 | 97 | CAA67111.1 PV14 [Plasmodium vivax] | diamond | 165 | 44.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax |
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);;