contig_metadata
11 rows where bioproject = "PRJNA743294", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10926206 | 10926206 | PRJNA743294_P_NODE_8589_length_537_cov_2.592672_g8133_i0 | PRJNA743294 | 8589 | 537 | 2.592672 | 13.92264864 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 8.04e-20 | NR | ETO06661.1 | 46433 | g8133 | i0 | 66.1 | 1.3854748603352 | 62 | 21 | 34.6 | 0 | 9 | 194 | 21 | 82 | ETO06661.1 small rab-related GTPase [Reticulomyxa filosa] | diamond | 744 | 93.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 12201298 | 12201298 | PRJNA743294_P_NODE_15230_length_411_cov_2.517751_g14774_i0 | PRJNA743294 | 15230 | 411 | 2.517751 | 10.34795661 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 1.54e-8 | NR | ETO12436.1 | 46433 | g14774 | i0 | 34.8 | 1.27737226277372 | 89 | 52 | 60.6 | 2 | 341 | 93 | 324 | 412 | ETO12436.1 hypothetical protein RFI_24941 [Reticulomyxa filosa] | diamond | 525 | 63.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27031001 | 27031001 | PRJNA743294_P_NODE_14462_length_421_cov_1.709770_g14006_i0 | PRJNA743294 | 14462 | 421 | 1.70977 | 7.1981317 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 1.47e-6 | NR | ETO06880.1 | 46433 | g14006 | i0 | 43.9 | 1.84560570071259 | 66 | 34 | 44.9 | 1 | 167 | 355 | 621 | 686 | ETO06880.1 hypothetical protein RFI_30511 [Reticulomyxa filosa] | diamond | 777 | 58.2 | 0.993127147766323 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27779306 | 27779306 | PRJNA743294_P_NODE_39744_length_269_cov_2.954082_g39288_i0 | PRJNA743294 | 39744 | 269 | 2.954082 | 7.94648058 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 7.92e-11 | NR | ETO27970.1 | 46433 | g39288 | i0 | 45.3 | 7.5724907063197 | 86 | 46 | 94.8 | 1 | 4 | 258 | 97 | 182 | ETO27970.1 hypothetical protein RFI_09164 [Reticulomyxa filosa] | diamond | 2037 | 66.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30094093 | 30094093 | PRJNA743294_P_NODE_2852_length_880_cov_5.313507_g2508_i0 | PRJNA743294 | 2852 | 880 | 5.313507 | 46.7588616 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 1.21e-8 | NR | ETO27553.1 | 46433 | g2508 | i0 | 60 | 0.623863636363636 | 45 | 18 | 15.3 | 0 | 327 | 461 | 197 | 241 | ETO27553.1 hypothetical protein RFI_09582, partial [Reticulomyxa filosa] | diamond | 549 | 66.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30747745 | 30747745 | PRJNA743294_P_NODE_3774_length_776_cov_3.492176_g3383_i0 | PRJNA743294 | 3774 | 776 | 3.492176 | 27.09928576 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 2.8499999999999993e-28 | NR | ETO06189.1 | 46433 | g3383 | i0 | 45 | 0.541237113402062 | 140 | 70 | 52.2 | 4 | 433 | 29 | 742 | 879 | ETO06189.1 SAP DNA-binding domain-containing protein, partial [Reticulomyxa filosa] | diamond | 420 | 124 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31032306 | 31032306 | PRJNA743294_P_NODE_15695_length_405_cov_3.563253_g15239_i0 | PRJNA743294 | 15695 | 405 | 3.563253 | 14.43117465 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00941 | NR | ETO28464.1 | 46433 | g15239 | i0 | 36.7 | 0.362962962962963 | 49 | 30 | 35.6 | 1 | 179 | 36 | 63 | 111 | ETO28464.1 hypothetical protein RFI_08669 [Reticulomyxa filosa] | diamond | 147 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31221413 | 31221413 | PRJNA743294_P_NODE_22815_length_342_cov_2.970260_g22359_i0 | PRJNA743294 | 22815 | 342 | 2.97026 | 10.1582892 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.84e-5 | NR | ETO11325.1 | 46433 | g22359 | i0 | 46.3 | 2.71929824561404 | 54 | 26 | 44.7 | 2 | 27 | 179 | 197 | 250 | ETO11325.1 hypothetical protein RFI_26051 [Reticulomyxa filosa] | diamond | 930 | 53.1 | 0.994350282485876 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31484976 | 31484976 | PRJNA743294_P_NODE_41416_length_265_cov_1.218750_g40960_i0 | PRJNA743294 | 41416 | 265 | 1.21875 | 3.2296875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 7.849999999999999e-14 | NR | ETO36264.1 | 46433 | g40960 | i0 | 46.8 | 6.54339622641509 | 79 | 42 | 89.4 | 0 | 263 | 27 | 1242 | 1320 | ETO36264.1 vacuolar protein sorting-associated protein 13 family protein [Reticulomyxa filosa] | diamond | 1734 | 77 | 0.990909090909091 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31927591 | 31927591 | PRJNA743294_P_NODE_59397_length_228_cov_2.012903_g58941_i0 | PRJNA743294 | 59397 | 228 | 2.012903 | 4.5894188400000004 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.42e-6 | NR | ETO30081.1 | 46433 | g58941 | i0 | 37.9 | 3.02631578947368 | 58 | 36 | 76.3 | 0 | 180 | 7 | 3 | 60 | ETO30081.1 hypothetical protein RFI_07040 [Reticulomyxa filosa] | diamond | 690 | 55.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32654587 | 32654587 | PRJNA743294_P_NODE_2780_length_891_cov_3.803178_g2439_i0 | PRJNA743294 | 2780 | 891 | 3.803178 | 33.88631598 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.19e-20 | NR | ETO12035.1 | 46433 | g2439 | i0 | 29.2 | 4.62626262626263 | 226 | 141 | 71.7 | 5 | 708 | 70 | 428 | 647 | ETO12035.1 hypothetical protein RFI_25340 [Reticulomyxa filosa] | diamond | 4122 | 103 | 0.990291262135922 | 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);;