contig_metadata
15 rows where bioproject = "PRJNA980585", tax_clade = "Sar" and tax_phylum = "Foraminifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11158605 | 11158605 | PRJNA980585_P_NODE_60329_length_241_cov_0.916667_g60075_i0 | PRJNA980585 | 60329 | 241 | 0.916667 | 2.20916747 | Rhabdammina cornuta | 159866 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.0099999999999997e-57 | NTclustered | gi|66932472|gb|AY818731.1| | 159866 | g60075 | i0 | 84.979 | 43.0373443983403 | 233 | 33 | 96 | 2 | 9 | 240 | 186 | 417 | Rhabdammina cornuta clone A4 alpha tubulin gene, partial cds | blastn | 10372 | 235 | 1 | Eukaryota | Sar | Foraminifera | Astrorhizida | Astrorhizidae | Rhabdammina | Rhabdammina cornuta | |||
| 12433603 | 12433603 | PRJNA980585_P_NODE_14030_length_369_cov_1.560811_g13776_i0 | PRJNA980585 | 14030 | 369 | 1.560811 | 5.75939259 | root | 1 | Root_unresolved | Root_unresolved | 160 | 4.2400000000000003e-44 | NR | ETO14870.1 | 46433 | g13776 | i0 | 62 | 7.86991869918699 | 121 | 46 | 98.4 | 0 | 5 | 367 | 330 | 450 | ETO14870.1 hypothetical protein RFI_22497 [Reticulomyxa filosa] | diamond | 2904 | 161 | 0.993788819875776 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 15297243 | 15297243 | PRJNA980585_P_NODE_28372_length_284_cov_1.450237_g28118_i0 | PRJNA980585 | 28372 | 284 | 1.450237 | 4.11867308 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.4699999999999998e-42 | NR | ETO09453.1 | 46433 | g28118 | i0 | 75.3 | 11.9049295774648 | 93 | 23 | 98.2 | 0 | 1 | 279 | 183 | 275 | ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa] | diamond | 3381 | 152 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 16571915 | 16571915 | PRJNA980585_P_NODE_43073_length_250_cov_0.870056_g42819_i0 | PRJNA980585 | 43073 | 250 | 0.870056 | 2.17514 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 7.29e-28 | NR | ETO18591.1 | 46433 | g42819 | i0 | 70.4 | 0.972 | 81 | 24 | 97.2 | 0 | 3 | 245 | 419 | 499 | ETO18591.1 P-type ATPase [Reticulomyxa filosa] | diamond | 243 | 115 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 17532757 | 17532757 | PRJNA980585_P_NODE_3494_length_657_cov_1.957192_g3243_i0 | PRJNA980585 | 3494 | 657 | 1.957192 | 12.85875144 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 352 | 7.24e-117 | NR | ETN98485.1 | 46433 | g3243 | i0 | 75.8 | 29.2374429223744 | 219 | 53 | 100 | 0 | 657 | 1 | 185 | 403 | ETN98485.1 hypothetical protein RFI_39013 [Reticulomyxa filosa] | diamond | 19209 | 352 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27120697 | 27120697 | PRJNA980585_P_NODE_51542_length_246_cov_0.890173_g51288_i0 | PRJNA980585 | 51542 | 246 | 0.890173 | 2.18982558 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 2.52e-12 | NR | ETO06202.1 | 46433 | g51288 | i0 | 45 | 3.70731707317073 | 80 | 43 | 97.6 | 1 | 245 | 6 | 505 | 583 | ETO06202.1 hypothetical protein RFI_31194 [Reticulomyxa filosa] | diamond | 912 | 71.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28200691 | 28200691 | PRJNA980585_P_NODE_28926_length_282_cov_2.105263_g28672_i0 | PRJNA980585 | 28926 | 282 | 2.105263 | 5.93684166 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 2.71e-40 | NR | ETO12574.1 | 46433 | g28672 | i0 | 69.2 | 2.8936170212766 | 91 | 28 | 96.8 | 0 | 274 | 2 | 222 | 312 | ETO12574.1 dual function enzyme: UDP-glucose 4-epimerase [Reticulomyxa filosa] | diamond | 816 | 147 | 0.993197278911565 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28510553 | 28510553 | PRJNA980585_P_NODE_32987_length_271_cov_1.555556_g32733_i0 | PRJNA980585 | 32987 | 271 | 1.555556 | 4.21555676 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 5.65e-29 | NR | ETO24530.1 | 46433 | g32733 | i0 | 62.2 | 3.7970479704797 | 90 | 34 | 99.6 | 0 | 1 | 270 | 255 | 344 | ETO24530.1 protein kinase, cAMP-dependent, catalytic chain [Reticulomyxa filosa] | diamond | 1029 | 119 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29678418 | 29678418 | PRJNA980585_P_NODE_23350_length_304_cov_1.549784_g23096_i0 | PRJNA980585 | 23350 | 304 | 1.549784 | 4.71134336 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.43e-25 | NR | ETO12540.1 | 46433 | g23096 | i0 | 63.1 | 2.94078947368421 | 84 | 31 | 82.9 | 0 | 254 | 3 | 299 | 382 | ETO12540.1 hypothetical protein RFI_24836 [Reticulomyxa filosa] | diamond | 894 | 110 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31131752 | 31131752 | PRJNA980585_P_NODE_48195_length_247_cov_1.701149_g47941_i0 | PRJNA980585 | 48195 | 247 | 1.701149 | 4.20183803 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00197 | NR | ETO31420.1 | 46433 | g47941 | i0 | 40.4 | 0.692307692307692 | 57 | 33 | 69.2 | 1 | 8 | 178 | 166 | 221 | ETO31420.1 hypothetical protein RFI_05701 [Reticulomyxa filosa] | diamond | 171 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31194791 | 31194791 | PRJNA980585_P_NODE_12835_length_382_cov_2.792880_g12581_i0 | PRJNA980585 | 12835 | 382 | 2.79288 | 10.6688016 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00848 | NR | ETO26890.1 | 46433 | g12581 | i0 | 35.9 | 0.722513089005236 | 92 | 57 | 70.7 | 2 | 105 | 374 | 62 | 153 | ETO26890.1 hypothetical protein RFI_10244, partial [Reticulomyxa filosa] | diamond | 276 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31385122 | 31385122 | PRJNA980585_P_NODE_43756_length_250_cov_0.870056_g43502_i0 | PRJNA980585 | 43756 | 250 | 0.870056 | 2.17514 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00925 | NR | ETO05837.1 | 46433 | g43502 | i0 | 52.3 | 0.528 | 44 | 21 | 52.8 | 0 | 119 | 250 | 167 | 210 | ETO05837.1 mucin-like low complexity glycoprotein, partial [Reticulomyxa filosa] | diamond | 132 | 44.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31543247 | 31543247 | PRJNA980585_P_NODE_8136_length_460_cov_1.193798_g7882_i0 | PRJNA980585 | 8136 | 460 | 1.193798 | 5.4914708 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 4.94e-28 | NR | ETO09060.1 | 46433 | g7882 | i0 | 42.7 | 0.932608695652174 | 143 | 82 | 93.3 | 0 | 3 | 431 | 153 | 295 | ETO09060.1 hypothetical protein RFI_28330 [Reticulomyxa filosa] | diamond | 429 | 119 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32049207 | 32049207 | PRJNA980585_P_NODE_13798_length_372_cov_0.892977_g13544_i0 | PRJNA980585 | 13798 | 372 | 0.892977 | 3.32187444 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 5.27e-36 | NR | ETO12540.1 | 46433 | g13544 | i0 | 59.6 | 6.26612903225806 | 109 | 44 | 87.9 | 0 | 371 | 45 | 434 | 542 | ETO12540.1 hypothetical protein RFI_24836 [Reticulomyxa filosa] | diamond | 2331 | 140 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32270913 | 32270913 | PRJNA980585_P_NODE_60558_length_241_cov_0.916667_g60304_i0 | PRJNA980585 | 60558 | 241 | 0.916667 | 2.20916747 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.33e-5 | NR | ETO05938.1 | 46433 | g60304 | i0 | 41.7 | 0.896265560165975 | 72 | 38 | 89.6 | 2 | 24 | 239 | 230 | 297 | ETO05938.1 trichohyalin [Reticulomyxa filosa] | diamond | 216 | 52.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa |
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);;