contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655402 | 1655402 | PRJNA315314_S_NODE_10782_length_247_cov_1.266055_g10461_i0 | PRJNA315314 | 10782 | 247 | 1.266055 | 3.12715585 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 75 | 4.76e-9 | NTclustered | gi|1160566874|ref|XM_020581062.1| | 670386 | g10461 | i0 | 97.674 | 0.356275303643725 | 43 | 1 | 17 | 0 | 60 | 102 | 388 | 430 | Polysphondylium pallidum PN500 S60 ribosomal protein L17 (rpl17), partial mRNA | blastn | 88 | 75 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 2931371 | 2931371 | PRJNA315314_S_NODE_1683_length_599_cov_9.396491_g1417_i0 | PRJNA315314 | 1683 | 599 | 9.396491 | 56.28498109 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 795 | 0 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g1417 | i0 | 90.64 | 24.7829716193656 | 609 | 42 | 100 | 14 | 1 | 599 | 1790 | 1187 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 14845 | 795 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 4893216 | 4893216 | PRJNA315314_S_NODE_4424_length_380_cov_61.470085_g4103_i0 | PRJNA315314 | 4424 | 380 | 61.470085 | 233.586323 | Flamella | 490353 | Evosea | other_Eukaryota | 446 | 1.42e-120 | NTclustered | gi|163943979|gb|EU186023.1| | 490516 | g4103 | i0 | 99.19 | 91.9131578947368 | 247 | 2 | 81 | 0 | 1 | 247 | 767 | 1013 | Flamella balnearia 18S ribosomal RNA gene, partial sequence | blastn | 34927 | 446 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella balnearia | |||
| 6758449 | 6758449 | PRJNA315314_S_NODE_19306_length_188_cov_1.943396_g18985_i0 | PRJNA315314 | 19306 | 188 | 1.943396 | 3.65358448 | Entamoeba invadens | 33085 | Evosea | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|471206948|ref|XM_004260179.1| | 370355 | g18985 | i0 | 100 | 0.148936170212766 | 28 | 0 | 15 | 0 | 85 | 112 | 676 | 703 | Entamoeba invadens IP1 hypothetical protein (EIN_059410) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 8717818 | 8717818 | PRJNA315314_S_NODE_11907_length_235_cov_44.359223_g11586_i0 | PRJNA315314 | 11907 | 235 | 44.359223 | 104.24417405 | Flamella | 490353 | Evosea | other_Eukaryota | 429 | 8.33e-116 | NTclustered | gi|163943979|gb|EU186023.1| | 490516 | g11586 | i0 | 99.574 | 98.7659574468085 | 235 | 1 | 100 | 0 | 1 | 235 | 767 | 1001 | Flamella balnearia 18S ribosomal RNA gene, partial sequence | blastn | 23210 | 429 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella balnearia | |||
| 9993494 | 9993494 | PRJNA315314_S_NODE_3648_length_418_cov_19.334190_g3328_i0 | PRJNA315314 | 3648 | 418 | 19.33419 | 80.8169142 | Flamella | 490353 | Evosea | other_Eukaryota | 449 | 1.2199999999999999e-121 | NTclustered | gi|163943979|gb|EU186023.1| | 490516 | g3328 | i0 | 98.438 | 61.3875598086124 | 256 | 3 | 61 | 1 | 164 | 418 | 725 | 980 | Flamella balnearia 18S ribosomal RNA gene, partial sequence | blastn | 25660 | 449 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella balnearia | |||
| 11859689 | 11859689 | PRJNA315314_S_NODE_5310_length_348_cov_6.347962_g4989_i0 | PRJNA315314 | 5310 | 348 | 6.347962 | 22.09090776 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 93.5 | 1.94e-14 | NTclustered | gi|470266378|ref|XM_004361682.1| | 261658 | g4989 | i0 | 83.019 | 1.43965517241379 | 106 | 14 | 30 | 4 | 152 | 255 | 623 | 520 | Cavenderia fasciculata 40S ribosomal protein S8 (rps8), partial mRNA | blastn | 501 | 93.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 13134598 | 13134598 | PRJNA315314_S_NODE_2591_length_493_cov_6.491379_g2282_i0 | PRJNA315314 | 2591 | 493 | 6.491379 | 32.00249847 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 579 | 1.7899999999999993e-160 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g2282 | i0 | 87.767 | 4.16632860040568 | 515 | 38 | 100 | 22 | 1 | 493 | 155 | 666 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 2054 | 579 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 14409768 | 14409768 | PRJNA315314_S_NODE_24912_length_168_cov_1.625899_g24591_i0 | PRJNA315314 | 24912 | 168 | 1.625899 | 2.73151032 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 84.2 | 5e-12 | NTclustered | gi|831770523|ref|XM_012897573.1| | 1410327 | g24591 | i0 | 91.667 | 0.69047619047619 | 60 | 5 | 36 | 0 | 29 | 88 | 434 | 375 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 116 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 21467146 | 21467146 | PRJNA315314_S_NODE_4137_length_393_cov_21.851648_g3816_i0 | PRJNA315314 | 4137 | 393 | 21.851648 | 85.87697664 | Flamella | 490353 | Evosea | other_Eukaryota | 721 | 0 | NTclustered | gi|163943979|gb|EU186023.1| | 490516 | g3816 | i0 | 99.746 | 74.8702290076336 | 393 | 1 | 100 | 0 | 1 | 393 | 588 | 980 | Flamella balnearia 18S ribosomal RNA gene, partial sequence | blastn | 29424 | 721 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella balnearia | |||
| 22057142 | 22057142 | PRJNA315314_S_NODE_12938_length_226_cov_4.756345_g12617_i0 | PRJNA315314 | 12938 | 226 | 4.756345 | 10.7493397 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 165 | 2.48e-36 | NTclustered | gi|354683898|gb|JN048925.1| | 361077 | g12617 | i0 | 81.281 | 7.95132743362832 | 203 | 38 | 90 | 0 | 9 | 211 | 1165 | 963 | Tieghemostelium lacteum cell division cycle protein 48 gene, complete cds | blastn | 1797 | 165 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 22057388 | 22057388 | PRJNA315314_S_NODE_27178_length_161_cov_7.795455_g26857_i0 | PRJNA315314 | 27178 | 161 | 7.795455 | 12.55068255 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 97.1 | 6.09e-16 | NTclustered | gi|19911164|dbj|AB066364.1| | 108607 | g26857 | i0 | 98.182 | 8.6583850931677 | 55 | 1 | 34 | 0 | 1 | 55 | 1647 | 1701 | Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2 | blastn | 1394 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 24607117 | 24607117 | PRJNA315314_S_NODE_5080_length_356_cov_6.633028_g4759_i0 | PRJNA315314 | 5080 | 356 | 6.633028 | 23.61357968 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 283 | 1.1e-71 | NTclustered | gi|1160553732|ref|XM_020572691.1| | 670386 | g4759 | i0 | 81.232 | 98.6179775280899 | 357 | 61 | 99 | 6 | 1 | 354 | 718 | 1071 | Polysphondylium pallidum PN500 elongation factor 1 alpha (efaAI), partial mRNA | blastn | 35108 | 283 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;