contig_metadata
18 rows where bioproject = "PRJNA560932", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1820470 | 1820470 | PRJNA560932_P_NODE_51602_length_252_cov_1.139665_g51246_i0 | PRJNA560932 | 51602 | 252 | 1.139665 | 2.8719558 | root | 1 | Root_unresolved | Root_unresolved | 88.6 | 9.72e-19 | NR | ETO10361.1 | 46433 | g51246 | i0 | 51.3 | 4.69047619047619 | 78 | 38 | 92.9 | 0 | 244 | 11 | 83 | 160 | ETO10361.1 hypothetical protein RFI_27015 [Reticulomyxa filosa] | diamond | 1182 | 88.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 9473186 | 9473186 | PRJNA560932_P_NODE_27748_length_341_cov_0.828358_g27392_i0 | PRJNA560932 | 27748 | 341 | 0.828358 | 2.82470078 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.01e-33 | NR | ETO30355.1 | 46433 | g27392 | i0 | 54 | 23.8504398826979 | 113 | 52 | 99.4 | 0 | 339 | 1 | 252 | 364 | ETO30355.1 hypothetical protein RFI_06765, partial [Reticulomyxa filosa] | diamond | 8133 | 132 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 12023851 | 12023851 | PRJNA560932_P_NODE_48490_length_262_cov_0.936508_g48134_i0 | PRJNA560932 | 48490 | 262 | 0.936508 | 2.45365096 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 3.11e-34 | NR | ETO16925.1 | 46433 | g48134 | i0 | 73 | 16.0763358778626 | 89 | 22 | 99.6 | 1 | 261 | 1 | 487 | 575 | ETO16925.1 hypothetical protein RFI_20413 [Reticulomyxa filosa] | diamond | 4212 | 134 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 22221734 | 22221734 | PRJNA560932_P_NODE_34618_length_309_cov_0.978814_g34262_i0 | PRJNA560932 | 34618 | 309 | 0.978814 | 3.02453526 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 4.94e-11 | NR | ETO15384.1 | 46433 | g34262 | i0 | 41.9 | 0.83495145631068 | 86 | 45 | 80.6 | 2 | 249 | 1 | 132 | 215 | ETO15384.1 alkylated DNA repair protein [Reticulomyxa filosa] | diamond | 258 | 68.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27598692 | 27598692 | PRJNA560932_P_NODE_33224_length_314_cov_3.468880_g32868_i0 | PRJNA560932 | 33224 | 314 | 3.46888 | 10.8922832 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 2.79e-27 | NR | ETO22507.1 | 46433 | g32868 | i0 | 63.9 | 5.47452229299363 | 83 | 27 | 79.3 | 1 | 36 | 284 | 35 | 114 | ETO22507.1 mitochondrial dicarboxylate carrier protein [Reticulomyxa filosa] | diamond | 1719 | 112 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27693515 | 27693515 | PRJNA560932_P_NODE_28224_length_338_cov_1.162264_g27868_i0 | PRJNA560932 | 28224 | 338 | 1.162264 | 3.92845232 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 8.77e-13 | NR | ETO01289.1 | 46433 | g27868 | i0 | 39.8 | 3.04437869822485 | 123 | 51 | 92.3 | 3 | 337 | 26 | 192 | 310 | ETO01289.1 hypothetical protein RFI_36155 [Reticulomyxa filosa] | diamond | 1029 | 74.7 | 0.994645247657296 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27995124 | 27995124 | PRJNA560932_P_NODE_63205_length_243_cov_2.711765_g62849_i0 | PRJNA560932 | 63205 | 243 | 2.711765 | 6.5895889499999996 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 1.42e-22 | NR | ETO23439.1 | 46433 | g62849 | i0 | 51.3 | 0.962962962962963 | 78 | 37 | 95.1 | 1 | 242 | 12 | 28 | 105 | ETO23439.1 flagellar WD repeat protein PF20, partial [Reticulomyxa filosa] | diamond | 234 | 98.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28103539 | 28103539 | PRJNA560932_P_NODE_48885_length_260_cov_1.647059_g48529_i0 | PRJNA560932 | 48885 | 260 | 1.647059 | 4.2823534 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 4.36e-20 | NR | ETO33242.1 | 46433 | g48529 | i0 | 51.7 | 5.26153846153846 | 87 | 41 | 99.2 | 1 | 258 | 1 | 278 | 364 | ETO33242.1 hypothetical protein RFI_03863 [Reticulomyxa filosa] | diamond | 1368 | 94.7 | 0.992608236536431 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28987994 | 28987994 | PRJNA560932_P_NODE_46688_length_267_cov_1.587629_g46332_i0 | PRJNA560932 | 46688 | 267 | 1.587629 | 4.23896943 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 7.03e-8 | NR | ETO11912.1 | 46433 | g46332 | i0 | 51 | 1.92134831460674 | 49 | 19 | 53.9 | 2 | 122 | 265 | 29 | 73 | ETO11912.1 hypothetical protein RFI_25461 [Reticulomyxa filosa] | diamond | 513 | 59.7 | 0.993299832495812 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29478685 | 29478685 | PRJNA560932_P_NODE_21490_length_381_cov_1.133117_g21134_i0 | PRJNA560932 | 21490 | 381 | 1.133117 | 4.31717577 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 9.49e-10 | NR | ETO27885.1 | 46433 | g21134 | i0 | 36.6 | 0.795275590551181 | 101 | 62 | 78.7 | 2 | 2 | 301 | 27 | 126 | ETO27885.1 hypothetical protein RFI_09247 [Reticulomyxa filosa] | diamond | 303 | 63.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30061198 | 30061198 | PRJNA560932_P_NODE_31971_length_320_cov_1.246964_g31615_i0 | PRJNA560932 | 31971 | 320 | 1.246964 | 3.9902848 | root | 1 | Root_unresolved | Root_unresolved | 114 | 2e-27 | NR | ETO10579.1 | 46433 | g31615 | i0 | 60.9 | 6.346875 | 87 | 34 | 81.6 | 0 | 2 | 262 | 321 | 407 | ETO10579.1 hypothetical protein RFI_26798 [Reticulomyxa filosa] | diamond | 2031 | 114 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30472255 | 30472255 | PRJNA560932_P_NODE_30233_length_328_cov_1.207843_g29877_i0 | PRJNA560932 | 30233 | 328 | 1.207843 | 3.96172504 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 4.61e-13 | NR | ETO17561.1 | 46433 | g29877 | i0 | 50 | 5.89939024390244 | 76 | 37 | 68.6 | 1 | 301 | 77 | 105 | 180 | ETO17561.1 hypothetical protein RFI_19759 [Reticulomyxa filosa] | diamond | 1935 | 73.2 | 0.994535519125683 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31027052 | 31027052 | PRJNA560932_P_NODE_37755_length_296_cov_1.372197_g37399_i0 | PRJNA560932 | 37755 | 296 | 1.3721969999999999 | 4.06170312 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 1.7699999999999998e-23 | NR | ETO27122.1 | 46433 | g37399 | i0 | 50.5 | 0.983108108108108 | 97 | 46 | 96.3 | 2 | 7 | 291 | 10 | 106 | ETO27122.1 citrate synthase [Reticulomyxa filosa] | diamond | 291 | 98.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31325273 | 31325273 | PRJNA560932_P_NODE_44935_length_273_cov_0.985000_g44579_i0 | PRJNA560932 | 44935 | 273 | 0.985 | 2.68905 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 5.6e-21 | NR | ETO31342.1 | 46433 | g44579 | i0 | 45.6 | 2.94505494505495 | 90 | 49 | 98.9 | 0 | 272 | 3 | 36 | 125 | ETO31342.1 histone acetyltransferase Gcn5, partial [Reticulomyxa filosa] | diamond | 804 | 91.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31831202 | 31831202 | PRJNA560932_P_NODE_33537_length_313_cov_1.604167_g33181_i0 | PRJNA560932 | 33537 | 313 | 1.604167 | 5.02104271 | root | 1 | Root_unresolved | Root_unresolved | 64.7 | 1.5e-9 | NR | ETO25763.1 | 46433 | g33181 | i0 | 47.7 | 2.33865814696486 | 65 | 31 | 59.4 | 1 | 284 | 99 | 78 | 142 | ETO25763.1 G-protein beta WD-40 repeats containing protein [Reticulomyxa filosa] | diamond | 732 | 64.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31849060 | 31849060 | PRJNA560932_P_NODE_9837_length_555_cov_2.863071_g9483_i0 | PRJNA560932 | 9837 | 555 | 2.863071 | 15.89004405 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 3.38e-68 | NR | ETO35216.1 | 46433 | g9483 | i0 | 61.3 | 1.00540540540541 | 186 | 67 | 98.9 | 3 | 553 | 5 | 174 | 357 | ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] | diamond | 558 | 229 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32070553 | 32070553 | PRJNA560932_P_NODE_60138_length_246_cov_0.890173_g59782_i0 | PRJNA560932 | 60138 | 246 | 0.890173 | 2.18982558 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 5.62e-27 | NR | ETO14107.1 | 46433 | g59782 | i0 | 51.6 | 1.13414634146341 | 93 | 31 | 96.3 | 2 | 3 | 239 | 187 | 279 | ETO14107.1 hypothetical protein RFI_23263 [Reticulomyxa filosa] | diamond | 279 | 109 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32671077 | 32671077 | PRJNA560932_P_NODE_3560_length_896_cov_2.187120_g3280_i0 | PRJNA560932 | 3560 | 896 | 2.18712 | 19.5965952 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.889999999999999e-96 | NR | ETO35216.1 | 46433 | g3280 | i0 | 53.4 | 2.9765625 | 305 | 125 | 96.8 | 4 | 894 | 28 | 344 | 647 | ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] | diamond | 2667 | 307 | 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);;