contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2571050 | 2571050 | PRJEB14664_P_NODE_15703_length_177_cov_1.690141_g15573_i0 | PRJEB14664 | 15703 | 177 | 1.690141 | 2.99154957 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 93.5 | 8.81e-15 | NTclustered | gi|470266378|ref|XM_004361682.1| | 261658 | g15573 | i0 | 83.019 | 2.83050847457627 | 106 | 14 | 59 | 4 | 15 | 118 | 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 | ||
| 5123638 | 5123638 | PRJEB14664_P_NODE_2485_length_580_cov_2.715596_g2371_i0 | PRJEB14664 | 2485 | 580 | 2.715596 | 15.7504568 | Lamproderma scintillans | 1115720 | Evosea | other_Eukaryota | 414 | 6.34e-111 | NTclustered | gi|2306687667|gb|MZ234283.1| | 1115720 | g2371 | i0 | 80.251 | 84.2103448275862 | 557 | 104 | 96 | 6 | 27 | 580 | 724 | 171 | Lamproderma scintillans voucher LE265994 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 48842 | 414 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans | ||
| 5123664 | 5123664 | PRJEB14664_P_NODE_465_length_1298_cov_4.947743_g419_i0 | PRJEB14664 | 465 | 1298 | 4.947743 | 64.22170414 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 1840 | 0 | NTclustered | gi|146448863|gb|EF513199.1| | 435424 | g419 | i0 | 94.196 | 64.1802773497689 | 1206 | 70 | 93 | 0 | 1 | 1206 | 3 | 1208 | Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds | blastn | 83306 | 1840 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 6399460 | 6399460 | PRJEB14664_P_NODE_9846_length_244_cov_3.019139_g9716_i0 | PRJEB14664 | 9846 | 244 | 3.019139 | 7.36669916 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 148 | 2.7299999999999997e-31 | NTclustered | gi|381139238|emb|HE655045.1| | 435424 | g9716 | i0 | 87.692 | 11.4877049180328 | 130 | 13 | 53 | 3 | 1 | 129 | 208 | 335 | Soliformovum irregulare partial 28S rRNA gene, strain ATCC 26826 | blastn | 2803 | 148 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 6399462 | 6399462 | PRJEB14664_P_NODE_9926_length_243_cov_1.711538_g9796_i0 | PRJEB14664 | 9926 | 243 | 1.711538 | 4.15903734 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 281 | 2.57e-71 | NTclustered | gi|167859711|gb|EU273435.1| | 1346289 | g9796 | i0 | 87.603 | 99.7283950617284 | 242 | 30 | 99 | 0 | 1 | 242 | 354 | 595 | Telaepolella tubasferens clone 1 actin gene, partial cds | blastn | 24234 | 281 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 7673455 | 7673455 | PRJEB14664_P_NODE_2907_length_532_cov_1.738431_g2385_i1 | PRJEB14664 | 2907 | 532 | 1.738431 | 9.24845292 | uncultured Soliformovum | 2510342 | Evosea | other_Eukaryota | 593 | 6.919999999999998e-165 | NTclustered | gi|1564356923|gb|MK443523.1| | 2510342 | g2385 | i1 | 95.225 | 37.6278195488722 | 377 | 15 | 71 | 2 | 157 | 532 | 425 | 51 | Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 20018 | 593 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | uncultured Soliformovum | |||
| 11499225 | 11499225 | PRJEB14664_P_NODE_17110_length_167_cov_1.515152_g16980_i0 | PRJEB14664 | 17110 | 167 | 1.515152 | 2.53030384 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 100 | 4.93e-17 | NTclustered | gi|1160572408|ref|XM_020576382.1| | 670386 | g16980 | i0 | 81.452 | 5.32934131736527 | 124 | 21 | 74 | 2 | 1 | 123 | 396 | 518 | Polysphondylium pallidum PN500 S60 ribosomal protein L10a (rpl10a), partial mRNA | blastn | 890 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 14049352 | 14049352 | PRJEB14664_P_NODE_20312_length_150_cov_1.391304_g20182_i0 | PRJEB14664 | 20312 | 150 | 1.391304 | 2.086956 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 147 | 5.45e-31 | NTclustered | gi|161220|gb|M58521.1|SLMBETA | 5791 | g20182 | i0 | 84.828 | 83.54 | 145 | 22 | 97 | 0 | 1 | 145 | 490 | 634 | P.polycephalum beta-tubulin-1 (betA) mRNA, 5' end | blastn | 12531 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 21387884 | 21387884 | PRJEB14664_P_NODE_4097_length_433_cov_1.804020_g3970_i0 | PRJEB14664 | 4097 | 433 | 1.80402 | 7.8114066 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 267 | 1.3699999999999998e-66 | NTclustered | gi|2564919|gb|AF025951.1| | 44689 | g3970 | i0 | 79.74 | 62.7413394919169 | 385 | 65 | 87 | 11 | 1 | 377 | 514 | 135 | Dictyostelium discoideum heat-shock cognate protein 70 (hsc70) mRNA, complete cds | blastn | 27167 | 267 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22973206 | 22973206 | PRJEB14664_P_NODE_2499_length_578_cov_2.976059_g2385_i0 | PRJEB14664 | 2499 | 578 | 2.976059 | 17.20162102 | uncultured Soliformovum | 2510342 | Evosea | other_Eukaryota | 593 | 7.559999999999997e-165 | NTclustered | gi|1564356923|gb|MK443523.1| | 2510342 | g2385 | i0 | 95.225 | 36.7179930795848 | 377 | 15 | 65 | 2 | 203 | 578 | 425 | 51 | Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 21223 | 593 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | uncultured Soliformovum |
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);;