contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA356682" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2948066 | 2948066 | PRJNA356682_P_NODE_23563_length_300_cov_7.568282_g22872_i0 | PRJNA356682 | 23563 | 300 | 7.568282 | 22.704846 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 9.42e-47 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g22872 | i0 | 93.382 | 48.73 | 136 | 7 | 45 | 2 | 1 | 134 | 3711 | 3846 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14619 | 200 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 4225054 | 4225054 | PRJNA356682_P_NODE_4084_length_708_cov_5.866142_g3430_i0 | PRJNA356682 | 4084 | 708 | 5.866142 | 41.53228536 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 800 | 0 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g3430 | i0 | 94.902 | 74.7528248587571 | 510 | 26 | 72 | 0 | 199 | 708 | 2129 | 1620 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 52925 | 800 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 8050753 | 8050753 | PRJNA356682_P_NODE_25687_length_290_cov_1.184332_g24996_i0 | PRJNA356682 | 25687 | 290 | 1.184332 | 3.4345628 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 3.1699999999999996e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g24996 | i0 | 83.673 | 51.4862068965517 | 294 | 34 | 100 | 12 | 1 | 290 | 3711 | 3994 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14931 | 265 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13151206 | 13151206 | PRJNA356682_P_NODE_26831_length_285_cov_0.783019_g26140_i0 | PRJNA356682 | 26831 | 285 | 0.783019 | 2.23160415 | Mesofila limnetica | 1979842 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 3.96e-75 | NTclustered | gi|88792585|gb|DQ386166.1| | 1979842 | g26140 | i0 | 86.282 | 94.6912280701754 | 277 | 31 | 96 | 6 | 1 | 273 | 1868 | 1595 | Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence | blastn | 26987 | 294 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila limnetica | ||||
| 14426716 | 14426716 | PRJNA356682_P_NODE_44972_length_241_cov_0.916667_g44281_i0 | PRJNA356682 | 44972 | 241 | 0.916667 | 2.20916747 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 9.81e-21 | NTclustered | gi|2651357794|gb|PP174308.1| | 1979794 | g44281 | i0 | 93.421 | 31.8340248962656 | 76 | 5 | 49 | 0 | 1 | 76 | 4116 | 4191 | Cercomonas sp. isolate JGP5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 7672 | 113 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 20799163 | 20799163 | PRJNA356682_P_NODE_33897_length_257_cov_1.989130_g33206_i0 | PRJNA356682 | 33897 | 257 | 1.98913 | 5.1120641000000004 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 3.86e-10 | NTclustered | gi|1270185586|gb|MG266087.1| | 175275 | g33206 | i0 | 86.301 | 2.79377431906615 | 73 | 8 | 28 | 2 | 22 | 92 | 641 | 569 | Uncultured Cercozoa clone MossITSLSU910 large subunit ribosomal RNA gene, partial sequence | blastn | 718 | 78.7 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa |
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);;