contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1164198" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 311953 | 311953 | PRJNA1164198_P_NODE_15241_length_317_cov_1.254098_g14972_i0 | PRJNA1164198 | 15241 | 317 | 1.254098 | 3.97549066 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 154 | 4.53e-45 | NR | XP_004334642.1 | 1257118 | g14972 | i0 | 70.8 | 1.00315457413249 | 106 | 29 | 98.4 | 1 | 2 | 313 | 85 | 190 | XP_004334642.1 Ras family GTPase [Acanthamoeba castellanii str. Neff] | diamond | 318 | 154 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16889040 | 16889040 | PRJNA1164198_P_NODE_11534_length_366_cov_1.491468_g11266_i0 | PRJNA1164198 | 11534 | 366 | 1.491468 | 5.45877288 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 209 | 3.05e-65 | NR | XP_004338439.1 | 1257118 | g11266 | i0 | 76.9 | 0.991803278688525 | 121 | 26 | 98.4 | 2 | 2 | 361 | 185 | 304 | XP_004338439.1 protein phosphatase 6, catalytic subunit isoform a, putative [Acanthamoeba castellanii str. Neff] | diamond | 363 | 209 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27230030 | 27230030 | PRJNA1164198_P_NODE_27583_length_247_cov_1.126437_g27314_i0 | PRJNA1164198 | 27583 | 247 | 1.126437 | 2.78229939 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 99.8 | 4.1e-25 | NR | XP_004339691.1 | 1257118 | g27314 | i0 | 78.4 | 0.619433198380567 | 51 | 11 | 61.9 | 0 | 239 | 87 | 5 | 55 | XP_004339691.1 ribosomal S29 subunit [Acanthamoeba castellanii str. Neff] | diamond | 153 | 99.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28335315 | 28335315 | PRJNA1164198_P_NODE_18666_length_287_cov_1.271028_g18397_i0 | PRJNA1164198 | 18666 | 287 | 1.271028 | 3.64785036 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 98.2 | 4.9899999999999996e-23 | NR | XP_004336032.1 | 1257118 | g18397 | i0 | 57.5 | 0.836236933797909 | 80 | 34 | 83.6 | 0 | 287 | 48 | 131 | 210 | XP_004336032.1 reticulon protein [Acanthamoeba castellanii str. Neff] | diamond | 240 | 98.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28714282 | 28714282 | PRJNA1164198_P_NODE_22327_length_263_cov_1.231579_g22058_i0 | PRJNA1164198 | 22327 | 263 | 1.231579 | 3.23905277 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 133 | 3.65e-35 | NR | XP_004349632.1 | 1257118 | g22058 | i0 | 73.3 | 2.94296577946768 | 86 | 23 | 98.1 | 0 | 2 | 259 | 62 | 147 | XP_004349632.1 calreticulin, putative [Acanthamoeba castellanii str. Neff] | diamond | 774 | 133 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28840442 | 28840442 | PRJNA1164198_P_NODE_30128_length_243_cov_0.917647_g29859_i0 | PRJNA1164198 | 30128 | 243 | 0.917647 | 2.22988221 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 102 | 2.87e-23 | NR | XP_004333651.1 | 1257118 | g29859 | i0 | 60.8 | 0.975308641975309 | 79 | 31 | 97.5 | 0 | 239 | 3 | 185 | 263 | XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff] | diamond | 237 | 102 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29471700 | 29471700 | PRJNA1164198_P_NODE_21870_length_266_cov_1.212435_g21601_i0 | PRJNA1164198 | 21870 | 266 | 1.212435 | 3.2250771 | Vannella croatica | 1778588 | Discosea | other_Eukaryota | 112 | 3.57e-30 | NR | AUO29193.1 | 1778588 | g21601 | i0 | 94.6 | 0.631578947368421 | 56 | 3 | 63.2 | 0 | 170 | 3 | 6 | 61 | AUO29193.1 H(+)-transporting ATPase subunit 9 [Vannella croatica] | diamond | 168 | 112 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella croatica | |||
| 30071933 | 30071933 | PRJNA1164198_P_NODE_14832_length_321_cov_1.262097_g14563_i0 | PRJNA1164198 | 14832 | 321 | 1.262097 | 4.05133137 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 63.9 | 2.75e-9 | NR | XP_004341763.1 | 1257118 | g14563 | i0 | 85.7 | 1.57009345794393 | 42 | 6 | 39.3 | 0 | 3 | 128 | 210 | 251 | XP_004341763.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 504 | 63.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30198210 | 30198210 | PRJNA1164198_P_NODE_23812_length_254_cov_1.602210_g23543_i0 | PRJNA1164198 | 23812 | 254 | 1.60221 | 4.0696134 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 52 | 2.32e-5 | NR | XP_004341797.1 | 1257118 | g23543 | i0 | 44.2 | 1.01574803149606 | 86 | 39 | 94.5 | 3 | 4 | 243 | 481 | 563 | XP_004341797.1 protein kinase domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 258 | 52 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30419949 | 30419949 | PRJNA1164198_P_NODE_26893_length_248_cov_1.714286_g26624_i0 | PRJNA1164198 | 26893 | 248 | 1.714286 | 4.25142928 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 46.6 | 0.0016 | NR | XP_004336758.1 | 1257118 | g26624 | i0 | 44.8 | 0.701612903225806 | 58 | 29 | 69 | 2 | 2 | 172 | 28 | 83 | XP_004336758.1 uncharacterized protein ACA1_390820 [Acanthamoeba castellanii str. Neff] | diamond | 174 | 46.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30798630 | 30798630 | PRJNA1164198_P_NODE_22354_length_263_cov_1.231579_g22085_i0 | PRJNA1164198 | 22354 | 263 | 1.231579 | 3.23905277 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 43.5 | 0.012 | NR | XP_004334493.1 | 1257118 | g22085 | i0 | 39 | 0.673003802281369 | 59 | 32 | 65 | 2 | 183 | 13 | 75 | 131 | XP_004334493.1 uncharacterized protein ACA1_330540 [Acanthamoeba castellanii str. Neff] | diamond | 177 | 43.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31240977 | 31240977 | PRJNA1164198_P_NODE_27755_length_247_cov_0.896552_g27486_i0 | PRJNA1164198 | 27755 | 247 | 0.896552 | 2.21448344 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 70.5 | 4.35e-12 | NR | XP_004341750.1 | 1257118 | g27486 | i0 | 63.6 | 1.06882591093117 | 44 | 16 | 53.4 | 0 | 152 | 21 | 276 | 319 | XP_004341750.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 264 | 70.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31291908 | 31291908 | PRJNA1164198_P_NODE_28535_length_246_cov_0.901734_g28266_i0 | PRJNA1164198 | 28535 | 246 | 0.901734 | 2.21826564 | Cryptophyceae | 3027 | Discosea | other_Eukaryota | 93.6 | 2.61e-22 | NR | 7SOG_A | 5755 | g28266 | i0 | 48.1 | 2.97560975609756 | 81 | 42 | 98.8 | 0 | 3 | 245 | 3 | 83 | 7SOG_A Chain A, Actophorin [Acanthamoeba castellanii] | diamond | 732 | 94.4 | 0.991525423728813 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31335890 | 31335890 | PRJNA1164198_P_NODE_29196_length_245_cov_0.906977_g28927_i0 | PRJNA1164198 | 29196 | 245 | 0.906977 | 2.22209365 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 72.4 | 1.19e-12 | NR | XP_004345941.1 | 1257118 | g28927 | i0 | 47.2 | 1.77551020408163 | 72 | 38 | 88.2 | 0 | 233 | 18 | 194 | 265 | XP_004345941.1 uncharacterized protein ACA1_183310 [Acanthamoeba castellanii str. Neff] | diamond | 435 | 72.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;