contig_metadata
8 rows where bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008007 | 2008007 | PRJNA756891_P_NODE_12822_length_249_cov_1.750000_g12753_i0 | PRJNA756891 | 12822 | 249 | 1.75 | 4.3575 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 3.39e-75 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g12753 | i0 | 88.048 | 61.7791164658635 | 251 | 27 | 100 | 3 | 1 | 249 | 2977 | 2728 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 15383 | 294 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 10130911 | 10130911 | PRJNA756891_P_NODE_2588_length_519_cov_1.033632_g2520_i0 | PRJNA756891 | 2588 | 519 | 1.033632 | 5.36455008 | Cercozoa | 136419 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 1.5899999999999998e-101 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g2520 | i0 | 80.19 | 50.6339113680154 | 525 | 90 | 100 | 11 | 1 | 519 | 750 | 234 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 26279 | 383 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 16034680 | 16034680 | PRJNA756891_P_NODE_6953_length_326_cov_1.083004_g6884_i0 | PRJNA756891 | 6953 | 326 | 1.083004 | 3.53059304 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.06e-26 | NTclustered | gi|1315527746|gb|MF034898.1| | 2065209 | g6884 | i0 | 84.783 | 2.97852760736196 | 138 | 15 | 42 | 5 | 70 | 205 | 1267 | 1400 | Phytocercomonas venanatans actin gene, complete cds | blastn | 971 | 134 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 27621755 | 27621755 | PRJNA756891_P_NODE_4044_length_418_cov_1.278261_g3975_i0 | PRJNA756891 | 4044 | 418 | 1.278261 | 5.34313098 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 4.26e-8 | NR | MES1910748.1 | 1215613 | g3975 | i0 | 43.9 | 0.409090909090909 | 57 | 31 | 40.9 | 1 | 248 | 418 | 183 | 238 | MES1910748.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 171 | 62 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27726570 | 27726570 | PRJNA756891_P_NODE_1784_length_616_cov_1.836096_g1717_i0 | PRJNA756891 | 1784 | 616 | 1.836096 | 11.31035136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.17e-27 | NR | MES1911532.1 | 1215613 | g1717 | i0 | 36.1 | 3.99837662337662 | 205 | 130 | 99.4 | 1 | 2 | 613 | 344 | 548 | MES1911532.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2463 | 119 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29547446 | 29547446 | PRJNA756891_P_NODE_12950_length_249_cov_0.875000_g12881_i0 | PRJNA756891 | 12950 | 249 | 0.875 | 2.17875 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 94.7 | 1.41e-21 | NR | MES1916673.1 | 1215613 | g12881 | i0 | 48.1 | 1.91566265060241 | 79 | 41 | 95.2 | 0 | 238 | 2 | 85 | 163 | MES1916673.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 477 | 94.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32329531 | 32329531 | PRJNA756891_P_NODE_7859_length_309_cov_1.563559_g7790_i0 | PRJNA756891 | 7859 | 309 | 1.563559 | 4.83139731 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 6.07e-5 | NR | MES1907101.1 | 1215613 | g7790 | i0 | 33.3 | 0.757281553398058 | 78 | 50 | 75.7 | 1 | 253 | 20 | 470 | 545 | MES1907101.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 234 | 51.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32802561 | 32802561 | PRJNA756891_P_NODE_5200_length_371_cov_2.067114_g5131_i0 | PRJNA756891 | 5200 | 371 | 2.067114 | 7.66899294 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.6199999999999998e-32 | NR | MES1909471.1 | 1215613 | g5131 | i0 | 54.6 | 0.962264150943396 | 119 | 54 | 96.2 | 0 | 1 | 357 | 224 | 342 | MES1909471.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 357 | 129 | 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);;