contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2834259 | 2834259 | PRJNA1132896_P_NODE_1283_length_461_cov_2.649485_g1192_i0 | PRJNA1132896 | 1283 | 461 | 2.649485 | 12.21412585 | Badhamia melanospora | 1346252 | Evosea | other_Eukaryota | 429 | 1.7699999999999996e-115 | NTclustered | gi|2440757457|gb|OP616492.1| | 1346252 | g1192 | i0 | 83.589 | 96.9197396963124 | 457 | 73 | 99 | 2 | 3 | 458 | 469 | 14 | Badhamia melanospora voucher LE266197 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 44680 | 429 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Badhamia | Badhamia melanospora | ||
| 5386814 | 5386814 | PRJNA1132896_P_NODE_2545_length_345_cov_1.529412_g2454_i0 | PRJNA1132896 | 2545 | 345 | 1.529412 | 5.2764714 | Diderma niveum | 372584 | Evosea | other_Eukaryota | 257 | 6.45e-64 | NTclustered | gi|381140154|emb|HE655061.1| | 372584 | g2454 | i0 | 80.912 | 60.4492753623188 | 351 | 46 | 100 | 17 | 1 | 345 | 3372 | 3037 | Diderma niveum partial 28S rRNA gene, isolate Uk-K79 | blastn | 20855 | 257 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma niveum | ||
| 6661526 | 6661526 | PRJNA1132896_P_NODE_7346_length_249_cov_2.187500_g7255_i0 | PRJNA1132896 | 7346 | 249 | 2.1875 | 5.446875 | Diderma europaeum | 2656919 | Evosea | other_Eukaryota | 399 | 6.989999999999999e-107 | NTclustered | gi|118577471|gb|DQ903677.1| | 2656919 | g7255 | i0 | 95.582 | 100.076305220884 | 249 | 11 | 100 | 0 | 1 | 249 | 947 | 1195 | Diderma globosum var. europaeum voucher AMFD110 small subunit ribosomal RNA gene, partial sequence | blastn | 24919 | 399 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma europaeum | ||
| 10487195 | 10487195 | PRJNA1132896_P_NODE_9169_length_244_cov_0.900585_g9078_i0 | PRJNA1132896 | 9169 | 244 | 0.900585 | 2.1974274 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 195 | 3.46e-45 | NTclustered | gi|326632058|gb|HQ849399.1| | 5791 | g9078 | i0 | 83.178 | 3.70901639344262 | 214 | 34 | 87 | 2 | 32 | 244 | 2058 | 2270 | Physarum polycephalum strain M3CVIII 23S large subunit ribosomal RNA, complete sequence; mitochondrial | blastn | 905 | 195 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 12510500 | 12510500 | PRJNA1132896_P_NODE_490_length_749_cov_1.326923_g404_i0 | PRJNA1132896 | 490 | 749 | 1.326923 | 9.93865327 | Didymium | 5792 | Evosea | other_Eukaryota | 433 | 2.2899999999999996e-116 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g404 | i0 | 85.45 | 6.07076101468625 | 433 | 44 | 58 | 11 | 1 | 431 | 1769 | 2184 | D.iridis LSU rRNA gene | blastn | 4547 | 433 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 14312587 | 14312587 | PRJNA1132896_P_NODE_812_length_571_cov_4.819277_g721_i0 | PRJNA1132896 | 812 | 571 | 4.819277 | 27.51807167 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 254 | 1.44e-62 | NTclustered | gi|330799393|ref|XM_003287682.1| | 5786 | g721 | i0 | 80.851 | 6.87565674255692 | 329 | 58 | 57 | 4 | 14 | 341 | 515 | 191 | Dictyostelium purpureum 40S ribosomal protein S2 (DICPUDRAFT_32959), partial mRNA | blastn | 3926 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 19409553 | 19409553 | PRJNA1132896_P_NODE_756_length_589_cov_4.618217_g666_i0 | PRJNA1132896 | 756 | 589 | 4.618217 | 27.20129813 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 104 | 1.58e-17 | NTclustered | gi|330790854|ref|XM_003283463.1| | 5786 | g666 | i0 | 73.759 | 0.721561969439728 | 282 | 66 | 48 | 6 | 108 | 388 | 118 | 392 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93471), partial mRNA | blastn | 425 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23235947 | 23235947 | PRJNA1132896_P_NODE_59_length_1843_cov_3.140113_g45_i0 | PRJNA1132896 | 59 | 1843 | 3.140113 | 57.87228259 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 966 | 0 | NTclustered | gi|330818764|ref|XM_003291461.1| | 5786 | g45 | i0 | 77.348 | 84.1150298426479 | 1682 | 350 | 91 | 27 | 159 | 1826 | 1677 | 13 | Dictyostelium purpureum heat shock protein (DICPUDRAFT_49867), partial mRNA | blastn | 155024 | 966 | 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);;