contig_metadata
11 rows where bioproject = "PRJNA1059246" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6555423 | 6555423 | PRJNA1059246_P_NODE_73026_length_231_cov_2.651899_g72400_i0 | PRJNA1059246 | 73026 | 231 | 2.651899 | 6.12588669 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.27e-63 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g72400 | i0 | 89.163 | 83.2510822510823 | 203 | 22 | 88 | 0 | 29 | 231 | 231 | 433 | Paulinella micropora gene for actin, complete cds | blastn | 19231 | 254 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 13764888 | 13764888 | PRJNA1059246_P_NODE_51051_length_286_cov_1.248826_g50425_i0 | PRJNA1059246 | 51051 | 286 | 1.248826 | 3.57164236 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 4.97e-19 | NR | MES1910324.1 | 1215613 | g50425 | i0 | 59.2 | 0.744755244755245 | 71 | 29 | 74.5 | 0 | 285 | 73 | 427 | 497 | MES1910324.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 213 | 91.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26900748 | 26900748 | PRJNA1059246_P_NODE_49901_length_289_cov_1.898148_g49275_i0 | PRJNA1059246 | 49901 | 289 | 1.898148 | 5.48564772 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 5.68e-14 | NR | MES1909405.1 | 1215613 | g49275 | i0 | 43.5 | 2.77162629757785 | 92 | 52 | 95.5 | 0 | 280 | 5 | 252 | 343 | MES1909405.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 801 | 77 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27035385 | 27035385 | PRJNA1059246_P_NODE_57102_length_267_cov_1.190722_g56476_i0 | PRJNA1059246 | 57102 | 267 | 1.190722 | 3.17922774 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 3.8e-29 | NR | MES1912576.1 | 1215613 | g56476 | i0 | 61.6 | 2.8988764044943802 | 86 | 33 | 96.6 | 0 | 9 | 266 | 158 | 243 | MES1912576.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 774 | 115 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28109175 | 28109175 | PRJNA1059246_P_NODE_54225_length_276_cov_1.487685_g53599_i0 | PRJNA1059246 | 54225 | 276 | 1.487685 | 4.1060106 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 1.61e-16 | NR | MES1910819.1 | 1215613 | g53599 | i0 | 51.1 | 7.82608695652174 | 90 | 43 | 97.8 | 1 | 270 | 1 | 45 | 133 | MES1910819.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2160 | 79.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28519889 | 28519889 | PRJNA1059246_P_NODE_47047_length_302_cov_2.017467_g46421_i0 | PRJNA1059246 | 47047 | 302 | 2.017467 | 6.09275034 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.7e-9 | NR | MES1910644.1 | 1215613 | g46421 | i0 | 44 | 2.14569536423841 | 84 | 44 | 83.4 | 2 | 9 | 260 | 2 | 82 | MES1910644.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 648 | 60.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28930217 | 28930217 | PRJNA1059246_P_NODE_25988_length_436_cov_2.829201_g25363_i0 | PRJNA1059246 | 25988 | 436 | 2.829201 | 12.33531636 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.39e-33 | NR | MES1913934.1 | 1215613 | g25363 | i0 | 71.4 | 0.577981651376147 | 84 | 24 | 57.8 | 0 | 416 | 165 | 3 | 86 | MES1913934.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 252 | 122 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29277371 | 29277371 | PRJNA1059246_P_NODE_56889_length_267_cov_1.891753_g56263_i0 | PRJNA1059246 | 56889 | 267 | 1.891753 | 5.05098051 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 5.86e-12 | NR | MES1909771.1 | 1215613 | g56263 | i0 | 50.6 | 0.887640449438202 | 79 | 39 | 88.8 | 0 | 3 | 239 | 355 | 433 | MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 237 | 70.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29466642 | 29466642 | PRJNA1059246_P_NODE_54870_length_274_cov_1.383085_g54244_i0 | PRJNA1059246 | 54870 | 274 | 1.383085 | 3.7896529 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 8.49e-16 | NR | MES1907754.1 | 1215613 | g54244 | i0 | 41.4 | 0.952554744525547 | 87 | 51 | 95.3 | 0 | 272 | 12 | 169 | 255 | MES1907754.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 261 | 80.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31647049 | 31647049 | PRJNA1059246_P_NODE_30437_length_396_cov_3.247678_g29811_i0 | PRJNA1059246 | 30437 | 396 | 3.247678 | 12.86080488 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.029 | NR | MES1907148.1 | 1215613 | g29811 | i0 | 32.3 | 0.727272727272727 | 96 | 55 | 72 | 3 | 366 | 82 | 421 | 507 | MES1907148.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 288 | 45.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32816579 | 32816579 | PRJNA1059246_P_NODE_30900_length_392_cov_3.730408_g30274_i0 | PRJNA1059246 | 30900 | 392 | 3.730408 | 14.62319936 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.65e-22 | NR | MES1907754.1 | 1215613 | g30274 | i0 | 38.2 | 0.941326530612245 | 123 | 75 | 94.1 | 1 | 377 | 9 | 134 | 255 | MES1907754.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 369 | 99.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;