contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1101946" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1485929 | 1485929 | PRJNA1101946_S_NODE_1862_length_403_cov_162.672316_g1763_i0 | PRJNA1101946 | 1862 | 403 | 162.672316 | 655.56943348 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 4.860000000000001e-21 | NTclustered | gi|325194684|emb|FR825494.1| | 890382 | g1763 | i0 | 79.096 | 34.6178660049628 | 177 | 30 | 43 | 7 | 199 | 372 | 202 | 30 | Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 | blastn | 13951 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 6589393 | 6589393 | PRJNA1101946_S_NODE_3986_length_330_cov_5.448399_g3887_i0 | PRJNA1101946 | 3986 | 330 | 5.448399 | 17.9797167 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 2e-133 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g3887 | i0 | 93.155 | 1222.11515151515 | 336 | 17 | 100 | 3 | 1 | 330 | 144 | 479 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 403298 | 488 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 10414625 | 10414625 | PRJNA1101946_S_NODE_10809_length_239_cov_15.447368_g10710_i0 | PRJNA1101946 | 10809 | 239 | 15.447368 | 36.91920952 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 4.0099999999999996e-104 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g10710 | i0 | 100 | 43.7405857740586 | 211 | 0 | 88 | 0 | 1 | 211 | 2023 | 1813 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 10454 | 390 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 11689985 | 11689985 | PRJNA1101946_S_NODE_7390_length_276_cov_4.991189_g7291_i0 | PRJNA1101946 | 7390 | 276 | 4.991189 | 13.77568164 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g7291 | i0 | 100 | 0.206521739130435 | 29 | 0 | 11 | 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 | |||
| 12965101 | 12965101 | PRJNA1101946_S_NODE_1551_length_426_cov_11.572944_g1452_i0 | PRJNA1101946 | 1551 | 426 | 11.572944 | 49.30074144 | Phalacroma oxytoxoides | 447216 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.041 | NTclustered | gi|2742502725|gb|PP905714.1| | 447216 | g1452 | i0 | 100 | 0.131455399061033 | 28 | 0 | 7 | 0 | 399 | 426 | 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 | |||
| 15047551 | 15047551 | PRJNA1101946_S_NODE_11812_length_231_cov_6.818681_g11713_i0 | PRJNA1101946 | 11812 | 231 | 6.818681 | 15.75115311 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 2.9399999999999998e-115 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g11713 | i0 | 100 | 99.969696969697 | 231 | 0 | 100 | 0 | 1 | 231 | 1241 | 1471 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 23093 | 427 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 15513894 | 15513894 | PRJNA1101946_S_NODE_15273_length_206_cov_1.624204_g15174_i0 | PRJNA1101946 | 15273 | 206 | 1.624204 | 3.34586024 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g15174 | i0 | 100 | 0.281553398058252 | 30 | 0 | 15 | 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 | |||
| 15513919 | 15513919 | PRJNA1101946_S_NODE_2873_length_359_cov_6.422581_g2774_i0 | PRJNA1101946 | 2873 | 359 | 6.422581 | 23.05706579 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g2774 | i0 | 100 | 0.395543175487465 | 30 | 0 | 8 | 0 | 1 | 30 | 10 | 39 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 142 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 18062936 | 18062936 | PRJNA1101946_S_NODE_15835_length_202_cov_3.810458_g15736_i0 | PRJNA1101946 | 15835 | 202 | 3.810458 | 7.69712516 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g15736 | i0 | 96.97 | 0.301980198019802 | 33 | 0 | 16 | 1 | 1 | 33 | 9 | 40 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 61 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 18062944 | 18062944 | PRJNA1101946_S_NODE_20015_length_180_cov_2.335878_g19916_i0 | PRJNA1101946 | 20015 | 180 | 2.335878 | 4.2045804 | Platyophryides magnus | 1003332 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 3.87e-68 | NTclustered | gi|328684914|gb|HM122030.1| | 1003332 | g19916 | i0 | 93.889 | 48.4055555555556 | 180 | 10 | 100 | 1 | 1 | 180 | 204 | 26 | Platyophryides magnus isolate SNK09112401 macronuclear | blastn | 8713 | 270 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Platyophryidae | Platyophryides | Platyophryides magnus | ||
| 19337060 | 19337060 | PRJNA1101946_S_NODE_12776_length_224_cov_1.748571_g12677_i0 | PRJNA1101946 | 12776 | 224 | 1.748571 | 3.91679904 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g12677 | i0 | 100 | 0.254464285714286 | 29 | 0 | 13 | 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 | |||
| 21888069 | 21888069 | PRJNA1101946_S_NODE_16118_length_200_cov_11.602649_g16019_i0 | PRJNA1101946 | 16118 | 200 | 11.602649 | 23.205298 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.017 | NTclustered | gi|2795623848|ref|XM_068065954.1| | 483139 | g16019 | i0 | 100 | 0.28 | 28 | 0 | 14 | 0 | 1 | 28 | 2418 | 2391 | Cystoisospora suis morn repeat-containing protein (CSUI_005784), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 21888101 | 21888101 | PRJNA1101946_S_NODE_5018_length_310_cov_3.643678_g4919_i0 | PRJNA1101946 | 5018 | 310 | 3.643678 | 11.2954018 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g4919 | i0 | 100 | 0.454838709677419 | 29 | 0 | 9 | 0 | 282 | 310 | 38 | 10 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 22696832 | 22696832 | PRJNA1101946_S_NODE_16458_length_198_cov_9.630872_g16359_i0 | PRJNA1101946 | 16458 | 198 | 9.630872 | 19.06912656 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.17e-93 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g16359 | i0 | 98.99 | 99.7979797979798 | 198 | 2 | 100 | 0 | 1 | 198 | 1145 | 948 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 19760 | 355 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 23163621 | 23163621 | PRJNA1101946_S_NODE_9459_length_253_cov_3.127451_g9360_i0 | PRJNA1101946 | 9459 | 253 | 3.127451 | 7.91245103 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g9360 | i0 | 100 | 0.561264822134387 | 30 | 0 | 12 | 0 | 1 | 30 | 10 | 39 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 142 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 24437157 | 24437157 | PRJNA1101946_S_NODE_18420_length_188_cov_1.467626_g18321_i0 | PRJNA1101946 | 18420 | 188 | 1.467626 | 2.75913688 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g18321 | i0 | 100 | 0.75 | 29 | 0 | 15 | 0 | 160 | 188 | 38 | 10 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 24437158 | 24437158 | PRJNA1101946_S_NODE_18780_length_186_cov_1.116788_g18681_i0 | PRJNA1101946 | 18780 | 186 | 1.116788 | 2.07722568 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.64e-5 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g18681 | i0 | 100 | 0.327956989247312 | 33 | 0 | 18 | 0 | 154 | 186 | 41 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 61 | 62.1 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 25246252 | 25246252 | PRJNA1101946_S_NODE_25220_length_161_cov_1.366071_g25121_i0 | PRJNA1101946 | 25220 | 161 | 1.366071 | 2.19937431 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.24e-75 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g25121 | i0 | 99.379 | 37.2111801242236 | 161 | 1 | 100 | 0 | 1 | 161 | 1529 | 1689 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 5991 | 292 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis |
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);;