contig_metadata
9 rows where bioproject = "PRJNA577580", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14592841 | 14592841 | PRJNA577580_P_NODE_11252_length_274_cov_2.243781_g11174_i0 | PRJNA577580 | 11252 | 274 | 2.243781 | 6.14795994 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 3.2099999999999995e-35 | NR | ETO13672.1 | 46433 | g11174 | i0 | 84.7 | 4.7956204379562 | 72 | 11 | 78.8 | 0 | 57 | 272 | 85 | 156 | ETO13672.1 RNA binding protein [Reticulomyxa filosa] | diamond | 1314 | 129 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28342948 | 28342948 | PRJNA577580_P_NODE_13866_length_252_cov_0.871508_g13788_i0 | PRJNA577580 | 13866 | 252 | 0.871508 | 2.19620016 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.68e-20 | NR | ETO16285.1 | 46433 | g13788 | i0 | 48.2 | 1.01190476190476 | 85 | 41 | 97.6 | 1 | 250 | 5 | 229 | 313 | ETO16285.1 phytanoyl-CoA dioxygenase (PhyH) family protein [Reticulomyxa filosa] | diamond | 255 | 93.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28974559 | 28974559 | PRJNA577580_P_NODE_14008_length_251_cov_0.876404_g13930_i0 | PRJNA577580 | 14008 | 251 | 0.876404 | 2.19977404 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.22e-26 | NR | ETO35216.1 | 46433 | g13930 | i0 | 57.8 | 1.9840637450199201 | 83 | 35 | 99.2 | 0 | 1 | 249 | 455 | 537 | ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] | diamond | 498 | 111 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29006441 | 29006441 | PRJNA577580_P_NODE_8008_length_319_cov_1.796748_g7930_i0 | PRJNA577580 | 8008 | 319 | 1.796748 | 5.73162612 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.67e-11 | NR | ETO01351.1 | 46433 | g7930 | i0 | 55.7 | 0.573667711598746 | 61 | 27 | 57.4 | 0 | 183 | 1 | 55 | 115 | ETO01351.1 NADPH-cytochrome-P450 oxidoreductase [Reticulomyxa filosa] | diamond | 183 | 70.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30996015 | 30996015 | PRJNA577580_P_NODE_15754_length_244_cov_1.368421_g15676_i0 | PRJNA577580 | 15754 | 244 | 1.368421 | 3.33894724 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 1.34e-13 | NR | ETO36349.1 | 46433 | g15676 | i0 | 49.4 | 1.99180327868852 | 81 | 40 | 98.4 | 1 | 3 | 242 | 114 | 194 | ETO36349.1 Popeye domain-containing protein [Reticulomyxa filosa] | diamond | 486 | 74.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31849628 | 31849628 | PRJNA577580_P_NODE_9117_length_301_cov_2.114035_g9039_i0 | PRJNA577580 | 9117 | 301 | 2.114035 | 6.36324535 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.06e-7 | NR | ETO35057.1 | 46433 | g9039 | i0 | 33 | 1.9734219269103 | 91 | 54 | 83.7 | 2 | 23 | 274 | 84 | 174 | ETO35057.1 hypothetical protein RFI_02018 [Reticulomyxa filosa] | diamond | 594 | 58.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32640082 | 32640082 | PRJNA577580_P_NODE_10680_length_281_cov_1.692308_g10602_i0 | PRJNA577580 | 10680 | 281 | 1.692308 | 4.75538548 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 1.08e-8 | NR | ETO28914.1 | 46433 | g10602 | i0 | 56.9 | 0.544483985765125 | 51 | 22 | 54.4 | 0 | 18 | 170 | 179 | 229 | ETO28914.1 hypothetical protein RFI_08212, partial [Reticulomyxa filosa] | diamond | 153 | 61.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32685111 | 32685111 | PRJNA577580_P_NODE_10220_length_287_cov_1.420561_g10142_i0 | PRJNA577580 | 10220 | 287 | 1.420561 | 4.07701007 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0245 | NR | ETO34968.1 | 46433 | g10142 | i0 | 38.7 | 2.0801393728223 | 62 | 36 | 62.7 | 1 | 30 | 209 | 553 | 614 | ETO34968.1 hypothetical protein RFI_02103, partial [Reticulomyxa filosa] | diamond | 597 | 43.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32860718 | 32860718 | PRJNA577580_P_NODE_12480_length_262_cov_2.476190_g12402_i0 | PRJNA577580 | 12480 | 262 | 2.47619 | 6.4876178 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.79e-6 | NR | ETO12101.1 | 46433 | g12402 | i0 | 41.7 | 0.687022900763359 | 60 | 34 | 67.6 | 1 | 84 | 260 | 46 | 105 | ETO12101.1 hypothetical protein RFI_25276 [Reticulomyxa filosa] | diamond | 180 | 55.1 | 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);;