contig_metadata
9 rows where bioproject = "PRJEB8827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25530299 | 25530299 | PRJEB8827h_S_NODE_1409_length_261_cov_6.017699_g1390_i0 | PRJEB8827 | 1409 | 261 | 6.017699 | 15.70619439 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 472 | 1.54e-128 | NTclustered | gi|262262922|gb|FJ766465.1| | 472931 | g1390 | i0 | 99.234 | 45.0919540229885 | 261 | 2 | 100 | 0 | 1 | 261 | 62 | 322 | Protostelium mycophagum strain HI07-20L-IV small subunit ribosomal RNA gene, partial sequence | blastn | 11769 | 472 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 25530329 | 25530329 | PRJEB8827h_S_NODE_2521_length_221_cov_2.967742_g2502_i0 | PRJEB8827 | 2521 | 221 | 2.967742 | 6.55870982 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 292 | 1.06e-74 | NTclustered | gi|262262922|gb|FJ766465.1| | 472931 | g2502 | i0 | 99.379 | 73.606334841629 | 161 | 1 | 73 | 0 | 1 | 161 | 1103 | 943 | Protostelium mycophagum strain HI07-20L-IV small subunit ribosomal RNA gene, partial sequence | blastn | 16267 | 292 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 25801583 | 25801583 | PRJEB8827b_S_NODE_28539_length_177_cov_5.246479_g28487_i0 | PRJEB8827 | 28539 | 177 | 5.246479 | 9.28626783 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 152 | 1.43e-32 | NTclustered | gi|1160564476|ref|XM_020583030.1| | 670386 | g28487 | i0 | 91.743 | 57.3446327683616 | 109 | 9 | 62 | 0 | 69 | 177 | 1185 | 1077 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 10150 | 152 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 25802423 | 25802423 | PRJEB8827h_S_NODE_1411_length_261_cov_4.132743_g1392_i0 | PRJEB8827 | 1411 | 261 | 4.132743 | 10.78645923 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 126 | 1.38e-24 | NTclustered | gi|1160571044|ref|XM_020575016.1| | 670386 | g1392 | i0 | 82.517 | 1.33716475095785 | 143 | 25 | 55 | 0 | 115 | 257 | 435 | 293 | Polysphondylium pallidum PN500 40S ribosomal protein S14 (rps14), partial mRNA | blastn | 349 | 126 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 26074649 | 26074649 | PRJEB8827h_S_NODE_21717_length_181_cov_4.136986_g21698_i0 | PRJEB8827 | 21717 | 181 | 4.136986 | 7.48794466 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 283 | 5.01e-72 | NTclustered | gi|262262922|gb|FJ766465.1| | 472931 | g21698 | i0 | 98.742 | 32.0497237569061 | 159 | 2 | 88 | 0 | 1 | 159 | 1266 | 1424 | Protostelium mycophagum strain HI07-20L-IV small subunit ribosomal RNA gene, partial sequence | blastn | 5801 | 283 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 26346561 | 26346561 | PRJEB8827f_S_NODE_7383_length_191_cov_2.166667_g7363_i0 | PRJEB8827 | 7383 | 191 | 2.166667 | 4.13833397 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 102 | 1.61e-17 | NTclustered | gi|470265703|ref|XM_004361527.1| | 261658 | g7363 | i0 | 87.778 | 5.60732984293194 | 90 | 8 | 46 | 2 | 57 | 143 | 364 | 453 | Cavenderia fasciculata annexin VII (nxnA), partial mRNA | blastn | 1071 | 102 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 26482954 | 26482954 | PRJEB8827h_S_NODE_2408_length_223_cov_4.436170_g2389_i0 | PRJEB8827 | 2408 | 223 | 4.43617 | 9.8926591 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 407 | 3.67e-109 | NTclustered | gi|262262922|gb|FJ766465.1| | 472931 | g2389 | i0 | 99.552 | 62.8923766816144 | 223 | 1 | 100 | 0 | 1 | 223 | 955 | 733 | Protostelium mycophagum strain HI07-20L-IV small subunit ribosomal RNA gene, partial sequence | blastn | 14025 | 407 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 32965622 | 32965622 | PRJEB8827f_S_NODE_2178_length_284_cov_3.032129_g2158_i0 | PRJEB8827 | 2178 | 284 | 3.032129 | 8.61124636 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 71.6 | 3.34e-12 | NR | XP_643357.1 | 352472 | g2158 | i0 | 42.2 | 0.950704225352113 | 90 | 51 | 94 | 1 | 276 | 10 | 272 | 361 | XP_643357.1 protein disulfide isomerase [Dictyostelium discoideum AX4] | diamond | 270 | 71.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 33050811 | 33050811 | PRJEB8827h_S_NODE_2413_length_223_cov_2.718085_g2394_i0 | PRJEB8827 | 2413 | 223 | 2.718085 | 6.06132955 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 50.4 | 2.41e-5 | NR | KAF2071651.1 | 133409 | g2394 | i0 | 43.6 | 0.739910313901345 | 55 | 29 | 74 | 1 | 1 | 165 | 119 | 171 | KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum] | diamond | 165 | 50.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum |
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);;