contig_metadata
11 rows where bioproject = "PRJNA744060" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14751908 | 14751908 | PRJNA744060_P_NODE_16072_length_401_cov_2.871951_g15743_i0 | PRJNA744060 | 16072 | 401 | 2.871951 | 11.51652351 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 104 | 3.59e-26 | NR | GKT24809.1 | 2918883 | g15743 | i0 | 72.5 | 1.02493765586035 | 69 | 19 | 51.6 | 0 | 123 | 329 | 41 | 109 | GKT24809.1 Histone H4 like protein [Aduncisulcus paluster] | diamond | 411 | 104 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 17301615 | 17301615 | PRJNA744060_P_NODE_44074_length_253_cov_0.866667_g43745_i0 | PRJNA744060 | 44074 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.5 | 3.65e-17 | NR | GIQ86335.1 | 797122 | g43745 | i0 | 53.7 | 1.86166007905138 | 82 | 38 | 97.2 | 0 | 251 | 6 | 389 | 470 | GIQ86335.1 dynein heavy chain, partial [Kipferlia bialata] | diamond | 471 | 85.5 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 26704264 | 26704264 | PRJNA744060_P_NODE_15181_length_412_cov_2.595870_g14852_i0 | PRJNA744060 | 15181 | 412 | 2.59587 | 10.6949844 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 153 | 1.71e-44 | NR | GKT34541.1 | 2918883 | g14852 | i0 | 55.9 | 1.98058252427184 | 136 | 60 | 99 | 0 | 4 | 411 | 12 | 147 | GKT34541.1 Calcineurin B protein like protein [Aduncisulcus paluster] | diamond | 816 | 153 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27968650 | 27968650 | PRJNA744060_P_NODE_16785_length_393_cov_2.003125_g16456_i0 | PRJNA744060 | 16785 | 393 | 2.003125 | 7.87228125 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 119 | 2.33e-28 | NR | CAK8776523.1 | 28002 | g16456 | i0 | 47.6 | 9.6793893129771 | 126 | 66 | 96.2 | 0 | 3 | 380 | 1228 | 1353 | CAK8776523.1 HINF_030324 [Hexamita inflata] | diamond | 3804 | 119 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28199511 | 28199511 | PRJNA744060_P_NODE_35766_length_276_cov_2.295567_g35437_i0 | PRJNA744060 | 35766 | 276 | 2.295567 | 6.33576492 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 2.62e-28 | NR | KAG9390257.1 | 201153 | g35437 | i0 | 65 | 2.6195652173913 | 80 | 28 | 87 | 0 | 275 | 36 | 46 | 125 | KAG9390257.1 C2 domain of PTEN tumor-suppressor protein [Carpediemonas membranifera] | diamond | 723 | 118 | 0.991525423728814 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28199515 | 28199515 | PRJNA744060_P_NODE_47166_length_248_cov_0.891429_g46837_i0 | PRJNA744060 | 47166 | 248 | 0.891429 | 2.21074392 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.6 | 5.44e-13 | NR | KAG9396286.1 | 201153 | g46837 | i0 | 48.7 | 1.8508064516129 | 76 | 39 | 91.9 | 0 | 20 | 247 | 87 | 162 | KAG9396286.1 Cation Channel Sperm Associated 4 CatSper4 [Carpediemonas membranifera] | diamond | 459 | 73.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28221131 | 28221131 | PRJNA744060_P_NODE_44646_length_252_cov_0.871508_g44317_i0 | PRJNA744060 | 44646 | 252 | 0.871508 | 2.19620016 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 42.7 | 0.0409 | NR | XP_067760730.1 | 348837 | g44317 | i0 | 32.5 | 0.952380952380952 | 80 | 50 | 90.5 | 1 | 16 | 243 | 182 | 261 | XP_067760730.1 hypothetical protein SS50377_27929 [Spironucleus salmonicida] | diamond | 240 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28505390 | 28505390 | PRJNA744060_P_NODE_13387_length_438_cov_3.312329_g13058_i0 | PRJNA744060 | 13387 | 438 | 3.312329 | 14.50800102 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 144 | 2.4899999999999996e-37 | NR | KAG9397118.1 | 201153 | g13058 | i0 | 70.5 | 1.3013698630137 | 88 | 26 | 60.3 | 0 | 174 | 437 | 11 | 98 | KAG9397118.1 Proline-tRNA ligase class IIa [Carpediemonas membranifera] | diamond | 570 | 144 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28767967 | 28767967 | PRJNA744060_P_NODE_14307_length_424_cov_3.928775_g13978_i0 | PRJNA744060 | 14307 | 424 | 3.928775 | 16.658006 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 3.52e-67 | NR | KAG9393315.1 | 201153 | g13978 | i0 | 69.7 | 12.2405660377358 | 132 | 40 | 93.4 | 0 | 27 | 422 | 6 | 137 | KAG9393315.1 Small GTPase superfamily [Carpediemonas membranifera] | diamond | 5190 | 211 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30179005 | 30179005 | PRJNA744060_P_NODE_992_length_1359_cov_6.084759_g860_i0 | PRJNA744060 | 992 | 1359 | 6.084759 | 82.69187481 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 87.8 | 2.72e-14 | NR | KAG9395425.1 | 201153 | g860 | i0 | 21.1 | 0.898454746136865 | 407 | 303 | 87.9 | 7 | 1230 | 37 | 52 | 449 | KAG9395425.1 hypothetical protein J8273_2992 [Carpediemonas membranifera] | diamond | 1221 | 87.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32896703 | 32896703 | PRJNA744060_P_NODE_33900_length_283_cov_1.485714_g33571_i0 | PRJNA744060 | 33900 | 283 | 1.485714 | 4.20457062 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 55.1 | 2.51e-6 | NR | KAG9393183.1 | 201153 | g33571 | i0 | 38.9 | 3.46643109540636 | 72 | 30 | 76.3 | 2 | 60 | 275 | 112 | 169 | KAG9393183.1 Endoplasmic reticulum vesicle transporter [Carpediemonas membranifera] | diamond | 981 | 55.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera |
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);;