contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1961031 | 1961031 | PRJNA703759_P_NODE_9842_length_431_cov_1.743017_g9366_i0 | PRJNA703759 | 9842 | 431 | 1.743017 | 7.51240327 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 5.59e-155 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g9366 | i0 | 90.3 | 1.11832946635731 | 433 | 34 | 100 | 6 | 1 | 431 | 472 | 898 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 482 | 560 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 3235781 | 3235781 | PRJNA703759_P_NODE_46963_length_244_cov_2.181287_g46487_i0 | PRJNA703759 | 46963 | 244 | 2.181287 | 5.32234028 | Babesia rodhaini | 5870 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1606504052|dbj|AB665055.1| | 5870 | g46487 | i0 | 96.97 | 0.479508196721311 | 33 | 1 | 14 | 0 | 13 | 45 | 4271 | 4239 | Babesia rodhaini apicoplast DNA, complete genome, strain: Australian | blastn | 117 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia rodhaini | ||
| 4512091 | 4512091 | PRJNA703759_P_NODE_15784_length_341_cov_3.179104_g15308_i0 | PRJNA703759 | 15784 | 341 | 3.179104 | 10.84074464 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 2.0299999999999994e-148 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g15308 | i0 | 95.308 | 1.09970674486804 | 341 | 13 | 100 | 2 | 1 | 341 | 711 | 1048 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 375 | 538 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 4512801 | 4512801 | PRJNA703759_P_NODE_43984_length_246_cov_1.919075_g43508_i0 | PRJNA703759 | 43984 | 246 | 1.919075 | 4.7209245 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 6.79e-117 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g43508 | i0 | 98.374 | 2.14227642276423 | 246 | 4 | 100 | 0 | 1 | 246 | 1468 | 1223 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 527 | 433 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 5788351 | 5788351 | PRJNA703759_P_NODE_51045_length_242_cov_0.923077_g50569_i0 | PRJNA703759 | 51045 | 242 | 0.923077 | 2.23384634 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.59e-19 | NTclustered | gi|47176057|gb|AY617637.1| | 94289 | g50569 | i0 | 86.598 | 0.400826446280992 | 97 | 13 | 40 | 0 | 28 | 124 | 321 | 225 | Sterkiella histriomuscorum clone UGC1O0003_N24_R genomic sequence | blastn | 97 | 108 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 10888367 | 10888367 | PRJNA703759_P_NODE_26829_length_278_cov_1.136585_g26353_i0 | PRJNA703759 | 26829 | 278 | 1.136585 | 3.1597063 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.5e-4 | NTclustered | gi|915140275|ref|XM_013481871.1| | 5804 | g26353 | i0 | 97.059 | 0.122302158273381 | 34 | 1 | 12 | 0 | 26 | 59 | 2747 | 2714 | Eimeria maxima hypothetical protein partial mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 13438142 | 13438142 | PRJNA703759_P_NODE_30651_length_264_cov_2.706806_g30175_i0 | PRJNA703759 | 30651 | 264 | 2.706806 | 7.14596784 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.61e-108 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g30175 | i0 | 94.34 | 103.931818181818 | 265 | 14 | 100 | 1 | 1 | 264 | 176 | 440 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 27438 | 405 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 13438420 | 13438420 | PRJNA703759_P_NODE_43211_length_247_cov_0.896552_g42735_i0 | PRJNA703759 | 43211 | 247 | 0.896552 | 2.21448344 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.71e-5 | NTclustered | gi|820688329|tpe|LN714474.1| | 572307 | g42735 | i0 | 97.222 | 4.1417004048583 | 36 | 1 | 15 | 0 | 8 | 43 | 1908964 | 1908929 | TPA_asm: Neospora caninum Liverpool, chromosome chrIa, complete genome | blastn | 1023 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14713444 | 14713444 | PRJNA703759_P_NODE_33632_length_255_cov_1.285714_g33156_i0 | PRJNA703759 | 33632 | 255 | 1.285714 | 3.2785707 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1474771164|gb|MH107388.1| | 323732 | g33156 | i0 | 96.97 | 0.23921568627451 | 33 | 0 | 13 | 1 | 38 | 70 | 12686 | 12655 | Babesia duncani isolate WA-1 apicoplast, complete genome | blastn | 61 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 15986981 | 15986981 | PRJNA703759_P_NODE_30773_length_264_cov_1.497382_g30297_i0 | PRJNA703759 | 30773 | 264 | 1.497382 | 3.95308848 | Mallomonas kalinae | 1261422 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 9.739999999999998e-101 | NTclustered | gi|859810704|gb|KM817907.1| | 1261422 | g30297 | i0 | 92.481 | 100.757575757576 | 266 | 18 | 100 | 2 | 1 | 264 | 1427 | 1692 | Mallomonas kalinae strain CCMP3213 26S ribosomal RNA gene, partial sequence | blastn | 26600 | 379 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Mallomonas | Mallomonas kalinae | |||
| 17262651 | 17262651 | PRJNA703759_P_NODE_43314_length_247_cov_0.896552_g42838_i0 | PRJNA703759 | 43314 | 247 | 0.896552 | 2.21448344 | Euplotes sp. BB-2004 | 291624 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|51947518|gb|AY608636.1| | 291624 | g42838 | i0 | 94.286 | 0.1417004048583 | 35 | 1 | 14 | 1 | 214 | 247 | 63 | 29 | Euplotes sp. BB-2004 hydrogenosomal NADH dehydrogenase 51 kDa subunit gene, complete cds; nuclear gene for hydrogenosomal product | blastn | 35 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes sp. BB-2004 | ||
| 24910291 | 24910291 | PRJNA703759_P_NODE_13700_length_363_cov_1.717241_g13224_i0 | PRJNA703759 | 13700 | 363 | 1.717241 | 6.23358483 | Pseudokeronopsis erythrina | 1230127 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 9.24e-28 | NTclustered | gi|2889127627|gb|PQ685978.1| | 1230127 | g13224 | i0 | 89.286 | 0.556473829201102 | 112 | 9 | 30 | 3 | 39 | 148 | 1432 | 1322 | Pseudokeronopsis erythrina isolate CUI1 mitochondrion, partial genome | blastn | 202 | 137 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Urostylida | Pseudokeronopsidae | Pseudokeronopsis | Pseudokeronopsis erythrina |
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);;