contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA594101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3690890 | 3690890 | PRJNA594101_S_NODE_45003_length_260_cov_2.074866_g44701_i0 | PRJNA594101 | 45003 | 260 | 2.074866 | 5.3946516 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|330806422|ref|XM_003291121.1| | 5786 | g44701 | i0 | 100 | 1.61153846153846 | 29 | 0 | 11 | 0 | 84 | 112 | 885 | 857 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_38600), partial mRNA | blastn | 419 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 5670927 | 5670927 | PRJNA594101_S_NODE_46805_length_255_cov_3.335165_g46503_i0 | PRJNA594101 | 46805 | 255 | 3.335165 | 8.50467075 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 176 | 1.32e-39 | NTclustered | gi|66826022|ref|XM_641274.1| | 352472 | g46503 | i0 | 86.709 | 2.15294117647059 | 158 | 21 | 62 | 0 | 83 | 240 | 200 | 43 | Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds | blastn | 549 | 176 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14595987 | 14595987 | PRJNA594101_S_NODE_34832_length_293_cov_1.209091_g34530_i0 | PRJNA594101 | 34832 | 293 | 1.209091 | 3.54263663 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 438 | 1.7799999999999999e-118 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g34530 | i0 | 93.603 | 1.01365187713311 | 297 | 14 | 100 | 3 | 1 | 293 | 317 | 22 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 297 | 438 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 15167543 | 15167543 | PRJNA594101_S_NODE_58432_length_233_cov_2.743750_g58130_i0 | PRJNA594101 | 58432 | 233 | 2.74375 | 6.3929375 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 191 | 4.23e-44 | NTclustered | gi|790953|dbj|D50338.1| | 44689 | g58130 | i0 | 86.364 | 61.175965665236 | 176 | 22 | 75 | 2 | 54 | 228 | 2872 | 2698 | Dictyostelium discoideum DNA for ribosomal protein, complete cds | blastn | 14254 | 191 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 17144673 | 17144673 | PRJNA594101_S_NODE_25434_length_336_cov_0.901141_g25132_i0 | PRJNA594101 | 25434 | 336 | 0.901141 | 3.02783376 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 63.9 | 1.46e-5 | NTclustered | gi|330797548|ref|XM_003286774.1| | 5786 | g25132 | i0 | 90 | 30.9285714285714 | 50 | 3 | 15 | 2 | 208 | 256 | 564 | 612 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_97523), partial mRNA | blastn | 10392 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18418982 | 18418982 | PRJNA594101_S_NODE_40375_length_274_cov_1.149254_g40073_i0 | PRJNA594101 | 40375 | 274 | 1.149254 | 3.14895596 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|150979571|gb|EF421400.1| | 5759 | g40073 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 5 | 32 | 75 | 102 | Entamoeba histolytica strain 1309-DS6 tRNA array unit STR S(TGA)-D type 14SD genomic sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 19693380 | 19693380 | PRJNA594101_S_NODE_1976_length_1090_cov_3.731563_g1797_i0 | PRJNA594101 | 1976 | 1090 | 3.731563 | 40.6740367 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 58.4 | 0.002 | NTclustered | gi|4249354|gb|M38038.1|SLMPROP1 | 5791 | g1797 | i0 | 100 | 0.055045871559633 | 31 | 0 | 3 | 0 | 163 | 193 | 740 | 710 | Physarum polycephalum profilin P (proP) gene, complete cds | blastn | 60 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 19693480 | 19693480 | PRJNA594101_S_NODE_3336_length_869_cov_1.856784_g3094_i0 | PRJNA594101 | 3336 | 869 | 1.856784 | 16.13545296 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 503 | 2.01e-137 | NTclustered | gi|330842692|ref|XM_003293259.1| | 5786 | g3094 | i0 | 77.376 | 13.662830840046 | 884 | 176 | 100 | 22 | 1 | 869 | 2298 | 1424 | Dictyostelium purpureum elongation factor 2 (DICPUDRAFT_58424), mRNA | blastn | 11873 | 503 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 22244169 | 22244169 | PRJNA594101_S_NODE_22898_length_352_cov_1.655914_g22596_i0 | PRJNA594101 | 22898 | 352 | 1.655914 | 5.82881728 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|330845914|ref|XM_003294761.1| | 5786 | g22596 | i0 | 100 | 0.0795454545454545 | 28 | 0 | 8 | 0 | 227 | 254 | 3290 | 3263 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_159873), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23519475 | 23519475 | PRJNA594101_S_NODE_36319_length_287_cov_2.443925_g36017_i0 | PRJNA594101 | 36319 | 287 | 2.443925 | 7.01406475 | Pellita digitata | 1485084 | Discosea | other_Eukaryota | 274 | 5.199999999999998e-69 | NTclustered | gi|608606230|gb|KF705037.1| | 1485084 | g36017 | i0 | 88.646 | 60.9442508710801 | 229 | 21 | 79 | 4 | 60 | 287 | 1295 | 1071 | Pellita digitata clone 2 18S ribosomal RNA gene, partial sequence | blastn | 17491 | 274 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Pellitidae | Pellita | Pellita digitata | |||
| 24793136 | 24793136 | PRJNA594101_S_NODE_20420_length_371_cov_1.788591_g20118_i0 | PRJNA594101 | 20420 | 371 | 1.788591 | 6.63567261 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 287 | 8.88e-73 | NTclustered | gi|330818907|ref|XM_003291484.1| | 5786 | g20118 | i0 | 80.978 | 13.5660377358491 | 368 | 64 | 98 | 5 | 3 | 367 | 51 | 415 | Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA | blastn | 5033 | 287 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;