contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1214993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1605038 | 1605038 | PRJNA1214993_P_NODE_17282_length_269_cov_1.984694_g17096_i0 | PRJNA1214993 | 17282 | 269 | 1.984694 | 5.33882686 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 353 | 6.03e-93 | NTclustered | gi|66804872|ref|XM_631077.1| | 352472 | g17096 | i0 | 90.335 | 98.1672862453532 | 269 | 26 | 100 | 0 | 1 | 269 | 936 | 668 | Dictyostelium discoideum AX4 hypothetical protein (act1) mRNA, complete cds | blastn | 26407 | 353 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5433497 | 5433497 | PRJNA1214993_P_NODE_22245_length_248_cov_0.891429_g22059_i0 | PRJNA1214993 | 22245 | 248 | 0.891429 | 2.21074392 | uncultured Soliformovum | 2510342 | Evosea | other_Eukaryota | 374 | 4.2099999999999995e-99 | NTclustered | gi|1564356923|gb|MK443523.1| | 2510342 | g22059 | i0 | 93.976 | 1.31854838709677 | 249 | 12 | 100 | 2 | 1 | 248 | 297 | 51 | Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 327 | 374 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | uncultured Soliformovum | |||
| 5433514 | 5433514 | PRJNA1214993_P_NODE_24345_length_245_cov_0.895349_g24159_i0 | PRJNA1214993 | 24345 | 245 | 0.895349 | 2.19360505 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 224 | 4.43e-54 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g24159 | i0 | 83.936 | 7.70612244897959 | 249 | 25 | 100 | 13 | 1 | 245 | 7092 | 7329 | Mucilago crustacea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1888 | 224 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 9258220 | 9258220 | PRJNA1214993_P_NODE_1288_length_901_cov_3.509662_g1143_i0 | PRJNA1214993 | 1288 | 901 | 3.509662 | 31.62205462 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 562 | 3.4e-155 | NTclustered | gi|167393182|ref|XM_001740406.1| | 370354 | g1143 | i0 | 78.58 | 68.8179800221976 | 873 | 171 | 96 | 13 | 1 | 868 | 862 | 1 | Entamoeba dispar SAW760 elongation factor 1-alpha (EDI_196620), partial mRNA | blastn | 62005 | 562 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 9258277 | 9258277 | PRJNA1214993_P_NODE_21648_length_249_cov_0.886364_g21462_i0 | PRJNA1214993 | 21648 | 249 | 0.886364 | 2.20704636 | Badhamia melanospora | 1346252 | Evosea | other_Eukaryota | 230 | 9.699999999999995e-56 | NTclustered | gi|2440757457|gb|OP616492.1| | 1346252 | g21462 | i0 | 83.468 | 90.8835341365462 | 248 | 39 | 99 | 2 | 3 | 249 | 284 | 38 | Badhamia melanospora voucher LE266197 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 22630 | 230 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Badhamia | Badhamia melanospora | ||
| 10534249 | 10534249 | PRJNA1214993_P_NODE_5529_length_455_cov_1.863874_g5344_i0 | PRJNA1214993 | 5529 | 455 | 1.863874 | 8.4806267 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 689 | 0 | NTclustered | gi|146448863|gb|EF513199.1| | 435424 | g5344 | i0 | 94.989 | 92.3230769230769 | 439 | 22 | 96 | 0 | 17 | 455 | 303 | 741 | Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds | blastn | 42007 | 689 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 16907407 | 16907407 | PRJNA1214993_P_NODE_13054_length_306_cov_0.892704_g12868_i0 | PRJNA1214993 | 13054 | 306 | 0.892704 | 2.73167424 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 182 | 3.49e-41 | NTclustered | gi|831779727|ref|XM_012900357.1| | 1410327 | g12868 | i0 | 86.391 | 44.437908496732 | 169 | 19 | 55 | 4 | 138 | 304 | 230 | 64 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 13598 | 182 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 16907430 | 16907430 | PRJNA1214993_P_NODE_15994_length_279_cov_1.495146_g15808_i0 | PRJNA1214993 | 15994 | 279 | 1.495146 | 4.17145734 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 187 | 6.749999999999998e-43 | NTclustered | gi|330792605|ref|XM_003284331.1| | 5786 | g15808 | i0 | 79.545 | 51.5448028673835 | 264 | 52 | 94 | 2 | 1 | 263 | 893 | 631 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_52874), mRNA | blastn | 14381 | 187 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23282593 | 23282593 | PRJNA1214993_P_NODE_999_length_993_cov_2.518478_g875_i0 | PRJNA1214993 | 999 | 993 | 2.518478 | 25.00848654 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 1223 | 0 | NTclustered | gi|330799499|ref|XM_003287734.1| | 5786 | g875 | i0 | 88.979 | 98.1792547834844 | 989 | 109 | 99 | 0 | 5 | 993 | 1145 | 157 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72359), partial mRNA | blastn | 97492 | 1223 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 25271563 | 25271563 | PRJNA1214993_P_NODE_4820_length_486_cov_1.886199_g4635_i0 | PRJNA1214993 | 4820 | 486 | 1.886199 | 9.16692714 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 278 | 7.18e-70 | NTclustered | gi|470260760|ref|XM_004360149.1| | 261658 | g4635 | i0 | 79.353 | 54.7057613168724 | 402 | 77 | 82 | 5 | 4 | 403 | 962 | 565 | Cavenderia fasciculata elongation factor 1 alpha (efaAI), partial mRNA | blastn | 26587 | 279 | 0.996415770609319 | 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);;