contig_metadata
17 rows where bioproject = "PRJNA1108487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213416 | 213416 | PRJNA1108487_P_NODE_4661_length_324_cov_1.549801_g4595_i0 | PRJNA1108487 | 4661 | 324 | 1.549801 | 5.02135524 | Sorites sp. isolate X-1646 | 313723 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 1.62e-84 | NTclustered | gi|59859695|gb|AY764016.1| | 313723 | g4595 | i0 | 84.877 | 95.6203703703704 | 324 | 47 | 99 | 2 | 1 | 323 | 604 | 282 | Sorites sp. isolate X-1646 clone SoA611_2 actin type 1 gene, partial cds | blastn | 30981 | 326 | 1 | Eukaryota | Sar | Foraminifera | Miliolida | Soritidae | Sorites sp. isolate X-1646 | ||||
| 16790577 | 16790577 | PRJNA1108487_P_NODE_5334_length_307_cov_1.658120_g5268_i0 | PRJNA1108487 | 5334 | 307 | 1.65812 | 5.0904284 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.04e-26 | NR | ETO30124.1 | 46433 | g5268 | i0 | 58.1 | 2.814332247557 | 93 | 37 | 90.9 | 1 | 21 | 299 | 246 | 336 | ETO30124.1 carboxylesterase, partial [Reticulomyxa filosa] | diamond | 864 | 113 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 20614551 | 20614551 | PRJNA1108487_P_NODE_3077_length_388_cov_1.117460_g3011_i0 | PRJNA1108487 | 3077 | 388 | 1.11746 | 4.3357448 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 2.4e-42 | NR | ETO30003.1 | 46433 | g3011 | i0 | 55.8 | 0.997422680412371 | 129 | 56 | 99 | 1 | 384 | 1 | 188 | 316 | ETO30003.1 hypothetical protein RFI_07116 [Reticulomyxa filosa] | diamond | 387 | 153 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27604995 | 27604995 | PRJNA1108487_P_NODE_8964_length_251_cov_0.876404_g8898_i0 | PRJNA1108487 | 8964 | 251 | 0.876404 | 2.19977404 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 2.98e-20 | NR | ETO06942.1 | 46433 | g8898 | i0 | 50.6 | 1.93625498007968 | 83 | 41 | 99.2 | 0 | 250 | 2 | 154 | 236 | ETO06942.1 6-phosphofructokinase [Reticulomyxa filosa] | diamond | 486 | 92.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27668116 | 27668116 | PRJNA1108487_P_NODE_5424_length_305_cov_1.293103_g5358_i0 | PRJNA1108487 | 5424 | 305 | 1.293103 | 3.94396415 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 2.33e-25 | NR | ETO26723.1 | 46433 | g5358 | i0 | 55.1 | 0.963934426229508 | 98 | 43 | 95.4 | 1 | 2 | 292 | 476 | 573 | ETO26723.1 protein of unknown function DUF1929 [Reticulomyxa filosa] | diamond | 294 | 109 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28109865 | 28109865 | PRJNA1108487_P_NODE_8165_length_255_cov_1.274725_g8099_i0 | PRJNA1108487 | 8165 | 255 | 1.274725 | 3.25054875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0111 | NR | ETO28672.1 | 46433 | g8099 | i0 | 46 | 1.50588235294118 | 63 | 33 | 72.9 | 1 | 251 | 66 | 159 | 221 | ETO28672.1 Ubiquitin family protein [Reticulomyxa filosa] | diamond | 384 | 44.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28330957 | 28330957 | PRJNA1108487_P_NODE_7646_length_263_cov_1.078947_g7580_i0 | PRJNA1108487 | 7646 | 263 | 1.078947 | 2.83763061 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 4.75e-10 | NR | ETO33686.1 | 46433 | g7580 | i0 | 38.9 | 1.02661596958175 | 90 | 44 | 90.1 | 2 | 18 | 254 | 694 | 783 | ETO33686.1 hypothetical protein RFI_03416 [Reticulomyxa filosa] | diamond | 270 | 65.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28552194 | 28552194 | PRJNA1108487_P_NODE_1187_length_609_cov_2.479478_g1123_i0 | PRJNA1108487 | 1187 | 609 | 2.479478 | 15.10002102 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 5.29e-46 | NR | ETO17530.1 | 46433 | g1123 | i0 | 85.1 | 2.29556650246305 | 94 | 14 | 46.3 | 0 | 604 | 323 | 98 | 191 | ETO17530.1 hypothetical protein RFI_19788 [Reticulomyxa filosa] | diamond | 1398 | 160 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28804403 | 28804403 | PRJNA1108487_P_NODE_3248_length_378_cov_1.495082_g3182_i0 | PRJNA1108487 | 3248 | 378 | 1.495082 | 5.65140996 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 7.03e-12 | NR | ETO26723.1 | 46433 | g3182 | i0 | 60.8 | 0.404761904761905 | 51 | 20 | 40.5 | 0 | 377 | 225 | 593 | 643 | ETO26723.1 protein of unknown function DUF1929 [Reticulomyxa filosa] | diamond | 153 | 72.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29111802 | 29111802 | PRJNA1108487_P_NODE_4088_length_343_cov_1.155556_g4022_i0 | PRJNA1108487 | 4088 | 343 | 1.155556 | 3.96355708 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.04e-15 | NR | ETO23384.1 | 46433 | g4022 | i0 | 43.5 | 3.36734693877551 | 92 | 50 | 80.5 | 1 | 68 | 343 | 27 | 116 | ETO23384.1 hypothetical protein RFI_13798 [Reticulomyxa filosa] | diamond | 1155 | 81.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30604761 | 30604761 | PRJNA1108487_P_NODE_11213_length_242_cov_0.923077_g11147_i0 | PRJNA1108487 | 11213 | 242 | 0.923077 | 2.23384634 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 2.38e-17 | NR | ETO30774.1 | 46433 | g11147 | i0 | 52.8 | 1.78512396694215 | 72 | 34 | 89.3 | 0 | 219 | 4 | 338 | 409 | ETO30774.1 trehalose phosphate synthase, partial [Reticulomyxa filosa] | diamond | 432 | 85.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30636261 | 30636261 | PRJNA1108487_P_NODE_9153_length_250_cov_0.881356_g9087_i0 | PRJNA1108487 | 9153 | 250 | 0.881356 | 2.20339 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.67e-17 | NR | ETO13143.1 | 46433 | g9087 | i0 | 56.3 | 4.644 | 64 | 26 | 74.4 | 1 | 4 | 189 | 52 | 115 | ETO13143.1 hypothetical protein RFI_24232 [Reticulomyxa filosa] | diamond | 1161 | 80.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31647776 | 31647776 | PRJNA1108487_P_NODE_6077_length_290_cov_2.092166_g6011_i0 | PRJNA1108487 | 6077 | 290 | 2.092166 | 6.0672814 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.23e-24 | NR | ETO26723.1 | 46433 | g6011 | i0 | 53 | 1.03448275862069 | 100 | 42 | 98.3 | 2 | 6 | 290 | 365 | 464 | ETO26723.1 protein of unknown function DUF1929 [Reticulomyxa filosa] | diamond | 300 | 107 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31901019 | 31901019 | PRJNA1108487_P_NODE_11397_length_241_cov_2.261905_g11331_i0 | PRJNA1108487 | 11397 | 241 | 2.261905 | 5.45119105 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 3.59e-18 | NR | ETO09627.1 | 46433 | g11331 | i0 | 53.9 | 1.84232365145228 | 76 | 35 | 94.6 | 0 | 239 | 12 | 138 | 213 | ETO09627.1 hypothetical protein RFI_27749 [Reticulomyxa filosa] | diamond | 444 | 87.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32122703 | 32122703 | PRJNA1108487_P_NODE_7758_length_261_cov_1.659574_g7692_i0 | PRJNA1108487 | 7758 | 261 | 1.659574 | 4.33148814 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 2.56e-15 | NR | ETO26526.1 | 46433 | g7692 | i0 | 54.4 | 1.49425287356322 | 68 | 31 | 78.2 | 0 | 56 | 259 | 24 | 91 | ETO26526.1 RAB32, member RAS oncogene family [Reticulomyxa filosa] | diamond | 390 | 79.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32502442 | 32502442 | PRJNA1108487_P_NODE_5459_length_304_cov_1.350649_g5393_i0 | PRJNA1108487 | 5459 | 304 | 1.350649 | 4.10597296 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 3.82e-14 | NR | ETO27543.1 | 46433 | g5393 | i0 | 64 | 0.493421052631579 | 50 | 18 | 49.3 | 0 | 304 | 155 | 21 | 70 | ETO27543.1 hypothetical protein RFI_09592, partial [Reticulomyxa filosa] | diamond | 150 | 73.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32808626 | 32808626 | PRJNA1108487_P_NODE_3480_length_367_cov_1.476190_g3414_i0 | PRJNA1108487 | 3480 | 367 | 1.47619 | 5.4176173 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.73e-24 | NR | ETO26558.1 | 46433 | g3414 | i0 | 65.2 | 4.59400544959128 | 69 | 24 | 56.4 | 0 | 360 | 154 | 2 | 70 | ETO26558.1 hypothetical protein RFI_10581 [Reticulomyxa filosa] | diamond | 1686 | 102 | 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);;