contig_metadata
15 rows where bioproject = "PRJNA1144090", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5390911 | 5390911 | PRJNA1144090_P_NODE_79645_length_282_cov_2.368421_g79110_i0 | PRJNA1144090 | 79645 | 282 | 2.368421 | 6.67894722 | root | 1 | Root_unresolved | Root_unresolved | 167 | 4.31e-46 | NR | ETO29549.1 | 46433 | g79110 | i0 | 86 | 53.4255319148936 | 93 | 13 | 98.9 | 0 | 2 | 280 | 1 | 93 | ETO29549.1 hypothetical protein RFI_07570 [Reticulomyxa filosa] | diamond | 15066 | 167 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26849166 | 26849166 | PRJNA1144090_P_NODE_51001_length_357_cov_1.964789_g50466_i0 | PRJNA1144090 | 51001 | 357 | 1.964789 | 7.01429673 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 4.37e-48 | NR | ETO30601.1 | 46433 | g50466 | i0 | 71.2 | 4.94117647058824 | 118 | 34 | 99.2 | 0 | 356 | 3 | 366 | 483 | ETO30601.1 mitochondrial cytochrome b2 [Reticulomyxa filosa] | diamond | 1764 | 171 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26912208 | 26912208 | PRJNA1144090_P_NODE_54262_length_345_cov_2.948529_g53727_i0 | PRJNA1144090 | 54262 | 345 | 2.948529 | 10.17242505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0136 | NR | ETO00220.1 | 46433 | g53727 | i0 | 37.8 | 0.643478260869565 | 74 | 46 | 64.3 | 0 | 237 | 16 | 160 | 233 | ETO00220.1 RND efflux system, outer membrane lipoprotein, NodT family, partial [Reticulomyxa filosa] | diamond | 222 | 45.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27059490 | 27059490 | PRJNA1144090_P_NODE_96962_length_254_cov_1.662983_g96427_i0 | PRJNA1144090 | 96962 | 254 | 1.662983 | 4.22397682 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 9.42e-9 | NR | ETO25387.1 | 46433 | g96427 | i0 | 43.1 | 4.12204724409449 | 65 | 37 | 76.8 | 0 | 204 | 10 | 446 | 510 | ETO25387.1 hypothetical protein RFI_11749 [Reticulomyxa filosa] | diamond | 1047 | 62 | 0.993548387096774 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27880700 | 27880700 | PRJNA1144090_P_NODE_68145_length_307_cov_0.987179_g67610_i0 | PRJNA1144090 | 68145 | 307 | 0.987179 | 3.03063953 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 4.23e-19 | NR | ETO33033.1 | 46433 | g67610 | i0 | 45.8 | 4.28013029315961 | 83 | 45 | 81.1 | 0 | 261 | 13 | 152 | 234 | ETO33033.1 hypothetical protein RFI_04075 [Reticulomyxa filosa] | diamond | 1314 | 90.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28270466 | 28270466 | PRJNA1144090_P_NODE_58026_length_333_cov_2.561538_g57491_i0 | PRJNA1144090 | 58026 | 333 | 2.561538 | 8.52992154 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 2.68e-11 | NR | ETO04451.1 | 46433 | g57491 | i0 | 37.3 | 0.918918918918919 | 102 | 53 | 91.9 | 1 | 22 | 327 | 79 | 169 | ETO04451.1 hypothetical protein RFI_32946, partial [Reticulomyxa filosa] | diamond | 306 | 70.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28997197 | 28997197 | PRJNA1144090_P_NODE_83468_length_275_cov_3.049505_g82933_i0 | PRJNA1144090 | 83468 | 275 | 3.049505 | 8.38613875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.07e-15 | NR | ETN99975.1 | 46433 | g82933 | i0 | 43.8 | 1.66909090909091 | 80 | 43 | 85.1 | 1 | 41 | 274 | 191 | 270 | ETN99975.1 Protein kinase domain containing protein [Reticulomyxa filosa] | diamond | 459 | 81.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29933270 | 29933270 | PRJNA1144090_P_NODE_79151_length_283_cov_2.176190_g78616_i0 | PRJNA1144090 | 79151 | 283 | 2.17619 | 6.1586177 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 7.7e-12 | NR | ETO28969.1 | 46433 | g78616 | i0 | 47.1 | 6.29681978798587 | 70 | 37 | 74.2 | 0 | 72 | 281 | 33 | 102 | ETO28969.1 hypothetical protein RFI_08155 [Reticulomyxa filosa] | diamond | 1782 | 70.9 | 0.994358251057828 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30292131 | 30292131 | PRJNA1144090_P_NODE_97712_length_253_cov_1.577778_g97177_i0 | PRJNA1144090 | 97712 | 253 | 1.577778 | 3.99177834 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 1.86e-19 | NR | ETO23642.1 | 46433 | g97177 | i0 | 56.8 | 0.960474308300395 | 81 | 30 | 90.1 | 1 | 2 | 229 | 368 | 448 | ETO23642.1 hypothetical protein RFI_13537 [Reticulomyxa filosa] | diamond | 243 | 92 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30797137 | 30797137 | PRJNA1144090_P_NODE_86774_length_270_cov_1.563452_g86239_i0 | PRJNA1144090 | 86774 | 270 | 1.563452 | 4.2213204 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00308 | NR | ETO14422.1 | 46433 | g86239 | i0 | 27.4 | 1.17777777777778 | 106 | 59 | 97.8 | 2 | 269 | 6 | 238 | 343 | ETO14422.1 hypothetical protein RFI_22944 [Reticulomyxa filosa] | diamond | 318 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31714037 | 31714037 | PRJNA1144090_P_NODE_72797_length_296_cov_2.004484_g72262_i0 | PRJNA1144090 | 72797 | 296 | 2.004484 | 5.93327264 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 9.94e-10 | NR | ETO33193.1 | 46433 | g72262 | i0 | 33.3 | 0.972972972972973 | 96 | 45 | 97.3 | 1 | 289 | 2 | 69 | 145 | ETO33193.1 hypothetical protein RFI_03915 [Reticulomyxa filosa] | diamond | 288 | 64.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32347083 | 32347083 | PRJNA1144090_P_NODE_98619_length_251_cov_2.651685_g98084_i0 | PRJNA1144090 | 98619 | 251 | 2.651685 | 6.65572935 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 6.300000000000001e-28 | NR | ETO15489.1 | 46433 | g98084 | i0 | 68.8 | 0.956175298804781 | 80 | 23 | 93.2 | 1 | 234 | 1 | 67 | 146 | ETO15489.1 hypothetical protein RFI_21873 [Reticulomyxa filosa] | diamond | 240 | 115 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32757176 | 32757176 | PRJNA1144090_P_NODE_55520_length_341_cov_1.910448_g54985_i0 | PRJNA1144090 | 55520 | 341 | 1.910448 | 6.51462768 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 7.77e-8 | NR | ETO09339.1 | 46433 | g54985 | i0 | 38 | 0.809384164222874 | 92 | 48 | 73.9 | 3 | 3 | 254 | 96 | 186 | ETO09339.1 Leu/Phe-tRNA protein transferase [Reticulomyxa filosa] | diamond | 276 | 59.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32777536 | 32777536 | PRJNA1144090_P_NODE_80640_length_280_cov_3.236715_g80105_i0 | PRJNA1144090 | 80640 | 280 | 3.236715 | 9.062802 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00617 | NR | ETO00245.1 | 46433 | g80105 | i0 | 44.4 | 2.07857142857143 | 54 | 27 | 54.6 | 2 | 272 | 120 | 194 | 247 | ETO00245.1 hypothetical protein RFI_37202 [Reticulomyxa filosa] | diamond | 582 | 45.8 | 0.991266375545852 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32820164 | 32820164 | PRJNA1144090_P_NODE_66760_length_310_cov_1.299578_g66225_i0 | PRJNA1144090 | 66760 | 310 | 1.299578 | 4.0286918 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0218 | NR | ETO14182.1 | 46433 | g66225 | i0 | 25 | 0.696774193548387 | 72 | 54 | 69.7 | 0 | 219 | 4 | 39 | 110 | ETO14182.1 hypothetical protein RFI_23183, partial [Reticulomyxa filosa] | diamond | 216 | 43.9 | 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);;