contig_metadata
14 rows where bioproject = "PRJNA927284" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3452720 | 3452720 | PRJNA927284_P_NODE_1663_length_561_cov_2.827068_g1492_i0 | PRJNA927284 | 1663 | 561 | 2.827068 | 15.85985148 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 904 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g1492 | i0 | 95.722 | 81.8360071301248 | 561 | 24 | 100 | 0 | 1 | 561 | 2049 | 1489 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 45910 | 904 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 7630682 | 7630682 | PRJNA927284_P_NODE_5426_length_241_cov_2.433962_g5219_i0 | PRJNA927284 | 5426 | 241 | 2.433962 | 5.86584842 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.5299999999999999e-68 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5219 | i0 | 97.484 | 2.81327800829876 | 159 | 4 | 66 | 0 | 1 | 159 | 2924 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 678 | 272 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8905361 | 8905361 | PRJNA927284_P_NODE_6247_length_214_cov_1.800000_g6040_i0 | PRJNA927284 | 6247 | 214 | 1.8 | 3.852 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.66e-92 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6040 | i0 | 96.262 | 100 | 214 | 8 | 100 | 0 | 1 | 214 | 2552 | 2765 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 21400 | 351 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10181231 | 10181231 | PRJNA927284_P_NODE_5628_length_233_cov_2.323529_g5421_i0 | PRJNA927284 | 5628 | 233 | 2.323529 | 5.41382257 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.039999999999998e-47 | NTclustered | gi|400365273|gb|JQ684658.1| | 5833 | g5421 | i0 | 88.166 | 75.3948497854077 | 169 | 18 | 72 | 2 | 1 | 168 | 2567 | 2734 | Plasmodium falciparum isolate LF2 28S ribosomal RNA gene, partial sequence | blastn | 17567 | 202 | 0.99009900990099 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 12381059 | 12381059 | PRJNA927284_P_NODE_8010_length_174_cov_1.634483_g7803_i0 | PRJNA927284 | 8010 | 174 | 1.634483 | 2.84400042 | Blastocystis sp. | 46767 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.44e-12 | NTclustered | gi|2169214681|gb|OL981936.1| | 46767 | g7803 | i0 | 94.545 | 1.39655172413793 | 55 | 3 | 32 | 0 | 5 | 59 | 1 | 55 | Blastocystis sp. isolate JT5-6 small subunit ribosomal RNA gene, partial sequence | blastn | 243 | 86.1 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. | |||
| 13655598 | 13655598 | PRJNA927284_P_NODE_8811_length_160_cov_1.114504_g8604_i0 | PRJNA927284 | 8811 | 160 | 1.114504 | 1.7832064 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.5799999999999998e-74 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g8604 | i0 | 99.375 | 1 | 160 | 1 | 100 | 0 | 1 | 160 | 21 | 180 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 160 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14929795 | 14929795 | PRJNA927284_P_NODE_5832_length_226_cov_2.786802_g5625_i0 | PRJNA927284 | 5832 | 226 | 2.786802 | 6.29817252 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 3.73e-109 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g5625 | i0 | 99.115 | 80.3628318584071 | 226 | 2 | 100 | 0 | 1 | 226 | 671 | 896 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 18162 | 407 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 17830057 | 17830057 | PRJNA927284_P_NODE_1694_length_555_cov_2.602662_g1522_i0 | PRJNA927284 | 1694 | 555 | 2.602662 | 14.4447741 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 782 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1522 | i0 | 92.072 | 74.4486486486486 | 555 | 44 | 100 | 0 | 1 | 555 | 13 | 567 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 41319 | 782 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20028470 | 20028470 | PRJNA927284_P_NODE_3236_length_361_cov_8.894578_g3031_i0 | PRJNA927284 | 3236 | 361 | 8.894578 | 32.10942658 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 1.42e-80 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3031 | i0 | 83.014 | 53.8116343490305 | 365 | 43 | 100 | 13 | 1 | 361 | 4008 | 3659 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19426 | 313 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 25127967 | 25127967 | PRJNA927284_P_NODE_2120_length_482_cov_8.108168_g1930_i0 | PRJNA927284 | 2120 | 482 | 8.108168 | 39.08136976 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 9.88e-19 | NTclustered | gi|1162436928|ref|XR_002273099.1| | 36329 | g1930 | i0 | 76.699 | 14.2385892116183 | 206 | 40 | 42 | 7 | 1 | 202 | 3493 | 3694 | Plasmodium falciparum 3D7 28S ribosomal RNA (PF3D7_0112700), rRNA | blastn | 6863 | 108 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 25127983 | 25127983 | PRJNA927284_P_NODE_4580_length_277_cov_15.891129_g4373_i0 | PRJNA927284 | 4580 | 277 | 15.891129 | 44.01842733 | Cercomonadida sp. C15_1A03 | 595691 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 5.03e-64 | NTclustered | gi|223047882|gb|FJ032646.1| | 595691 | g4373 | i0 | 84.116 | 46.2924187725632 | 277 | 32 | 100 | 4 | 1 | 277 | 1961 | 2225 | Cercomonadida sp. C15_1A03 28S ribosomal RNA gene, partial sequence | blastn | 12823 | 257 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadida sp. C15_1A03 | |||||
| 25479160 | 25479160 | PRJNA927284_P_NODE_3680_length_330_cov_2.362126_g3475_i0 | PRJNA927284 | 3680 | 330 | 2.362126 | 7.7950158 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 9.17e-142 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3475 | i0 | 94.848 | 36.1787878787879 | 330 | 17 | 100 | 0 | 1 | 330 | 13 | 342 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 11939 | 516 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 32047905 | 32047905 | PRJNA927284_P_NODE_2658_length_414_cov_4.394805_g2459_i0 | PRJNA927284 | 2658 | 414 | 4.394805 | 18.1944927 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 1.4e-7 | NR | CAE8630692.1 | 89957 | g2459 | i0 | 41 | 0.565217391304348 | 78 | 45 | 55.8 | 1 | 373 | 143 | 209 | 286 | CAE8630692.1 unnamed protein product, partial [Polarella glacialis] | diamond | 234 | 60.5 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 32276747 | 32276747 | PRJNA927284_P_NODE_5818_length_227_cov_1.732323_g5611_i0 | PRJNA927284 | 5818 | 227 | 1.732323 | 3.93237321 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 1.23e-18 | NR | XP_012336428.1 | 5857 | g5611 | i0 | 59.3 | 12.8986784140969 | 81 | 25 | 96.5 | 1 | 222 | 4 | 29 | 109 | XP_012336428.1 uncharacterized protein AK88_03388 [Plasmodium fragile] | diamond | 2928 | 86.3 | 0.995365005793743 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile |
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);;