contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA771359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1206719 | 1206719 | PRJNA771359_S_NODE_2341_length_219_cov_3.923077_g2258_i0 | PRJNA771359 | 2341 | 219 | 3.923077 | 8.59153863 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 4.64e-108 | NTclustered | gi|219812771|gb|FJ552985.1| | 282477 | g2258 | i0 | 100 | 99.0639269406393 | 218 | 0 | 99 | 0 | 1 | 218 | 80 | 297 | Uncultured peritrich clone LTSP_EUKA_P1P06 18S ribosomal RNA, 18S-25/28S ribosomal RNA intergenic spacer, partial sequence | blastn | 21695 | 403 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Peritrichia | |||||
| 1206721 | 1206721 | PRJNA771359_S_NODE_2481_length_212_cov_11.685714_g2398_i0 | PRJNA771359 | 2481 | 212 | 11.685714 | 24.77371368 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 4.5e-103 | NTclustered | gi|297664831|gb|GU586177.1| | 768686 | g2398 | i0 | 99.528 | 98.1556603773585 | 212 | 1 | 100 | 0 | 1 | 212 | 551 | 340 | Vorticella sp. 8 PPS-2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 20809 | 387 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 8 PPS-2010 | ||
| 2023051 | 2023051 | PRJNA771359_S_NODE_3382_length_182_cov_7.613793_g3299_i0 | PRJNA771359 | 3382 | 182 | 7.613793 | 13.85710326 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 6.48e-76 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g3299 | i0 | 96.154 | 99.6153846153846 | 182 | 5 | 100 | 2 | 1 | 182 | 1827 | 1648 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18130 | 296 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 4575336 | 4575336 | PRJNA771359_S_NODE_424_length_464_cov_4.887588_g344_i0 | PRJNA771359 | 424 | 464 | 4.887588 | 22.67840832 | Hydrurus foetidus | 2996 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 9.48e-19 | NTclustered | gi|219903754|emb|FM955257.1| | 2996 | g344 | i0 | 89.535 | 18.2370689655172 | 86 | 7 | 18 | 2 | 199 | 282 | 1850 | 1765 | Hydrurus foetidus partial 28S rRNA gene | blastn | 8462 | 108 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus | |||
| 5850545 | 5850545 | PRJNA771359_S_NODE_1365_length_290_cov_29.079051_g1282_i0 | PRJNA771359 | 1365 | 290 | 29.079051 | 84.3292479 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 3.71e-135 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g1282 | i0 | 98.913 | 93.0034482758621 | 276 | 3 | 95 | 0 | 15 | 290 | 1450 | 1175 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 26971 | 494 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 5850565 | 5850565 | PRJNA771359_S_NODE_2205_length_225_cov_3.728723_g2122_i0 | PRJNA771359 | 2205 | 225 | 3.728723 | 8.38962675 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 4.24e-14 | NTclustered | gi|1027949921|ref|XR_001678647.1| | 31271 | g2122 | i0 | 78.523 | 1.75555555555556 | 149 | 24 | 65 | 6 | 9 | 154 | 1322 | 1465 | Plasmodium chabaudi chabaudi 28S ribosomal RNA (PCHAS_0521461), rRNA | blastn | 395 | 91.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 5850579 | 5850579 | PRJNA771359_S_NODE_2785_length_201_cov_2.121951_g2702_i0 | PRJNA771359 | 2785 | 201 | 2.121951 | 4.26512151 | Nephromyces sp. ex Molgula occidentalis | 2544991 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.04e-4 | NTclustered | gi|1735073273|gb|MK573204.1| | 2544991 | g2702 | i0 | 91.111 | 0.223880597014925 | 45 | 3 | 22 | 1 | 76 | 119 | 26345 | 26389 | Nephromyces sp. ex Molgula occidentalis isolate 638 apicoplast, partial genome | blastn | 45 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Nephromyces | Nephromyces sp. ex Molgula occidentalis | |||
| 7125801 | 7125801 | PRJNA771359_S_NODE_5166_length_151_cov_1.649123_g5083_i0 | PRJNA771359 | 5166 | 151 | 1.649123 | 2.49017573 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.12e-67 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g5083 | i0 | 98.675 | 61.3708609271523 | 151 | 2 | 100 | 0 | 1 | 151 | 692 | 842 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 9267 | 268 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 9675487 | 9675487 | PRJNA771359_S_NODE_3428_length_181_cov_2.701389_g3345_i0 | PRJNA771359 | 3428 | 181 | 2.701389 | 4.88951409 | Plasmodium fragile | 5857 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.2099999999999994e-24 | NTclustered | gi|817740972|ref|XM_012480018.1| | 5857 | g3345 | i0 | 81.169 | 3.70718232044199 | 154 | 29 | 85 | 0 | 22 | 175 | 385 | 232 | Plasmodium fragile ubiquitin-60S ribosomal protein L40 (AK88_02387), partial mRNA | blastn | 671 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile | ||
| 10135329 | 10135329 | PRJNA771359_S_NODE_1828_length_247_cov_4.895238_g1745_i0 | PRJNA771359 | 1828 | 247 | 4.895238 | 12.09123786 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4600000000000002e-123 | NTclustered | gi|363412151|gb|JN120225.1| | 1126581 | g1745 | i0 | 100 | 98.8623481781377 | 246 | 0 | 99 | 0 | 2 | 247 | 760 | 515 | Vorticella citrina isolate 78vor5253c1wh6S1S2 18S ribosomal RNA gene, partial sequence | blastn | 24419 | 455 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella citrina | ||
| 12226710 | 12226710 | PRJNA771359_S_NODE_1090_length_318_cov_13.380783_g1007_i0 | PRJNA771359 | 1090 | 318 | 13.380783 | 42.55088994 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 6.889999999999999e-133 | NTclustered | gi|134022138|gb|EF023488.1| | 404735 | g1007 | i0 | 94.099 | 100.729559748428 | 322 | 15 | 100 | 4 | 1 | 318 | 1630 | 1309 | Eimeriidae environmental sample clone Amb_18S_1074 18S ribosomal RNA gene, partial sequence | blastn | 32032 | 486 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 12226735 | 12226735 | PRJNA771359_S_NODE_2550_length_209_cov_16.482558_g2467_i0 | PRJNA771359 | 2550 | 209 | 16.482558 | 34.44854622 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.22e-46 | NTclustered | gi|512134965|gb|JX178924.1| | 1295638 | g2467 | i0 | 88.889 | 54.7177033492823 | 162 | 17 | 77 | 1 | 1 | 161 | 1646 | 1485 | Vorticella sp. 4 JG-2011 clone 24 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11436 | 198 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 12686382 | 12686382 | PRJNA771359_S_NODE_4250_length_164_cov_1.543307_g4167_i0 | PRJNA771359 | 4250 | 164 | 1.543307 | 2.53102348 | Peniculida | 33825 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.67e-28 | NTclustered | gi|2496410955|gb|OQ869837.1| | 2706568 | g4167 | i0 | 86.992 | 63.3536585365854 | 123 | 15 | 74 | 1 | 7 | 128 | 1642 | 1520 | Frontonia atra isolate S240 large subunit ribosomal RNA gene, partial sequence | blastn | 10390 | 137 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia atra | ||
| 16049672 | 16049672 | PRJNA771359_S_NODE_4993_length_153_cov_1.318966_g4910_i0 | PRJNA771359 | 4993 | 153 | 1.318966 | 2.01801798 | Carchesium polypinum | 168244 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 1.93e-60 | NTclustered | gi|281192505|gb|FJ883553.1| | 168244 | g4910 | i0 | 95.425 | 41.4183006535948 | 153 | 7 | 100 | 0 | 1 | 153 | 532 | 684 | Carchesium polypinum alpha-tubulin gene, partial cds | blastn | 6337 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Carchesium | Carchesium polypinum | ||
| 18598793 | 18598793 | PRJNA771359_S_NODE_2675_length_205_cov_1.273810_g2592_i0 | PRJNA771359 | 2675 | 205 | 1.27381 | 2.6113105 | Synura petersenii | 52555 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.7199999999999998e-32 | NTclustered | gi|282936683|gb|GU325065.1| | 52555 | g2592 | i0 | 80.193 | 21.7121951219512 | 207 | 37 | 100 | 4 | 1 | 205 | 91 | 295 | Synura petersenii strain NIES-1007 cytochrome b (cob) gene, partial cds; mitochondrial | blastn | 4451 | 152 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura petersenii | |||
| 19058485 | 19058485 | PRJNA771359_S_NODE_2275_length_222_cov_3.335135_g2192_i0 | PRJNA771359 | 2275 | 222 | 3.335135 | 7.4039997 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.48e-21 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g2192 | i0 | 90.698 | 29.3063063063063 | 86 | 8 | 39 | 0 | 2 | 87 | 8625 | 8710 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 6506 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 21149658 | 21149658 | PRJNA771359_S_NODE_637_length_389_cov_16.204545_g554_i0 | PRJNA771359 | 637 | 389 | 16.204545 | 63.03568005 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 636 | 8.069999999999999e-178 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g554 | i0 | 100 | 84.1156812339332 | 344 | 0 | 88 | 0 | 46 | 389 | 1839 | 1496 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 32721 | 636 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 24158412 | 24158412 | PRJNA771359_S_NODE_3859_length_171_cov_2.350746_g3776_i0 | PRJNA771359 | 3859 | 171 | 2.350746 | 4.01977566 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 4.6e-82 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3776 | i0 | 100 | 85.5146198830409 | 171 | 0 | 100 | 0 | 1 | 171 | 1927 | 1757 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 14623 | 316 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24973632 | 24973632 | PRJNA771359_S_NODE_1620_length_265_cov_1.600877_g1537_i0 | PRJNA771359 | 1620 | 265 | 1.600877 | 4.24232405 | Ochromonas danica | 2986 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.78e-50 | NTclustered | gi|11465862|ref|NC_002571.1| | 2986 | g1537 | i0 | 81.227 | 78.8603773584906 | 277 | 39 | 100 | 8 | 1 | 265 | 33334 | 33059 | Ochromonas danica mitochondrion, complete genome | blastn | 20898 | 211 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 24973677 | 24973677 | PRJNA771359_S_NODE_4200_length_165_cov_1.390625_g4117_i0 | PRJNA771359 | 4200 | 165 | 1.390625 | 2.29453125 | Lithomelissa setosa | 1054399 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 4.76e-32 | NTclustered | gi|1133507640|emb|LT673719.1| | 1054399 | g4117 | i0 | 83.648 | 6.09090909090909 | 159 | 26 | 96 | 0 | 1 | 159 | 18 | 176 | Lithomelissa setosa partial mRNA for Ribosomal Protein S14 (rps14 gene), isolate AKK-54 2016 | blastn | 1005 | 150 | 1 | Eukaryota | Sar | Polycystinea | Nassellaria | Plagiacanthidae | Lithomelissa | Lithomelissa setosa |
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);;