contig_metadata
9 rows where bioproject = "PRJNA977246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2226718 | 2226718 | PRJNA977246_S_NODE_32022_length_215_cov_26.801075_g31030_i0 | PRJNA977246 | 32022 | 215 | 26.801075 | 57.62231125 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.08e-39 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g31030 | i0 | 81.86 | 38.1581395348837 | 215 | 34 | 99 | 5 | 1 | 212 | 2025 | 2237 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 8204 | 176 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo | ||
| 3502262 | 3502262 | PRJNA977246_S_NODE_46243_length_163_cov_2.000000_g45251_i0 | PRJNA977246 | 46243 | 163 | 2 | 3.26 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 7.46e-65 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g45251 | i0 | 95.152 | 123.871165644172 | 165 | 6 | 100 | 2 | 1 | 163 | 3827 | 3663 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20191 | 259 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 4779565 | 4779565 | PRJNA977246_S_NODE_32464_length_213_cov_3.489130_g31472_i0 | PRJNA977246 | 32464 | 213 | 3.48913 | 7.4318469 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.32e-31 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g31472 | i0 | 79.812 | 8.30985915492958 | 213 | 36 | 99 | 6 | 1 | 210 | 1665 | 1873 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 1770 | 148 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 8604197 | 8604197 | PRJNA977246_S_NODE_27967_length_239_cov_53.533333_g26975_i0 | PRJNA977246 | 27967 | 239 | 53.533333 | 127.94466587 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 8.679999999999998e-101 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g26975 | i0 | 95.082 | 97.4853556485356 | 244 | 7 | 100 | 1 | 1 | 239 | 1408 | 1651 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 23299 | 379 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 11154501 | 11154501 | PRJNA977246_S_NODE_18289_length_329_cov_261.903333_g17297_i0 | PRJNA977246 | 18289 | 329 | 261.903333 | 861.66196557 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.5699999999999994e-119 | NTclustered | gi|1270185585|gb|MG266086.1| | 175275 | g17297 | i0 | 90.909 | 100.562310030395 | 330 | 28 | 100 | 2 | 1 | 329 | 328 | 656 | Uncultured Cercozoa clone MossITSLSU68 large subunit ribosomal RNA gene, partial sequence | blastn | 33085 | 442 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 21353447 | 21353447 | PRJNA977246_S_NODE_33437_length_208_cov_15.379888_g32445_i0 | PRJNA977246 | 33437 | 208 | 15.379888 | 31.99016704 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.69e-57 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g32445 | i0 | 87.324 | 24.3221153846154 | 213 | 18 | 99 | 5 | 1 | 205 | 1662 | 1873 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 5059 | 235 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25177075 | 25177075 | PRJNA977246_S_NODE_17800_length_335_cov_40.254902_g16808_i0 | PRJNA977246 | 17800 | 335 | 40.254902 | 134.8539217 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 7.31e-133 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g16808 | i0 | 92.836 | 100.75223880597 | 335 | 24 | 100 | 0 | 1 | 335 | 1752 | 2086 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 33752 | 486 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 25177482 | 25177482 | PRJNA977246_S_NODE_31820_length_216_cov_25.791444_g30828_i0 | PRJNA977246 | 31820 | 216 | 25.791444 | 55.709519040000004 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 3.79e-59 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g30828 | i0 | 86.878 | 25.0555555555556 | 221 | 21 | 99 | 4 | 1 | 213 | 1653 | 1873 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 5412 | 241 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 30215567 | 30215567 | PRJNA977246_S_NODE_28672_length_234_cov_861.648780_g27680_i0 | PRJNA977246 | 28672 | 234 | 861.64878 | 2016.2581452 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 1.97e-7 | NR | MES1912635.1 | 1215613 | g27680 | i0 | 39.7 | 2.80769230769231 | 73 | 38 | 85.9 | 1 | 34 | 234 | 31 | 103 | MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 657 | 57.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);;