contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1435533 | 1435533 | PRJNA1020854_S_NODE_15742_length_292_cov_19.414449_g12978_i0 | PRJNA1020854 | 15742 | 292 | 19.414449 | 56.69019108 | uncultured haptorid ciliate | 282486 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.07e-115 | NTclustered | gi|2006880526|emb|HG995482.1| | 282486 | g12978 | i0 | 93.174 | 100.513698630137 | 293 | 18 | 100 | 2 | 1 | 292 | 726 | 435 | uncultured haptorid ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone 05109c93 | blastn | 29350 | 429 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | uncultured haptorid ciliate | ||||
| 2711708 | 2711708 | PRJNA1020854_S_NODE_7883_length_521_cov_4.191057_g5239_i0 | PRJNA1020854 | 7883 | 521 | 4.191057 | 21.83540697 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 881 | 0 | NTclustered | gi|166046642|emb|CU367759.1| | 100861 | g5239 | i0 | 99.792 | 17.5067178502879 | 480 | 1 | 92 | 0 | 22 | 501 | 190 | 669 | Aphanomyces euteiches cDNA | blastn | 9121 | 881 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 4831418 | 4831418 | PRJNA1020854_S_NODE_37464_length_164_cov_2.540741_g34700_i0 | PRJNA1020854 | 37464 | 164 | 2.540741 | 4.16681524 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 2.86e-24 | NTclustered | gi|126142828|gb|EF070284.1| | 5898 | g34700 | i0 | 80.488 | 21.7560975609756 | 164 | 30 | 99 | 2 | 2 | 164 | 1629 | 1791 | Tetrahymena furgasoni strain GL(amicronucleate) cytochrome oxidase subunit I (cox1) gene, partial cds; mitochondrial | blastn | 3568 | 124 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena furgasoni | ||
| 7813305 | 7813305 | PRJNA1020854_S_NODE_15367_length_297_cov_1331.608209_g12603_i0 | PRJNA1020854 | 15367 | 297 | 1331.608209 | 3954.87638073 | Synura glabra | 52553 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 5.22e-94 | NTclustered | gi|859809332|gb|KM590638.1| | 52553 | g12603 | i0 | 94.068 | 69.4680134680135 | 236 | 12 | 79 | 2 | 54 | 288 | 147 | 381 | Synura glabra strain Jakeunmeok052407B 26S ribosomal RNA gene, partial sequence | blastn | 20632 | 357 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura glabra | |||
| 9088356 | 9088356 | PRJNA1020854_S_NODE_18968_length_255_cov_1438.150442_g16204_i0 | PRJNA1020854 | 18968 | 255 | 1438.150442 | 3667.2836271 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 7.28e-97 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g16204 | i0 | 100 | 180.6 | 198 | 0 | 78 | 0 | 1 | 198 | 157188 | 157385 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 46053 | 366 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 9931159 | 9931159 | PRJNA1020854_S_NODE_15008_length_302_cov_70.329670_g12244_i0 | PRJNA1020854 | 15008 | 302 | 70.32967 | 212.3956034 | Spumella | 89043 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 2.4199999999999994e-107 | NTclustered | gi|300713466|gb|GQ902928.1| | 152704 | g12244 | i0 | 93.68 | 71.7582781456954 | 269 | 15 | 89 | 2 | 23 | 290 | 73 | 340 | Uncultured stramenopile clone Ac-C2 28S ribosomal RNA gene, partial sequence | blastn | 21671 | 401 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 10363970 | 10363970 | PRJNA1020854_S_NODE_18169_length_263_cov_17.833333_g15405_i0 | PRJNA1020854 | 18169 | 263 | 17.833333 | 46.90166579 | Halodinium verrucatum | 2448773 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 3.69e-60 | NTclustered | gi|1489895921|dbj|LC424402.1| | 2448773 | g15405 | i0 | 86.818 | 56.9087452471483 | 220 | 27 | 83 | 2 | 12 | 230 | 219 | 1 | Halodinium verrucatum KC36_KC37 gene for 28S ribosomal RNA, partial sequence | blastn | 14967 | 244 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Halodinium | Halodinium verrucatum | |||
| 11639352 | 11639352 | PRJNA1020854_S_NODE_16890_length_278_cov_3.433735_g14126_i0 | PRJNA1020854 | 16890 | 278 | 3.433735 | 9.5457833 | Blastocystis hominis | 12968 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|855314860|ref|XM_013043203.1| | 12968 | g14126 | i0 | 96.875 | 0.115107913669065 | 32 | 0 | 11 | 1 | 131 | 161 | 1929 | 1960 | Blastocystis hominis mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 13756742 | 13756742 | PRJNA1020854_S_NODE_30531_length_186_cov_18.369427_g27767_i0 | PRJNA1020854 | 30531 | 186 | 18.369427 | 34.16713422 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 5.1400000000000004e-77 | NTclustered | gi|115353907|gb|DQ868347.1| | 77619 | g27767 | i0 | 99.394 | 89.1021505376344 | 165 | 1 | 89 | 0 | 22 | 186 | 610 | 774 | Vorticella microstoma 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16573 | 300 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella microstoma | ||
| 18012535 | 18012535 | PRJNA1020854_S_NODE_16655_length_280_cov_2203.111554_g13891_i0 | PRJNA1020854 | 16655 | 280 | 2203.111554 | 6168.7123512 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.39e-79 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g13891 | i0 | 90.909 | 170.392857142857 | 231 | 20 | 83 | 1 | 1 | 230 | 300541 | 300771 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 47710 | 309 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18013168 | 18013168 | PRJNA1020854_S_NODE_7915_length_518_cov_1089.292434_g5269_i0 | PRJNA1020854 | 7915 | 518 | 1089.292434 | 5642.53480812 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 765 | 0 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g5269 | i0 | 98.611 | 80.6563706563707 | 432 | 6 | 83 | 0 | 10 | 441 | 432 | 1 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 41780 | 765 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 18854959 | 18854959 | PRJNA1020854_S_NODE_27275_length_200_cov_15.625731_g24511_i0 | PRJNA1020854 | 27275 | 200 | 15.625731 | 31.251462 | root | 1 | Root_unresolved | Root_unresolved | 327 | 2.58e-85 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g24511 | i0 | 100 | 91.375 | 177 | 0 | 89 | 0 | 24 | 200 | 8294 | 8118 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 18275 | 327 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23955509 | 23955509 | PRJNA1020854_S_NODE_18639_length_258_cov_2342.532751_g15875_i0 | PRJNA1020854 | 18639 | 258 | 2342.532751 | 6043.73449758 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.66e-50 | NTclustered | gi|13236232|gb|AF318234.1| | 2935 | g15875 | i0 | 85.507 | 67.5426356589147 | 207 | 24 | 79 | 5 | 55 | 258 | 118 | 321 | Alexandrium insuetum 24S large subunit ribosomal RNA pseudogene, partial sequence | blastn | 17426 | 211 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Alexandrium | Alexandrium insuetum |
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);;