contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1248424" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 353056 | 353056 | PRJNA1248424_P_NODE_71021_length_249_cov_1.460227_g64952_i0 | PRJNA1248424 | 71021 | 249 | 1.460227 | 3.63596523 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|820697789|tpe|LN714496.1| | 432359 | g64952 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 89 | 116 | 4023229 | 4023202 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIIa, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 353149 | 353149 | PRJNA1248424_P_NODE_75621_length_245_cov_0.895349_g69552_i0 | PRJNA1248424 | 75621 | 245 | 0.895349 | 2.19360505 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 7.41e-52 | NTclustered | gi|2386235661|ref|XM_001440072.2| | 5888 | g69552 | i0 | 83.913 | 3.09387755102041 | 230 | 34 | 94 | 3 | 13 | 242 | 1015 | 1241 | Paramecium tetraurelia uncharacterized protein (GSPATT00009104001), mRNA | blastn | 758 | 217 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 4179342 | 4179342 | PRJNA1248424_P_NODE_20184_length_864_cov_3.487990_g14679_i0 | PRJNA1248424 | 20184 | 864 | 3.48799 | 30.1362336 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 1101 | 0 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g14679 | i0 | 89.711 | 97.9143518518518 | 865 | 85 | 99 | 4 | 1 | 863 | 1131 | 269 | Pyrocystis lunula actin mRNA, complete cds | blastn | 84598 | 1101 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 4180135 | 4180135 | PRJNA1248424_P_NODE_55124_length_288_cov_1.209302_g49056_i0 | PRJNA1248424 | 55124 | 288 | 1.209302 | 3.48278976 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.1499999999999995e-55 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g49056 | i0 | 84.956 | 103.777777777778 | 226 | 34 | 78 | 0 | 1 | 226 | 74 | 299 | Aphanomyces astaci polyubiquitin mRNA | blastn | 29888 | 230 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 6730757 | 6730757 | PRJNA1248424_P_NODE_60086_length_275_cov_1.910891_g54018_i0 | PRJNA1248424 | 60086 | 275 | 1.910891 | 5.25495025 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.51e-4 | NTclustered | gi|675177482|ref|XM_008899378.1| | 761204 | g54018 | i0 | 97.143 | 0.254545454545455 | 35 | 1 | 13 | 0 | 223 | 257 | 470 | 436 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 70 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 6731020 | 6731020 | PRJNA1248424_P_NODE_73766_length_247_cov_0.885057_g67697_i0 | PRJNA1248424 | 73766 | 247 | 0.885057 | 2.18609079 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.8e-4 | NTclustered | gi|915130510|ref|XM_013479897.1| | 5804 | g67697 | i0 | 97.143 | 2.37246963562753 | 35 | 0 | 14 | 1 | 77 | 111 | 3303 | 3336 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 586 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 10556880 | 10556880 | PRJNA1248424_P_NODE_47469_length_322_cov_3.449799_g41402_i0 | PRJNA1248424 | 47469 | 322 | 3.449799 | 11.10835278 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 4.119999999999998e-145 | NTclustered | gi|194245783|gb|EU828456.1| | 5888 | g41402 | i0 | 96.273 | 99.9192546583851 | 322 | 10 | 100 | 1 | 1 | 322 | 1805 | 1486 | Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence | blastn | 32174 | 527 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 11831525 | 11831525 | PRJNA1248424_P_NODE_56890_length_284_cov_0.862559_g50822_i0 | PRJNA1248424 | 56890 | 284 | 0.862559 | 2.44966756 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.8999999999999993e-111 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g50822 | i0 | 93.333 | 32.0422535211268 | 285 | 11 | 100 | 7 | 1 | 284 | 335 | 58 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 9100 | 414 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 14382159 | 14382159 | PRJNA1248424_P_NODE_60432_length_274_cov_2.099502_g54364_i0 | PRJNA1248424 | 60432 | 274 | 2.099502 | 5.75263548 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 4.7299999999999984e-99 | NTclustered | gi|2386227721|ref|XM_001430998.2| | 5888 | g54364 | i0 | 91.513 | 3.94160583941606 | 271 | 23 | 99 | 0 | 4 | 274 | 272 | 2 | Paramecium tetraurelia uncharacterized protein (GSPATT00033490001), partial mRNA | blastn | 1080 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 16354318 | 16354318 | PRJNA1248424_P_NODE_51273_length_302_cov_2.397380_g45205_i0 | PRJNA1248424 | 51273 | 302 | 2.39738 | 7.2400876 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.32e-153 | NTclustered | gi|1899794309|gb|MT975644.1| | 5887 | g45205 | i0 | 99.669 | 99.9867549668874 | 302 | 1 | 100 | 0 | 1 | 302 | 1236 | 1537 | Paramecium sp. strain RB1 small subunit ribosomal RNA gene, partial sequence | blastn | 30196 | 553 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sp. | ||
| 18204734 | 18204734 | PRJNA1248424_P_NODE_61295_length_272_cov_1.447236_g55227_i0 | PRJNA1248424 | 61295 | 272 | 1.447236 | 3.93648192 | Paramecium multimicronucleatum | 44030 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 2.67e-136 | NTclustered | gi|519419878|gb|KF287718.1| | 44030 | g55227 | i0 | 99.632 | 96.8125 | 272 | 1 | 100 | 0 | 1 | 272 | 557 | 286 | Paramecium multimicronucleatum isolate 2_m large subunit ribosomal RNA gene, partial sequence | blastn | 26333 | 497 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium multimicronucleatum | ||
| 20178059 | 20178059 | PRJNA1248424_P_NODE_67016_length_256_cov_1.737705_g60947_i0 | PRJNA1248424 | 67016 | 256 | 1.737705 | 4.4485248 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 5.42e-128 | NTclustered | gi|1899794309|gb|MT975644.1| | 5887 | g60947 | i0 | 100 | 98.51171875 | 254 | 0 | 99 | 0 | 1 | 254 | 520 | 773 | Paramecium sp. strain RB1 small subunit ribosomal RNA gene, partial sequence | blastn | 25219 | 470 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sp. | ||
| 20754148 | 20754148 | PRJNA1248424_P_NODE_41777_length_359_cov_1.115385_g35715_i0 | PRJNA1248424 | 41777 | 359 | 1.115385 | 4.00423215 | Oxytricha trifallax | 1172189 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.034 | NTclustered | gi|359817572|gb|JN383843.1| | 1172189 | g35715 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 137 | 164 | 52030 | 52057 | Oxytricha trifallax mitochondrion | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha trifallax | ||
| 22029901 | 22029901 | PRJNA1248424_P_NODE_67398_length_255_cov_1.692308_g61329_i0 | PRJNA1248424 | 67398 | 255 | 1.692308 | 4.3153854 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|457872231|ref|XM_004222987.1| | 1120755 | g61329 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 143 | 170 | 264 | 237 | Plasmodium cynomolgi strain B hypothetical protein (PCYB_111090) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 23305068 | 23305068 | PRJNA1248424_P_NODE_46999_length_325_cov_0.928571_g40932_i0 | PRJNA1248424 | 46999 | 325 | 0.928571 | 3.01785575 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|1085120952|ref|XM_002370838.2| | 508771 | g40932 | i0 | 100 | 0.0861538461538462 | 28 | 0 | 9 | 0 | 62 | 89 | 1625 | 1598 | Toxoplasma gondii ME49 hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 24579314 | 24579314 | PRJNA1248424_P_NODE_58660_length_279_cov_1.388350_g52592_i0 | PRJNA1248424 | 58660 | 279 | 1.38835 | 3.8734965 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 4.56e-139 | NTclustered | gi|301092521|ref|XM_002997070.1| | 403677 | g52592 | i0 | 99.639 | 0.992831541218638 | 277 | 1 | 99 | 0 | 1 | 277 | 545 | 821 | Phytophthora infestans T30-4 uncharacterized protein (PITG_19046), mRNA | blastn | 277 | 507 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans |
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);;