contig_metadata
12 rows where bioproject = "PRJNA770361", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3297640 | 3297640 | PRJNA770361_P_NODE_423_length_1337_cov_3.840190_g388_i0 | PRJNA770361 | 423 | 1337 | 3.84019 | 51.3433403 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 815 | 0 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g388 | i0 | 78.969 | 94.1039640987285 | 1203 | 245 | 90 | 7 | 38 | 1236 | 2 | 1200 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 125817 | 815 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 12225982 | 12225982 | PRJNA770361_P_NODE_13930_length_252_cov_1.307263_g13835_i0 | PRJNA770361 | 13930 | 252 | 1.307263 | 3.29430276 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 228 | 3.5399999999999984e-55 | NTclustered | gi|470377128|ref|XM_004333304.1| | 1257118 | g13835 | i0 | 83.2 | 4.95238095238095 | 250 | 40 | 99 | 2 | 4 | 252 | 327 | 79 | Acanthamoeba castellanii str. Neff glutathione S-transferase family protein, putative (ACA1_190760), partial mRNA | blastn | 1248 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19873260 | 19873260 | PRJNA770361_P_NODE_6936_length_356_cov_1.102473_g6841_i0 | PRJNA770361 | 6936 | 356 | 1.102473 | 3.92480388 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 182 | 1.66e-52 | NR | XP_004333784.1 | 1257118 | g6841 | i0 | 73.3 | 7.8623595505618 | 116 | 31 | 97.8 | 0 | 4 | 351 | 116 | 231 | XP_004333784.1 methylmalonatesemialdehyde dehydrogenase (acylating), putative [Acanthamoeba castellanii str. Neff] | diamond | 2799 | 182 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 23699408 | 23699408 | PRJNA770361_P_NODE_6659_length_363_cov_1.527586_g6564_i0 | PRJNA770361 | 6659 | 363 | 1.527586 | 5.54513718 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 161 | 4.22e-49 | NR | XP_004352812.1 | 1257118 | g6564 | i0 | 86.4 | 12.9834710743802 | 88 | 12 | 72.7 | 0 | 348 | 85 | 1 | 88 | XP_004352812.1 ribosomal L37ae protein family [Acanthamoeba castellanii str. Neff] | diamond | 4713 | 162 | 0.993827160493827 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27031149 | 27031149 | PRJNA770361_P_NODE_10342_length_293_cov_1.036364_g10247_i0 | PRJNA770361 | 10342 | 293 | 1.036364 | 3.03654652 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 155 | 1.92e-44 | NR | AFD36248.1 | 5755 | g10247 | i0 | 74.2 | 8.76450511945393 | 97 | 21 | 99.3 | 1 | 292 | 2 | 143 | 235 | AFD36248.1 protein kinase C19 [Acanthamoeba castellanii] | diamond | 2568 | 155 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27717044 | 27717044 | PRJNA770361_P_NODE_17064_length_246_cov_0.901734_g16969_i0 | PRJNA770361 | 17064 | 246 | 0.901734 | 2.21826564 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 48.5 | 1.4e-4 | NR | XP_004333326.1 | 1257118 | g16969 | i0 | 44.1 | 0.719512195121951 | 59 | 30 | 68.3 | 1 | 168 | 1 | 11 | 69 | XP_004333326.1 universal stress domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 177 | 48.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28032514 | 28032514 | PRJNA770361_P_NODE_15965_length_248_cov_0.891429_g15870_i0 | PRJNA770361 | 15965 | 248 | 0.891429 | 2.21074392 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 92.8 | 2.99e-20 | NR | XP_004341763.1 | 1257118 | g15870 | i0 | 70.7 | 2.70967741935484 | 75 | 22 | 90.7 | 0 | 241 | 17 | 178 | 252 | XP_004341763.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 672 | 92.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28727024 | 28727024 | PRJNA770361_P_NODE_15007_length_250_cov_0.881356_g14912_i0 | PRJNA770361 | 15007 | 250 | 0.881356 | 2.20339 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 50.8 | 5.64e-5 | NR | XP_004353416.1 | 1257118 | g14912 | i0 | 40 | 1.56 | 65 | 38 | 76.8 | 1 | 21 | 212 | 17 | 81 | XP_004353416.1 Activating signal cointegrator protein [Acanthamoeba castellanii str. Neff] | diamond | 390 | 50.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29137744 | 29137744 | PRJNA770361_P_NODE_7629_length_340_cov_1.168539_g7534_i0 | PRJNA770361 | 7629 | 340 | 1.168539 | 3.9730326 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 62.8 | 7.88e-9 | NR | XP_004347761.1 | 1257118 | g7534 | i0 | 40.2 | 0.988235294117647 | 112 | 61 | 98.8 | 4 | 337 | 2 | 1 | 106 | XP_004347761.1 iodothyronine deiodinase [Acanthamoeba castellanii str. Neff] | diamond | 336 | 62.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29642337 | 29642337 | PRJNA770361_P_NODE_17110_length_246_cov_0.901734_g17015_i0 | PRJNA770361 | 17110 | 246 | 0.901734 | 2.21826564 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 64.7 | 2.03e-10 | NR | XP_004368103.1 | 1257118 | g17015 | i0 | 40.2 | 1 | 82 | 44 | 100 | 1 | 246 | 1 | 57 | 133 | XP_004368103.1 HMG (high mobility group) box domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 246 | 64.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30021793 | 30021793 | PRJNA770361_P_NODE_16771_length_247_cov_0.896552_g16676_i0 | PRJNA770361 | 16771 | 247 | 0.896552 | 2.21448344 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 91.3 | 3.31e-19 | NR | XP_004337378.1 | 1257118 | g16676 | i0 | 57.3 | 0.995951417004049 | 82 | 35 | 99.6 | 0 | 247 | 2 | 131 | 212 | XP_004337378.1 Major Vault Protein repeatcontaining protein [Acanthamoeba castellanii str. Neff] | diamond | 246 | 91.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32392781 | 32392781 | PRJNA770361_P_NODE_15119_length_250_cov_0.881356_g15024_i0 | PRJNA770361 | 15119 | 250 | 0.881356 | 2.20339 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 110 | 1.11e-26 | NR | XP_004341586.1 | 1257118 | g15024 | i0 | 64.2 | 0.972 | 81 | 29 | 97.2 | 0 | 6 | 248 | 86 | 166 | XP_004341586.1 elongation factor 1-gamma family protein [Acanthamoeba castellanii str. Neff] | diamond | 243 | 110 | 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);;