contig_metadata
22 rows where bioproject = "PRJNA1122875", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 277585 | 277585 | PRJNA1122875_P_NODE_23181_length_346_cov_1.798535_g22957_i0 | PRJNA1122875 | 23181 | 346 | 1.798535 | 6.2229311 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 7.28e-66 | NR | ETO03070.1 | 46433 | g22957 | i0 | 87 | 1.99421965317919 | 115 | 15 | 99.7 | 0 | 1 | 345 | 52 | 166 | ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] | diamond | 690 | 207 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 14306809 | 14306809 | PRJNA1122875_P_NODE_54572_length_229_cov_2.467949_g54348_i0 | PRJNA1122875 | 54572 | 229 | 2.467949 | 5.65160321 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 4.64e-21 | NR | ETO17364.1 | 46433 | g54348 | i0 | 60.8 | 1.96506550218341 | 74 | 29 | 96.9 | 0 | 224 | 3 | 106 | 179 | ETO17364.1 hypothetical protein RFI_19957, partial [Reticulomyxa filosa] | diamond | 450 | 94.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27101718 | 27101718 | PRJNA1122875_P_NODE_52562_length_242_cov_0.911243_g52338_i0 | PRJNA1122875 | 52562 | 242 | 0.911243 | 2.20520806 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.06e-5 | NR | ETO08196.1 | 46433 | g52338 | i0 | 31.6 | 1.88429752066116 | 76 | 50 | 93 | 2 | 240 | 16 | 286 | 360 | ETO08196.1 hypothetical protein RFI_29194, partial [Reticulomyxa filosa] | diamond | 456 | 52.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27975319 | 27975319 | PRJNA1122875_P_NODE_33925_length_283_cov_1.833333_g33701_i0 | PRJNA1122875 | 33925 | 283 | 1.833333 | 5.18833239 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 5.33e-12 | NR | ETO00348.1 | 46433 | g33701 | i0 | 38.9 | 2.69257950530035 | 90 | 47 | 92.2 | 3 | 16 | 276 | 163 | 247 | ETO00348.1 TLDc domain-containing protein [Reticulomyxa filosa] | diamond | 762 | 70.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28270058 | 28270058 | PRJNA1122875_P_NODE_14326_length_441_cov_1.217391_g14102_i0 | PRJNA1122875 | 14326 | 441 | 1.217391 | 5.36869431 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 5.58e-4 | NR | ETO19897.1 | 46433 | g14102 | i0 | 36.4 | 1.61224489795918 | 99 | 57 | 64.6 | 4 | 396 | 112 | 115 | 211 | ETO19897.1 hypothetical protein RFI_17327 [Reticulomyxa filosa] | diamond | 711 | 50.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28586220 | 28586220 | PRJNA1122875_P_NODE_30967_length_293_cov_1.531818_g30743_i0 | PRJNA1122875 | 30967 | 293 | 1.531818 | 4.48822674 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.79e-9 | NR | ETO13143.1 | 46433 | g30743 | i0 | 56.9 | 0.522184300341297 | 51 | 18 | 48.1 | 1 | 1 | 141 | 60 | 110 | ETO13143.1 hypothetical protein RFI_24232 [Reticulomyxa filosa] | diamond | 153 | 60.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28743930 | 28743930 | PRJNA1122875_P_NODE_45427_length_249_cov_0.875000_g45203_i0 | PRJNA1122875 | 45427 | 249 | 0.875 | 2.17875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.9299999999999998e-32 | NR | ETO05095.1 | 46433 | g45203 | i0 | 72.8 | 0.975903614457831 | 81 | 22 | 97.6 | 0 | 247 | 5 | 333 | 413 | ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] | diamond | 243 | 129 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28775353 | 28775353 | PRJNA1122875_P_NODE_15767_length_420_cov_1.870317_g15543_i0 | PRJNA1122875 | 15767 | 420 | 1.870317 | 7.8553314 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.03e-24 | NR | ETO07780.1 | 46433 | g15543 | i0 | 41.9 | 1.77857142857143 | 129 | 72 | 90 | 2 | 411 | 34 | 339 | 467 | ETO07780.1 hypothetical protein RFI_29612 [Reticulomyxa filosa] | diamond | 747 | 108 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29028339 | 29028339 | PRJNA1122875_P_NODE_18328_length_390_cov_0.883281_g18104_i0 | PRJNA1122875 | 18328 | 390 | 0.883281 | 3.4447959 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 1.13e-13 | NR | ETO36728.1 | 46433 | g18104 | i0 | 36.3 | 1.59230769230769 | 102 | 64 | 78.5 | 1 | 306 | 1 | 43 | 143 | ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa] | diamond | 621 | 74.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29343878 | 29343878 | PRJNA1122875_P_NODE_18229_length_391_cov_0.968553_g18005_i0 | PRJNA1122875 | 18229 | 391 | 0.968553 | 3.78704223 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 2.78e-4 | NR | ETO19767.1 | 46433 | g18005 | i0 | 34.7 | 0.728900255754476 | 95 | 57 | 69.1 | 1 | 63 | 332 | 168 | 262 | ETO19767.1 hypothetical protein RFI_17464 [Reticulomyxa filosa] | diamond | 285 | 50.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29459017 | 29459017 | PRJNA1122875_P_NODE_31670_length_290_cov_1.419355_g31446_i0 | PRJNA1122875 | 31670 | 290 | 1.419355 | 4.1161295 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.86e-33 | NR | ETO16568.1 | 46433 | g31446 | i0 | 67 | 56.7620689655172 | 91 | 30 | 94.1 | 0 | 5 | 277 | 125 | 215 | ETO16568.1 14-3-3-like protein [Reticulomyxa filosa] | diamond | 16461 | 125 | 0.992 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29817279 | 29817279 | PRJNA1122875_P_NODE_46851_length_248_cov_0.880000_g46627_i0 | PRJNA1122875 | 46851 | 248 | 0.88 | 2.1824 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.1699999999999998e-23 | NR | ETO27461.1 | 46433 | g46627 | i0 | 63.9 | 2.00806451612903 | 83 | 29 | 99.2 | 1 | 3 | 248 | 1281 | 1363 | ETO27461.1 HECT type ubiquitin ligase [Reticulomyxa filosa] | diamond | 498 | 103 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29869829 | 29869829 | PRJNA1122875_P_NODE_26391_length_322_cov_1.369478_g26167_i0 | PRJNA1122875 | 26391 | 322 | 1.369478 | 4.40971916 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 9.29e-32 | NR | ETO21339.1 | 46433 | g26167 | i0 | 56.9 | 15.1770186335404 | 109 | 44 | 98.8 | 1 | 320 | 3 | 300 | 408 | ETO21339.1 hypothetical protein RFI_15866 [Reticulomyxa filosa] | diamond | 4887 | 126 | 0.992063492063492 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29880786 | 29880786 | PRJNA1122875_P_NODE_33631_length_284_cov_1.459716_g33407_i0 | PRJNA1122875 | 33631 | 284 | 1.459716 | 4.14559344 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.89e-4 | NR | ETO05715.1 | 46433 | g33407 | i0 | 35.4 | 0.834507042253521 | 79 | 47 | 83.5 | 1 | 283 | 47 | 70 | 144 | ETO05715.1 hypothetical protein RFI_31679 [Reticulomyxa filosa] | diamond | 237 | 48.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30670367 | 30670367 | PRJNA1122875_P_NODE_23033_length_347_cov_1.934307_g22809_i0 | PRJNA1122875 | 23033 | 347 | 1.934307 | 6.71204529 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 6.35e-20 | NR | ETO03758.1 | 46433 | g22809 | i0 | 54.5 | 3.12103746397695 | 88 | 40 | 76.1 | 0 | 2 | 265 | 42 | 129 | ETO03758.1 mitochondrial carrier domain-containing protein [Reticulomyxa filosa] | diamond | 1083 | 89 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30754513 | 30754513 | PRJNA1122875_P_NODE_21514_length_358_cov_1.589474_g21290_i0 | PRJNA1122875 | 21514 | 358 | 1.589474 | 5.69031692 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 4.500000000000001e-22 | NR | ETO27461.1 | 46433 | g21290 | i0 | 43.2 | 5.92458100558659 | 118 | 66 | 98 | 1 | 357 | 7 | 1246 | 1363 | ETO27461.1 HECT type ubiquitin ligase [Reticulomyxa filosa] | diamond | 2121 | 101 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30891762 | 30891762 | PRJNA1122875_P_NODE_24674_length_334_cov_1.973180_g24450_i0 | PRJNA1122875 | 24674 | 334 | 1.97318 | 6.5904212 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.07e-28 | NR | ETO11964.1 | 46433 | g24450 | i0 | 91.2 | 2.55988023952096 | 57 | 5 | 51.2 | 0 | 1 | 171 | 137 | 193 | ETO11964.1 glycoprotein FP21 precursor [Reticulomyxa filosa] | diamond | 855 | 111 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31049928 | 31049928 | PRJNA1122875_P_NODE_51135_length_243_cov_1.805882_g50911_i0 | PRJNA1122875 | 51135 | 243 | 1.805882 | 4.38829326 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.67e-9 | NR | ETO11254.1 | 46433 | g50911 | i0 | 52.5 | 1.19753086419753 | 59 | 28 | 72.8 | 0 | 2 | 178 | 394 | 452 | ETO11254.1 propionyl Coenzyme A carboxylase, beta polypeptide [Reticulomyxa filosa] | diamond | 291 | 63.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31576444 | 31576444 | PRJNA1122875_P_NODE_23816_length_341_cov_1.589552_g23592_i0 | PRJNA1122875 | 23816 | 341 | 1.589552 | 5.42037232 | root | 1 | Root_unresolved | Root_unresolved | 71.6 | 7.5e-13 | NR | ETO10156.1 | 46433 | g23592 | i0 | 36 | 2.81524926686217 | 111 | 64 | 95.9 | 3 | 341 | 15 | 66 | 171 | ETO10156.1 hypothetical protein RFI_27219 [Reticulomyxa filosa] | diamond | 960 | 71.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31650194 | 31650194 | PRJNA1122875_P_NODE_41657_length_256_cov_1.262295_g41433_i0 | PRJNA1122875 | 41657 | 256 | 1.262295 | 3.2314752 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 7.25e-9 | NR | ETO26857.1 | 46433 | g41433 | i0 | 47.6 | 1.5 | 63 | 33 | 73.8 | 0 | 247 | 59 | 67 | 129 | ETO26857.1 hypothetical protein RFI_10277 [Reticulomyxa filosa] | diamond | 384 | 61.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32219895 | 32219895 | PRJNA1122875_P_NODE_14558_length_437_cov_2.387363_g14334_i0 | PRJNA1122875 | 14558 | 437 | 2.387363 | 10.43277631 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.02e-5 | NR | ETO24662.1 | 46433 | g14334 | i0 | 47.2 | 1.44851258581236 | 53 | 28 | 36.4 | 0 | 2 | 160 | 464 | 516 | ETO24662.1 hypothetical protein RFI_12495 [Reticulomyxa filosa] | diamond | 633 | 55.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32536457 | 32536457 | PRJNA1122875_P_NODE_35119_length_279_cov_1.888350_g34895_i0 | PRJNA1122875 | 35119 | 279 | 1.88835 | 5.2684965 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 9.209999999999997e-43 | NR | ETO20735.1 | 46433 | g34895 | i0 | 74.4 | 8.88172043010753 | 90 | 23 | 96.8 | 0 | 8 | 277 | 61 | 150 | ETO20735.1 glutamine-tRNA ligase, partial [Reticulomyxa filosa] | diamond | 2478 | 154 | 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);;