contig_metadata
15 rows where bioproject = "PRJNA1009807" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3551991 | 3551991 | PRJNA1009807_S_NODE_663_length_359_cov_44.078125_g635_i0 | PRJNA1009807 | 663 | 359 | 44.078125 | 158.24046875 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 647 | 0 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g635 | i0 | 99.438 | 99.1810584958217 | 356 | 2 | 99 | 0 | 4 | 359 | 1537 | 1182 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 35606 | 647 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5257749 | 5257749 | PRJNA1009807_S_NODE_825_length_326_cov_109.466899_g797_i0 | PRJNA1009807 | 825 | 326 | 109.466899 | 356.86209074 | uncultured ciliate | 187299 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 1.9299999999999992e-148 | NTclustered | gi|221185865|gb|FJ577812.1| | 187299 | g797 | i0 | 96.615 | 85.6134969325153 | 325 | 10 | 99 | 1 | 1 | 325 | 498 | 821 | Uncultured ciliate clone Ivry08 18S ribosomal RNA gene, partial sequence | blastn | 27910 | 538 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 7378970 | 7378970 | PRJNA1009807_S_NODE_3386_length_176_cov_9.065693_g3358_i0 | PRJNA1009807 | 3386 | 176 | 9.065693 | 15.95561968 | Uronychia | 5955 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 4.98e-52 | NTclustered | gi|342161097|gb|JF694062.1| | 438879 | g3358 | i0 | 89.535 | 98.3068181818182 | 172 | 16 | 98 | 2 | 2 | 173 | 915 | 746 | Uronychia setigera voucher JJM2010032103 28S ribosomal RNA gene, partial sequence | blastn | 17302 | 217 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Uronychiidae | Uronychia | Uronychia setigera | ||
| 7807389 | 7807389 | PRJNA1009807_S_NODE_67_length_879_cov_56.473810_g52_i0 | PRJNA1009807 | 67 | 879 | 56.47381 | 496.4047899 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 1040 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g52 | i0 | 94.643 | 44.3686006825939 | 672 | 34 | 76 | 2 | 208 | 878 | 1 | 671 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 39000 | 1040 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8654533 | 8654533 | PRJNA1009807_S_NODE_2387_length_203_cov_53.762195_g2359_i0 | PRJNA1009807 | 2387 | 203 | 53.762195 | 109.13725585 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.2e-98 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2359 | i0 | 100 | 100.413793103448 | 201 | 0 | 99 | 0 | 3 | 203 | 946 | 1146 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 20384 | 372 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11204709 | 11204709 | PRJNA1009807_S_NODE_409_length_442_cov_106.121588_g381_i0 | PRJNA1009807 | 409 | 442 | 106.121588 | 469.05741896 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 791 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g381 | i0 | 99.539 | 84.89592760181 | 434 | 2 | 98 | 0 | 9 | 442 | 1928 | 1495 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 37524 | 791 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11204710 | 11204710 | PRJNA1009807_S_NODE_4149_length_162_cov_123.634146_g4121_i0 | PRJNA1009807 | 4149 | 162 | 123.634146 | 200.28731652 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|347439265|gb|JN111978.1| | 151077 | g4121 | i0 | 100 | 101.543209876543 | 162 | 0 | 100 | 0 | 1 | 162 | 1040 | 879 | Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 16450 | 300 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11633393 | 11633393 | PRJNA1009807_S_NODE_1210_length_275_cov_23.720339_g1182_i0 | PRJNA1009807 | 1210 | 275 | 23.720339 | 65.23093225 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 9.709999999999999e-136 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g1182 | i0 | 99.27 | 100.330909090909 | 274 | 2 | 99 | 0 | 2 | 275 | 921 | 648 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 27591 | 496 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 11633426 | 11633426 | PRJNA1009807_S_NODE_450_length_424_cov_50.179221_g422_i0 | PRJNA1009807 | 450 | 424 | 50.179221 | 212.75989704 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g422 | i0 | 96.226 | 71.5919811320755 | 424 | 16 | 100 | 0 | 1 | 424 | 2330 | 1907 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 30355 | 695 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 12480210 | 12480210 | PRJNA1009807_S_NODE_2330_length_205_cov_90.463855_g2302_i0 | PRJNA1009807 | 2330 | 205 | 90.463855 | 185.45090275 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 3.41e-89 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2302 | i0 | 97.487 | 102.263414634146 | 199 | 5 | 97 | 0 | 1 | 199 | 2375 | 2573 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 20964 | 340 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 16303905 | 16303905 | PRJNA1009807_S_NODE_2533_length_198_cov_89.830189_g2505_i0 | PRJNA1009807 | 2533 | 198 | 89.830189 | 177.86377422 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.17e-93 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2505 | i0 | 98.99 | 100.545454545455 | 198 | 2 | 100 | 0 | 1 | 198 | 1465 | 1268 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19908 | 355 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17579242 | 17579242 | PRJNA1009807_S_NODE_2154_length_212_cov_20.075145_g2126_i0 | PRJNA1009807 | 2154 | 212 | 20.075145 | 42.5593074 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 7.529999999999998e-101 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2126 | i0 | 100 | 96.9150943396226 | 205 | 0 | 97 | 0 | 8 | 212 | 2770 | 2566 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 20546 | 379 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17579290 | 17579290 | PRJNA1009807_S_NODE_754_length_340_cov_60.245847_g726_i0 | PRJNA1009807 | 754 | 340 | 60.245847 | 204.8358798 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.3499999999999992e-43 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g726 | i0 | 97.297 | 1.76764705882353 | 111 | 3 | 33 | 0 | 1 | 111 | 2972 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 601 | 189 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25227607 | 25227607 | PRJNA1009807_S_NODE_1000_length_301_cov_80.530534_g972_i0 | PRJNA1009807 | 1000 | 301 | 80.530534 | 242.39690734 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.36e-149 | NTclustered | gi|1389430796|gb|MH341624.1| | 1654720 | g972 | i0 | 99.331 | 98.78073089701 | 299 | 2 | 99 | 0 | 3 | 301 | 354 | 56 | Chilodonella piscicola strain C.piscicola SC small subunit ribosomal RNA gene, partial sequence | blastn | 29733 | 542 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 31132567 | 31132567 | PRJNA1009807_S_NODE_4535_length_157_cov_1.042373_g4507_i0 | PRJNA1009807 | 4535 | 157 | 1.042373 | 1.63652561 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 1.21e-16 | NR | CAI2383002.1 | 5936 | g4507 | i0 | 66 | 3.82165605095541 | 50 | 17 | 95.5 | 0 | 152 | 3 | 72 | 121 | CAI2383002.1 unnamed protein product [Moneuplotes crassus] | diamond | 600 | 78.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus |
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);;