contig_metadata
7 rows where bioproject = "PRJNA1144090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9214964 | 9214964 | PRJNA1144090_P_NODE_116828_length_240_cov_50.838323_g116293_i0 | PRJNA1144090 | 116828 | 240 | 50.838323 | 122.0119752 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 1.98e-62 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g116293 | i0 | 89.109 | 79.7166666666667 | 202 | 22 | 84 | 0 | 1 | 202 | 432 | 231 | Paulinella micropora gene for actin, complete cds | blastn | 19132 | 252 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 10491155 | 10491155 | PRJNA1144090_P_NODE_6369_length_1134_cov_5.471254_g6041_i0 | PRJNA1144090 | 6369 | 1134 | 5.471254 | 62.04402036 | Proleptomonas faecicola | 149084 | SAR_Eukaryotes | SAR_Eukaryotes | 760 | 0 | NTclustered | gi|300676734|gb|GQ377664.1| | 149084 | g6041 | i0 | 81.423 | 78.4391534391534 | 942 | 163 | 82 | 11 | 15 | 949 | 952 | 16 | Proleptomonas faecicola alpha-tubulin (Atub) gene, partial cds | blastn | 88950 | 760 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Proleptomonas | Proleptomonas faecicola | ||||
| 14316561 | 14316561 | PRJNA1144090_P_NODE_70352_length_301_cov_3.026316_g69817_i0 | PRJNA1144090 | 70352 | 301 | 3.026316 | 9.10921116 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.53e-69 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g69817 | i0 | 84.452 | 138.445182724253 | 283 | 41 | 99 | 2 | 1 | 280 | 2 | 284 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 41672 | 276 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 28933725 | 28933725 | PRJNA1144090_P_NODE_119448_length_230_cov_4.987261_g118913_i0 | PRJNA1144090 | 119448 | 230 | 4.987261 | 11.4707003 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 6.7e-6 | NR | MES1912797.1 | 1215613 | g118913 | i0 | 36.2 | 1.72173913043478 | 69 | 43 | 90 | 1 | 20 | 226 | 505 | 572 | MES1912797.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 396 | 53.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29312568 | 29312568 | PRJNA1144090_P_NODE_19649_length_614_cov_1.946396_g19125_i0 | PRJNA1144090 | 19649 | 614 | 1.946396 | 11.95087144 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 4.28e-29 | NR | MES1908571.1 | 1215613 | g19125 | i0 | 39.2 | 0.947882736156352 | 194 | 100 | 94.8 | 3 | 583 | 2 | 8 | 183 | MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 582 | 118 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30892142 | 30892142 | PRJNA1144090_P_NODE_52914_length_350_cov_1.935018_g52379_i0 | PRJNA1144090 | 52914 | 350 | 1.935018 | 6.772563 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 1.94e-5 | NR | MES1913935.1 | 1215613 | g52379 | i0 | 62.7 | 0.437142857142857 | 51 | 18 | 43.7 | 1 | 350 | 198 | 162 | 211 | MES1913935.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 153 | 53.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32093614 | 32093614 | PRJNA1144090_P_NODE_56678_length_337_cov_2.693182_g56143_i0 | PRJNA1144090 | 56678 | 337 | 2.693182 | 9.07602334 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 6.84e-12 | NR | MES1910874.1 | 1215613 | g56143 | i0 | 42.6 | 5.93768545994065 | 94 | 36 | 80.1 | 3 | 66 | 335 | 129 | 208 | MES1910874.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2001 | 70.5 | 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);;