contig_metadata
12 rows where bioproject = "PRJNA1195374", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26851121 | 26851121 | PRJNA1195374_P_NODE_56381_length_289_cov_1.425926_g56037_i0 | PRJNA1195374 | 56381 | 289 | 1.425926 | 4.12092614 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 3.929999999999999e-40 | NR | ETO26066.1 | 46433 | g56037 | i0 | 67.4 | 0.986159169550173 | 95 | 31 | 98.6 | 0 | 4 | 288 | 363 | 457 | ETO26066.1 SET domain containing protein [Reticulomyxa filosa] | diamond | 285 | 150 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26882743 | 26882743 | PRJNA1195374_P_NODE_57081_length_287_cov_1.439252_g56737_i0 | PRJNA1195374 | 57081 | 287 | 1.439252 | 4.13065324 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00493 | NR | ETO23897.1 | 46433 | g56737 | i0 | 41.1 | 0.585365853658537 | 56 | 31 | 58.5 | 1 | 44 | 211 | 279 | 332 | ETO23897.1 hypothetical protein RFI_13262 [Reticulomyxa filosa] | diamond | 168 | 45.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29030536 | 29030536 | PRJNA1195374_P_NODE_1828_length_1323_cov_1.289600_g1671_i0 | PRJNA1195374 | 1828 | 1323 | 1.2896 | 17.061408 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 2.62e-11 | NR | ETO22264.1 | 46433 | g1671 | i0 | 59.3 | 0.122448979591837 | 54 | 22 | 12.2 | 0 | 993 | 1154 | 288 | 341 | ETO22264.1 hypothetical protein RFI_14933 [Reticulomyxa filosa] | diamond | 162 | 78.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29175799 | 29175799 | PRJNA1195374_P_NODE_31489_length_403_cov_0.933333_g31145_i0 | PRJNA1195374 | 31489 | 403 | 0.933333 | 3.76133199 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 2.75e-16 | NR | ETO29438.1 | 46433 | g31145 | i0 | 46.3 | 3.43920595533499 | 80 | 43 | 59.6 | 0 | 398 | 159 | 269 | 348 | ETO29438.1 protofilament ribbon protein of flagellar microtubules [Reticulomyxa filosa] | diamond | 1386 | 85.5 | 0.9953216374269 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29346157 | 29346157 | PRJNA1195374_P_NODE_53509_length_298_cov_1.368889_g53165_i0 | PRJNA1195374 | 53509 | 298 | 1.368889 | 4.07928922 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 6.57e-6 | NR | ETO33844.1 | 46433 | g53165 | i0 | 33.3 | 0.936241610738255 | 93 | 54 | 92.6 | 2 | 2 | 277 | 84 | 169 | ETO33844.1 hypothetical protein RFI_03259 [Reticulomyxa filosa] | diamond | 279 | 53.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29409199 | 29409199 | PRJNA1195374_P_NODE_81569_length_243_cov_1.641176_g81225_i0 | PRJNA1195374 | 81569 | 243 | 1.641176 | 3.98805768 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 1.12e-13 | NR | ETO12638.1 | 46433 | g81225 | i0 | 44.4 | 1 | 81 | 40 | 93.8 | 2 | 1 | 228 | 578 | 658 | ETO12638.1 hypothetical protein RFI_24735 [Reticulomyxa filosa] | diamond | 243 | 75.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31052124 | 31052124 | PRJNA1195374_P_NODE_32195_length_398_cov_1.280000_g31851_i0 | PRJNA1195374 | 32195 | 398 | 1.28 | 5.0944 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 7.869999999999999e-43 | NR | ETO25457.1 | 46433 | g31851 | i0 | 78.8 | 4.41708542713568 | 104 | 22 | 78.4 | 0 | 336 | 25 | 455 | 558 | ETO25457.1 hypothetical protein RFI_11680 [Reticulomyxa filosa] | diamond | 1758 | 158 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31146252 | 31146252 | PRJNA1195374_P_NODE_72135_length_250_cov_1.259887_g71791_i0 | PRJNA1195374 | 72135 | 250 | 1.259887 | 3.1497175 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 5.38e-14 | NR | ETO10631.1 | 46433 | g71791 | i0 | 40 | 1.956 | 80 | 48 | 96 | 0 | 11 | 250 | 71 | 150 | ETO10631.1 acid ceramidase-like protein [Reticulomyxa filosa] | diamond | 489 | 73.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31387166 | 31387166 | PRJNA1195374_P_NODE_56136_length_290_cov_1.059908_g55792_i0 | PRJNA1195374 | 56136 | 290 | 1.059908 | 3.0737332 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 0.00103 | NR | ETO29930.1 | 46433 | g55792 | i0 | 42.6 | 1.55172413793103 | 47 | 27 | 48.6 | 0 | 11 | 151 | 268 | 314 | ETO29930.1 glucosamine-6-phosphate deaminase [Reticulomyxa filosa] | diamond | 450 | 47.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32000656 | 32000656 | PRJNA1195374_P_NODE_65938_length_264_cov_1.209424_g65594_i0 | PRJNA1195374 | 65938 | 264 | 1.209424 | 3.19287936 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 5.16e-9 | NR | ETO29173.1 | 46433 | g65594 | i0 | 44.1 | 0.772727272727273 | 68 | 38 | 77.3 | 0 | 259 | 56 | 171 | 238 | ETO29173.1 hypothetical protein RFI_07952, partial [Reticulomyxa filosa] | diamond | 204 | 62.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32178019 | 32178019 | PRJNA1195374_P_NODE_27798_length_430_cov_1.697479_g27454_i0 | PRJNA1195374 | 27798 | 430 | 1.697479 | 7.2991597 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 6.79e-22 | NR | ETO21339.1 | 46433 | g27454 | i0 | 62.7 | 2.65116279069767 | 75 | 28 | 52.3 | 0 | 410 | 186 | 358 | 432 | ETO21339.1 hypothetical protein RFI_15866 [Reticulomyxa filosa] | diamond | 1140 | 100 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32222122 | 32222122 | PRJNA1195374_P_NODE_21858_length_485_cov_3.266990_g21514_i0 | PRJNA1195374 | 21858 | 485 | 3.26699 | 15.8449015 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 8.76e-12 | NR | ETO26716.1 | 46433 | g21514 | i0 | 42.4 | 0.612371134020619 | 99 | 57 | 61.2 | 0 | 466 | 170 | 88 | 186 | ETO26716.1 hypothetical protein RFI_10417 [Reticulomyxa filosa] | diamond | 297 | 70.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);;