contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1098727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1485759 | 1485759 | PRJNA1098727_P_NODE_13102_length_168_cov_0.873950_g12861_i0 | PRJNA1098727 | 13102 | 168 | 0.87395 | 1.468236 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 7.859999999999997e-55 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g12861 | i0 | 91.018 | 9.59523809523809 | 167 | 15 | 99 | 0 | 2 | 168 | 300435 | 300601 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1612 | 226 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 1485764 | 1485764 | PRJNA1098727_P_NODE_13662_length_167_cov_0.881356_g13421_i0 | PRJNA1098727 | 13662 | 167 | 0.881356 | 1.47186452 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.53e-77 | NTclustered | gi|166046560|emb|CU367677.1| | 100861 | g13421 | i0 | 99.394 | 34.5808383233533 | 165 | 1 | 99 | 0 | 2 | 166 | 191 | 27 | Aphanomyces euteiches cDNA | blastn | 5775 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2761803 | 2761803 | PRJNA1098727_P_NODE_14523_length_165_cov_0.896552_g14282_i0 | PRJNA1098727 | 14523 | 165 | 0.896552 | 1.4793108 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 5.98e-51 | NTclustered | gi|829194196|ref|XM_001025062.3| | 312017 | g14282 | i0 | 90.244 | 0.993939393939394 | 164 | 15 | 99 | 1 | 2 | 164 | 253 | 90 | Tetrahymena thermophila SB210 40S ribosomal protein S24 partial mRNA | blastn | 164 | 213 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4037808 | 4037808 | PRJNA1098727_P_NODE_13324_length_168_cov_0.873950_g13083_i0 | PRJNA1098727 | 13324 | 168 | 0.87395 | 1.468236 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.58e-80 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g13083 | i0 | 100 | 1.46428571428571 | 167 | 0 | 99 | 0 | 1 | 167 | 1254 | 1088 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 246 | 309 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 5313977 | 5313977 | PRJNA1098727_P_NODE_6425_length_247_cov_1.510101_g6184_i0 | PRJNA1098727 | 6425 | 247 | 1.510101 | 3.72994947 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.15e-120 | NTclustered | gi|2589355395|ref|NC_077461.1| | 29204 | g6184 | i0 | 99.187 | 199.072874493927 | 246 | 2 | 99 | 0 | 1 | 246 | 71465 | 71710 | Cyclotella cryptica chloroplast, complete genome | blastn | 49171 | 444 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 6589194 | 6589194 | PRJNA1098727_P_NODE_10806_length_184_cov_1.525926_g10565_i0 | PRJNA1098727 | 10806 | 184 | 1.525926 | 2.80770384 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 8.430000000000001e-80 | NTclustered | gi|829174498|ref|XM_001017626.3| | 312017 | g10565 | i0 | 97.253 | 7.92391304347826 | 182 | 5 | 99 | 0 | 2 | 183 | 511 | 330 | Tetrahymena thermophila SB210 ubiquitin/ribosomal fusion protein, putative partial mRNA | blastn | 1458 | 309 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6589212 | 6589212 | PRJNA1098727_P_NODE_13846_length_166_cov_1.384615_g13605_i0 | PRJNA1098727 | 13846 | 166 | 1.384615 | 2.2984609 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 7.91e-40 | NTclustered | gi|829160192|ref|XM_001012283.3| | 312017 | g13605 | i0 | 89.362 | 1.36746987951807 | 141 | 13 | 84 | 2 | 2 | 141 | 68 | 207 | Tetrahymena thermophila SB210 40S ribosomal protein S28e, putative partial mRNA | blastn | 227 | 176 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 7397623 | 7397623 | PRJNA1098727_P_NODE_13706_length_167_cov_0.881356_g13465_i0 | PRJNA1098727 | 13706 | 167 | 0.881356 | 1.47186452 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.71e-79 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g13465 | i0 | 100 | 99.4011976047904 | 166 | 0 | 99 | 0 | 2 | 167 | 1280 | 1445 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 16600 | 307 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 7863811 | 7863811 | PRJNA1098727_P_NODE_14287_length_165_cov_1.034483_g14046_i0 | PRJNA1098727 | 14287 | 165 | 1.034483 | 1.70689695 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.47e-75 | NTclustered | gi|2589355395|ref|NC_077461.1| | 29204 | g14046 | i0 | 98.78 | 146.678787878788 | 164 | 2 | 99 | 0 | 1 | 164 | 80209 | 80372 | Cyclotella cryptica chloroplast, complete genome | blastn | 24202 | 292 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 12498631 | 12498631 | PRJNA1098727_P_NODE_14190_length_165_cov_2.189655_g13949_i0 | PRJNA1098727 | 14190 | 165 | 2.189655 | 3.61293075 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.69e-74 | NTclustered | gi|115353907|gb|DQ868347.1| | 77619 | g13949 | i0 | 98.773 | 99.2181818181818 | 163 | 2 | 99 | 0 | 2 | 164 | 625 | 787 | Vorticella microstoma 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16371 | 291 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella microstoma | ||
| 16788206 | 16788206 | PRJNA1098727_P_NODE_12934_length_169_cov_0.866667_g12693_i0 | PRJNA1098727 | 12934 | 169 | 0.866667 | 1.46466723 | Spumella sp. OF-40 | 1432661 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 3.63e-58 | NTclustered | gi|677286268|gb|KF997856.1| | 1432661 | g12693 | i0 | 92.216 | 30.9289940828402 | 167 | 13 | 99 | 0 | 2 | 168 | 1255 | 1089 | Spumella sp. OF-40 translation elongation factor 1-alpha (EF1A) mRNA, complete cds | blastn | 5227 | 237 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. OF-40 | |||
| 23163427 | 23163427 | PRJNA1098727_P_NODE_14559_length_165_cov_0.896552_g14318_i0 | PRJNA1098727 | 14559 | 165 | 0.896552 | 1.4793108 | Stephanocyclus meneghinianus | 29205 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 7.52e-70 | NTclustered | gi|2728412634|gb|OR666648.1| | 29205 | g14318 | i0 | 96.951 | 82 | 164 | 5 | 99 | 0 | 2 | 165 | 35096 | 35259 | Stephanocyclus meneghinianus chloroplast, complete genome | blastn | 13530 | 276 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Stephanocyclus | Stephanocyclus meneghinianus | ||
| 25246174 | 25246174 | PRJNA1098727_P_NODE_6260_length_251_cov_1.009901_g6019_i0 | PRJNA1098727 | 6260 | 251 | 1.009901 | 2.53485151 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 9.52e-76 | NTclustered | gi|2728412634|gb|OR666648.1| | 29205 | g6019 | i0 | 89.407 | 176.713147410359 | 236 | 24 | 94 | 1 | 2 | 237 | 69845 | 69611 | Stephanocyclus meneghinianus chloroplast, complete genome | blastn | 44355 | 296 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Stephanocyclus | Stephanocyclus meneghinianus |
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);;