contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 199876 | 199876 | PRJNA1095825_P_NODE_152401_length_315_cov_1.909091_g149338_i0 | PRJNA1095825 | 152401 | 315 | 1.909091 | 6.01363665 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.8799999999999995e-138 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g149338 | i0 | 95.833 | 80.5365079365079 | 312 | 13 | 99 | 0 | 2 | 313 | 1075 | 1386 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 25369 | 505 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 200377 | 200377 | PRJNA1095825_P_NODE_214561_length_266_cov_1.404145_g211498_i0 | PRJNA1095825 | 214561 | 266 | 1.404145 | 3.7350257 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.2099999999999999e-134 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g211498 | i0 | 100 | 96.6654135338346 | 266 | 0 | 100 | 0 | 1 | 266 | 13 | 278 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 25713 | 492 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1476074 | 1476074 | PRJNA1095825_P_NODE_49962_length_541_cov_1.307692_g46905_i0 | PRJNA1095825 | 49962 | 541 | 1.307692 | 7.07461372 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 994 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g46905 | i0 | 99.815 | 51.9907578558226 | 541 | 1 | 100 | 0 | 1 | 541 | 1147 | 607 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 28127 | 994 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 1476487 | 1476487 | PRJNA1095825_P_NODE_93362_length_393_cov_1.443750_g90299_i0 | PRJNA1095825 | 93362 | 393 | 1.44375 | 5.6739375 | Bilabrum cf. latius | 3115832 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|2918369601|emb|OZ237767.1| | 3115832 | g90299 | i0 | 100 | 0.0737913486005089 | 29 | 0 | 7 | 0 | 114 | 142 | 291350 | 291322 | Bilabrum cf. latius genome assembly, chromosome: 33 | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Bilabrum | Bilabrum cf. latius | ||||
| 5303826 | 5303826 | PRJNA1095825_P_NODE_267145_length_246_cov_0.890173_g264082_i0 | PRJNA1095825 | 267145 | 246 | 0.890173 | 2.18982558 | Halamphora calidilacuna | 2133758 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.21e-69 | NTclustered | gi|1735236539|ref|NC_044464.1| | 2133758 | g264082 | i0 | 89.189 | 10.1707317073171 | 222 | 22 | 90 | 2 | 1 | 221 | 49984 | 49764 | Halamphora calidilacuna chloroplast, complete genome | blastn | 2502 | 276 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Amphipleuraceae | Halamphora | Halamphora calidilacuna | ||
| 6577899 | 6577899 | PRJNA1095825_P_NODE_161126_length_307_cov_1.641026_g158063_i0 | PRJNA1095825 | 161126 | 307 | 1.641026 | 5.03794982 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.3e-157 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g158063 | i0 | 100 | 101.247557003257 | 307 | 0 | 100 | 0 | 1 | 307 | 518 | 824 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 31083 | 568 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6579707 | 6579707 | PRJNA1095825_P_NODE_77686_length_429_cov_3.432584_g74623_i0 | PRJNA1095825 | 77686 | 429 | 3.432584 | 14.72578536 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 763 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g74623 | i0 | 98.834 | 51.5058275058275 | 429 | 4 | 99 | 1 | 2 | 429 | 450 | 22 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 22096 | 763 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7852340 | 7852340 | PRJNA1095825_P_NODE_113227_length_359_cov_2.132867_g110164_i0 | PRJNA1095825 | 113227 | 359 | 2.132867 | 7.65699253 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.79e-169 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g110164 | i0 | 97.207 | 62.3732590529248 | 358 | 10 | 99 | 0 | 1 | 358 | 22 | 379 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 22392 | 606 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9128003 | 9128003 | PRJNA1095825_P_NODE_205408_length_273_cov_1.005000_g202345_i0 | PRJNA1095825 | 205408 | 273 | 1.005 | 2.74365 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.6099999999999996e-133 | NTclustered | gi|347439301|gb|JN111999.1| | 151077 | g202345 | i0 | 98.901 | 13.2747252747253 | 273 | 3 | 100 | 0 | 1 | 273 | 516 | 244 | Chilodonella uncinata strain USA_WH actin gene, partial cds; macronuclear | blastn | 3624 | 488 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9129072 | 9129072 | PRJNA1095825_P_NODE_42948_length_588_cov_3.246602_g39902_i0 | PRJNA1095825 | 42948 | 588 | 3.246602 | 19.09001976 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1003 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g39902 | i0 | 97.449 | 34.687074829932 | 588 | 15 | 100 | 0 | 1 | 588 | 343 | 930 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 20396 | 1003 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10403868 | 10403868 | PRJNA1095825_P_NODE_228429_length_256_cov_1.617486_g225366_i0 | PRJNA1095825 | 228429 | 256 | 1.617486 | 4.14076416 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.67e-86 | NTclustered | gi|110645006|gb|DQ665938.1| | 151077 | g225366 | i0 | 92.275 | 7.8828125 | 233 | 18 | 91 | 0 | 1 | 233 | 563 | 795 | Chilodonella uncinata actin gene, partial cds; macronuclear | blastn | 2018 | 331 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12498157 | 12498157 | PRJNA1095825_P_NODE_122070_length_348_cov_0.974545_g119007_i0 | PRJNA1095825 | 122070 | 348 | 0.974545 | 3.3914166 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 590 | 5.649999999999998e-164 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g119007 | i0 | 97.399 | 7.70977011494253 | 346 | 9 | 99 | 0 | 1 | 346 | 463 | 808 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2683 | 590 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 15503107 | 15503107 | PRJNA1095825_P_NODE_215933_length_265_cov_1.484375_g212870_i0 | PRJNA1095825 | 215933 | 265 | 1.484375 | 3.93359375 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 4.3299999999999986e-134 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g212870 | i0 | 100 | 98.0981132075472 | 265 | 0 | 100 | 0 | 1 | 265 | 1536 | 1800 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 25996 | 490 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 16777433 | 16777433 | PRJNA1095825_P_NODE_205694_length_272_cov_1.829146_g202631_i0 | PRJNA1095825 | 205694 | 272 | 1.829146 | 4.97527712 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.49e-4 | NTclustered | gi|813220221|ref|XM_012356098.1| | 695850 | g202631 | i0 | 97.143 | 0.128676470588235 | 35 | 1 | 13 | 0 | 59 | 93 | 171 | 137 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 18051844 | 18051844 | PRJNA1095825_P_NODE_187555_length_285_cov_2.066038_g184492_i0 | PRJNA1095825 | 187555 | 285 | 2.066038 | 5.8882083 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|1620111922|ref|XM_028670266.1| | 5849 | g184492 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 0 | 179 | 206 | 392 | 419 | Plasmodium gallinaceum glutamate dehydrogenase, putative (GDH3), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 20601398 | 20601398 | PRJNA1095825_P_NODE_200737_length_276_cov_1.339901_g197674_i0 | PRJNA1095825 | 200737 | 276 | 1.339901 | 3.69812676 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.62e-138 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g197674 | i0 | 99.638 | 89.8333333333333 | 276 | 1 | 100 | 0 | 1 | 276 | 776 | 501 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 24794 | 505 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 21878246 | 21878246 | PRJNA1095825_P_NODE_50618_length_537_cov_1.327586_g47561_i0 | PRJNA1095825 | 50618 | 537 | 1.327586 | 7.12913682 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 6.6300000000000006e-21 | NTclustered | gi|160358922|gb|EU252544.1| | 88456 | g47561 | i0 | 79.191 | 16.9478584729981 | 173 | 31 | 32 | 4 | 60 | 232 | 1507 | 1674 | Cyclospora cayetanensis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 9101 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 23152517 | 23152517 | PRJNA1095825_P_NODE_194419_length_280_cov_1.985507_g191356_i0 | PRJNA1095825 | 194419 | 280 | 1.985507 | 5.5594196 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.8799999999999993e-106 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g191356 | i0 | 97.034 | 43.7607142857143 | 236 | 7 | 84 | 0 | 45 | 280 | 1205 | 970 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 12253 | 398 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23153754 | 23153754 | PRJNA1095825_P_NODE_56239_length_507_cov_3.366359_g53180_i0 | PRJNA1095825 | 56239 | 507 | 3.366359 | 17.06744013 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 815 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g53180 | i0 | 95.661 | 59.8737672583826 | 507 | 22 | 100 | 0 | 1 | 507 | 16 | 522 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30356 | 815 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;