contig_metadata
8 rows where bioproject = "PRJNA789095" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 771488 | 771488 | PRJNA789095_P_NODE_70141_length_247_cov_0.879310_g68807_i0 | PRJNA789095 | 70141 | 247 | 0.87931 | 2.1718957 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 171 | 6.46e-51 | NR | PRP73904.1 | 1890364 | g68807 | i0 | 92.6 | 0.983805668016194 | 81 | 6 | 98.4 | 0 | 3 | 245 | 147 | 227 | PRP73904.1 protein phosphatase 6 catalytic subunit [Planoprotostelium fungivorum] | diamond | 243 | 171 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 16074005 | 16074005 | PRJNA789095_P_NODE_68893_length_248_cov_0.880000_g67559_i0 | PRJNA789095 | 68893 | 248 | 0.88 | 2.1824 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 182 | 2.74e-41 | NTclustered | gi|330799393|ref|XM_003287682.1| | 5786 | g67559 | i0 | 79.839 | 1.8508064516129 | 248 | 50 | 100 | 0 | 1 | 248 | 266 | 513 | Dictyostelium purpureum 40S ribosomal protein S2 (DICPUDRAFT_32959), partial mRNA | blastn | 459 | 182 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27938242 | 27938242 | PRJNA789095_P_NODE_67105_length_250_cov_0.870056_g65771_i0 | PRJNA789095 | 67105 | 250 | 0.870056 | 2.17514 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 87.4 | 7.93e-18 | NR | KAH3766259.1 | 1580589 | g65771 | i0 | 55 | 0.96 | 80 | 35 | 94.8 | 1 | 247 | 11 | 1417 | 1496 | KAH3766259.1 Rho guanine nucleotide exchange factor 17 [Pelomyxa schiedti] | diamond | 240 | 87.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29043404 | 29043404 | PRJNA789095_P_NODE_66888_length_250_cov_0.870056_g65554_i0 | PRJNA789095 | 66888 | 250 | 0.870056 | 2.17514 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 79.7 | 2.3e-15 | NR | XP_638196.1 | 352472 | g65554 | i0 | 57.1 | 0.756 | 63 | 27 | 75.6 | 0 | 193 | 5 | 4 | 66 | XP_638196.1 G-protein subunit alpha 4 [Dictyostelium discoideum AX4] | diamond | 189 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 29705836 | 29705836 | PRJNA789095_P_NODE_36450_length_337_cov_1.166667_g35116_i0 | PRJNA789095 | 36450 | 337 | 1.166667 | 3.93166779 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 98.2 | 1.1699999999999997e-23 | NR | XP_004348720.1 | 1257118 | g35116 | i0 | 48.2 | 0.997032640949555 | 112 | 52 | 98.8 | 2 | 336 | 4 | 23 | 129 | XP_004348720.1 actin binding protein [Acanthamoeba castellanii str. Neff] | diamond | 336 | 98.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29905133 | 29905133 | PRJNA789095_P_NODE_64131_length_254_cov_2.657459_g62797_i0 | PRJNA789095 | 64131 | 254 | 2.657459 | 6.74994586 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 4.28e-5 | NR | AOW71831.1 | 435410 | g62797 | i0 | 45.9 | 4.21653543307087 | 61 | 31 | 69.7 | 2 | 1 | 177 | 411 | 471 | AOW71831.1 bacterial recombinase A, partial [Cavostelium apophysatum] | diamond | 1071 | 51.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Cavostelium | Cavostelium apophysatum | ||
| 31033473 | 31033473 | PRJNA789095_P_NODE_74015_length_243_cov_0.905882_g72681_i0 | PRJNA789095 | 74015 | 243 | 0.905882 | 2.20129326 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 129 | 3.62e-35 | NR | AKT93937.1 | 5778 | g72681 | i0 | 80 | 1.93827160493827 | 80 | 16 | 98.8 | 0 | 2 | 241 | 111 | 190 | AKT93937.1 ribosomal protein L2 [Vermamoeba vermiformis] | diamond | 471 | 129 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32875537 | 32875537 | PRJNA789095_P_NODE_66100_length_251_cov_0.865169_g64766_i0 | PRJNA789095 | 66100 | 251 | 0.865169 | 2.17157419 | root | 1 | Root_unresolved | Root_unresolved | 126 | 9.869999999999998e-32 | NR | XP_004338070.1 | 1257118 | g64766 | i0 | 69.5 | 5.92828685258964 | 82 | 25 | 98 | 0 | 250 | 5 | 191 | 272 | XP_004338070.1 1pyrroline-5-carboxylate dehydrogenase [Acanthamoeba castellanii str. Neff] | diamond | 1488 | 126 | 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);;