contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1010662" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1429702 | 1429702 | PRJNA1010662_P_NODE_4702_length_245_cov_9.285714_g4643_i0 | PRJNA1010662 | 4702 | 245 | 9.285714 | 22.7499993 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 333 | 7.049999999999999e-87 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g4643 | i0 | 94.495 | 10.065306122449 | 218 | 8 | 89 | 4 | 3 | 219 | 218 | 4 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 2466 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 2705085 | 2705085 | PRJNA1010662_P_NODE_1303_length_449_cov_2.095000_g1244_i0 | PRJNA1010662 | 1303 | 449 | 2.095 | 9.40655 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 414 | 4.81e-111 | NTclustered | gi|167859717|gb|EU273438.1| | 1346289 | g1244 | i0 | 83.37 | 96.7483296213808 | 451 | 71 | 100 | 3 | 1 | 449 | 782 | 334 | Telaepolella tubasferens clone 2 beta-tubulin gene, partial cds | blastn | 43440 | 414 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 3981360 | 3981360 | PRJNA1010662_P_NODE_6084_length_222_cov_1.739884_g6025_i0 | PRJNA1010662 | 6084 | 222 | 1.739884 | 3.86254248 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 110 | 1.15e-19 | NTclustered | gi|1160571044|ref|XM_020575016.1| | 670386 | g6025 | i0 | 83.193 | 1.01351351351351 | 119 | 20 | 54 | 0 | 5 | 123 | 317 | 435 | Polysphondylium pallidum PN500 40S ribosomal protein S14 (rps14), partial mRNA | blastn | 225 | 110 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 3981379 | 3981379 | PRJNA1010662_P_NODE_7364_length_207_cov_1.316456_g7305_i0 | PRJNA1010662 | 7364 | 207 | 1.316456 | 2.72506392 | Fuligo muscorum | 947840 | Evosea | other_Eukaryota | 145 | 2.9e-30 | NTclustered | gi|2574169361|gb|OP630995.1| | 947840 | g7305 | i0 | 79.803 | 9.26086956521739 | 203 | 37 | 97 | 4 | 6 | 206 | 574 | 374 | Fuligo muscorum strain MM46916 alpha-tubulin (aTUB) gene, partial cds | blastn | 1917 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo muscorum | ||
| 9082370 | 9082370 | PRJNA1010662_P_NODE_17068_length_159_cov_6.136364_g17009_i0 | PRJNA1010662 | 17068 | 159 | 6.136364 | 9.75681876 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 294 | 1.98e-75 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g17009 | i0 | 100 | 17.0377358490566 | 159 | 0 | 100 | 0 | 1 | 159 | 259 | 417 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 2709 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 9082496 | 9082496 | PRJNA1010662_S_NODE_4068_length_170_cov_22.834646_g4023_i0 | PRJNA1010662 | 4068 | 170 | 22.834646 | 38.8188982 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 296 | 5.95e-76 | NTclustered | gi|380350146|emb|HE605256.1| | 590481 | g4023 | i0 | 99.387 | 32.3529411764706 | 163 | 1 | 96 | 0 | 8 | 170 | 246 | 408 | Uncultured Amoebozoa genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, clone M6D-6 | blastn | 5500 | 296 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 10357986 | 10357986 | PRJNA1010662_P_NODE_15569_length_164_cov_0.895652_g15510_i0 | PRJNA1010662 | 15569 | 164 | 0.895652 | 1.46886928 | Mastigella eilhardi | 1580584 | Evosea | other_Eukaryota | 224 | 2.74e-54 | NTclustered | gi|730326658|gb|KJ879559.1| | 1580584 | g15510 | i0 | 91.411 | 103.164634146341 | 163 | 14 | 99 | 0 | 1 | 163 | 181 | 343 | Mastigella eilhardi strain ATCC 50342 actin gene, partial cds | blastn | 16919 | 224 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Mastigella | Mastigella eilhardi | ||||
| 11633496 | 11633496 | PRJNA1010662_P_NODE_3030_length_296_cov_2.080972_g2971_i0 | PRJNA1010662 | 3030 | 296 | 2.080972 | 6.15967712 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 111 | 4.47e-20 | NTclustered | gi|66823576|ref|XM_640051.1| | 352472 | g2971 | i0 | 79.747 | 1.52027027027027 | 158 | 29 | 59 | 2 | 51 | 205 | 698 | 541 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0272356) mRNA, complete cds | blastn | 450 | 111 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14183585 | 14183585 | PRJNA1010662_P_NODE_5592_length_229_cov_2.416667_g5533_i0 | PRJNA1010662 | 5592 | 229 | 2.416667 | 5.53416743 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 183 | 6.939999999999998e-42 | NTclustered | gi|470265381|ref|XM_004361428.1| | 261658 | g5533 | i0 | 85.632 | 39.117903930131 | 174 | 25 | 76 | 0 | 53 | 226 | 78 | 251 | Cavenderia fasciculata heat shock protein (hspB), partial mRNA | blastn | 8958 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 14183616 | 14183616 | PRJNA1010662_S_NODE_1472_length_252_cov_2.181818_g1427_i0 | PRJNA1010662 | 1472 | 252 | 2.181818 | 5.49818136 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 455 | 1.49e-123 | NTclustered | gi|365928255|gb|JN825705.1| | 590481 | g1427 | i0 | 99.209 | 26.6785714285714 | 253 | 1 | 100 | 1 | 1 | 252 | 901 | 649 | Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence | blastn | 6723 | 455 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 15029195 | 15029195 | PRJNA1010662_P_NODE_14492_length_165_cov_1.775862_g14433_i0 | PRJNA1010662 | 14492 | 165 | 1.775862 | 2.9301723 | Entamoeba | 5758 | Evosea | other_Eukaryota | 130 | 6.2e-26 | NTclustered | gi|511085582|dbj|AK420038.1| | 5759 | g14433 | i0 | 83.571 | 5.27878787878788 | 140 | 21 | 84 | 2 | 1 | 139 | 545 | 407 | Entamoeba histolytica cDNA clone: Xeh-007B17, 26S protease regulatory subunit, putative, complete cds, strain: HM-1:IMSS | blastn | 871 | 130 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 15457530 | 15457530 | PRJNA1010662_P_NODE_5613_length_229_cov_1.155556_g5554_i0 | PRJNA1010662 | 5613 | 229 | 1.155556 | 2.64622324 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 93.5 | 1.2e-14 | NTclustered | gi|330843278|ref|XM_003293538.1| | 5786 | g5554 | i0 | 91.176 | 5.5938864628821 | 68 | 6 | 30 | 0 | 1 | 68 | 1307 | 1374 | Dictyostelium purpureum ubiquinone oxidoreductase (DICPUDRAFT_158468), partial mRNA | blastn | 1281 | 93.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18853130 | 18853130 | PRJNA1010662_P_NODE_2515_length_323_cov_1.572993_g2456_i0 | PRJNA1010662 | 2515 | 323 | 1.572993 | 5.08076739 | Entamoeba | 5758 | Evosea | other_Eukaryota | 193 | 1.71e-44 | NTclustered | gi|158955|gb|M84652.1|ENHHSP70A | 5759 | g2456 | i0 | 78.738 | 19.6191950464396 | 301 | 54 | 92 | 10 | 19 | 314 | 1105 | 1400 | Entamoeba heat shock protein (Hsp70) mRNA, complete cds | blastn | 6337 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 19280400 | 19280400 | PRJNA1010662_P_NODE_14436_length_165_cov_2.517241_g14377_i0 | PRJNA1010662 | 14436 | 165 | 2.517241 | 4.15344765 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 110 | 8.07e-20 | NTclustered | gi|167079095|ref|XM_001740445.1| | 370354 | g14377 | i0 | 90.476 | 4.18181818181818 | 84 | 6 | 51 | 2 | 65 | 148 | 515 | 434 | Entamoeba dispar SAW760 RAC GTPase, putative (EDI_099270), partial mRNA | blastn | 690 | 110 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 23107144 | 23107144 | PRJNA1010662_P_NODE_10879_length_178_cov_1.976744_g10820_i0 | PRJNA1010662 | 10879 | 178 | 1.976744 | 3.51860432 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 239 | 1.08e-58 | NTclustered | gi|1914009695|gb|MT975597.1| | 313997 | g10820 | i0 | 90.96 | 99.2303370786517 | 177 | 16 | 99 | 0 | 2 | 178 | 511 | 687 | Cochliopodium minus clone 2 actin gene, partial cds | blastn | 17663 | 239 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 23107166 | 23107166 | PRJNA1010662_P_NODE_14459_length_165_cov_2.103448_g14400_i0 | PRJNA1010662 | 14459 | 165 | 2.103448 | 3.4706892 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 95.3 | 2.26e-15 | NTclustered | gi|470241167|ref|XM_004352107.1| | 261658 | g14400 | i0 | 83.838 | 0.6 | 99 | 16 | 60 | 0 | 62 | 160 | 486 | 388 | Cavenderia fasciculata 40S ribosomal protein S3 (rps3), partial mRNA | blastn | 99 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata |
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);;