contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370615 | 370615 | PRJNA274362_S_NODE_26541_length_183_cov_1.798507_g26421_i0 | PRJNA274362 | 26541 | 183 | 1.798507 | 3.29126781 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 263 | 6.61e-66 | NTclustered | gi|330799499|ref|XM_003287734.1| | 5786 | g26421 | i0 | 93.714 | 97.2677595628415 | 175 | 11 | 96 | 0 | 3 | 177 | 263 | 89 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72359), partial mRNA | blastn | 17800 | 263 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 370636 | 370636 | PRJNA274362_S_NODE_2741_length_494_cov_3.323596_g2623_i0 | PRJNA274362 | 2741 | 494 | 3.323596 | 16.41856424 | Entamoeba suis | 359305 | Evosea | other_Eukaryota | 444 | 6.81e-120 | NTclustered | gi|731174162|dbj|AB914741.1| | 359305 | g2623 | i0 | 83.368 | 98.9392712550607 | 487 | 74 | 98 | 7 | 1 | 484 | 243 | 725 | Entamoeba suis gene for actin, partial cds, isolate: Sa-69 | blastn | 48876 | 444 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba suis | |||
| 4197523 | 4197523 | PRJNA274362_S_NODE_16684_length_222_cov_1.202312_g16564_i0 | PRJNA274362 | 16684 | 222 | 1.202312 | 2.66913264 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 379 | 7.949999999999998e-101 | NTclustered | gi|1269228471|gb|MF683596.1| | 2047823 | g16564 | i0 | 97.738 | 99.8828828828829 | 221 | 3 | 99 | 2 | 1 | 219 | 1297 | 1517 | Ripella tribonemae clone 22.1.14 18S ribosomal RNA gene, partial sequence | blastn | 22174 | 379 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 4197583 | 4197583 | PRJNA274362_S_NODE_19384_length_209_cov_0.943750_g19264_i0 | PRJNA274362 | 19384 | 209 | 0.94375 | 1.9724375 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 250 | 6.05e-62 | NTclustered | gi|66805384|ref|XM_631333.1| | 352472 | g19264 | i0 | 88.406 | 96.6172248803828 | 207 | 24 | 99 | 0 | 1 | 207 | 1119 | 913 | Dictyostelium discoideum AX4 hypothetical protein (act4) mRNA, complete cds | blastn | 20193 | 250 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5473668 | 5473668 | PRJNA274362_S_NODE_11605_length_258_cov_3.674641_g11485_i0 | PRJNA274362 | 11605 | 258 | 3.674641 | 9.48057378 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 353 | 5.749999999999998e-93 | NTclustered | gi|66804710|ref|XM_630996.1| | 352472 | g11485 | i0 | 91.732 | 96.7403100775194 | 254 | 21 | 98 | 0 | 3 | 256 | 652 | 905 | Dictyostelium discoideum AX4 hypothetical protein (act5) mRNA, complete cds | blastn | 24959 | 353 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5473875 | 5473875 | PRJNA274362_S_NODE_21145_length_201_cov_6.480263_g21025_i0 | PRJNA274362 | 21145 | 201 | 6.480263 | 13.02532863 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 267 | 5.73e-67 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g21025 | i0 | 90.547 | 95.4129353233831 | 201 | 19 | 100 | 0 | 1 | 201 | 860 | 660 | Platyamoeba placida actin mRNA, partial cds | blastn | 19178 | 267 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 8024165 | 8024165 | PRJNA274362_S_NODE_35867_length_164_cov_0.904348_g35747_i0 | PRJNA274362 | 35867 | 164 | 0.904348 | 1.48313072 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 143 | 7.9e-30 | NTclustered | gi|470521480|ref|XM_004353671.1| | 1257118 | g35747 | i0 | 82.317 | 27.530487804878 | 164 | 29 | 100 | 0 | 1 | 164 | 316 | 153 | Acanthamoeba castellanii str. Neff 60S ribosomal protein L27a, putative (ACA1_376690), partial mRNA | blastn | 4515 | 143 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10574637 | 10574637 | PRJNA274362_S_NODE_27329_length_181_cov_1.181818_g27209_i0 | PRJNA274362 | 27329 | 181 | 1.181818 | 2.13909058 | Diacheopsis resinae | 3092648 | Evosea | other_Eukaryota | 200 | 5.19e-47 | NTclustered | gi|2727873016|gb|OR778661.1| | 3092648 | g27209 | i0 | 88.024 | 92.2375690607735 | 167 | 18 | 92 | 2 | 1 | 166 | 497 | 662 | Diacheopsis sp. OShchepin-2023a voucher LK-zV4186 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 16695 | 200 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Diacheopsis | Diacheopsis resinae | |||
| 11849183 | 11849183 | PRJNA274362_S_NODE_23030_length_194_cov_5.020690_g22910_i0 | PRJNA274362 | 23030 | 194 | 5.02069 | 9.7401386 | Diachea mitchellii | 2928464 | Evosea | other_Eukaryota | 254 | 4.28e-63 | NTclustered | gi|2574169345|gb|OP630987.1| | 2928464 | g22910 | i0 | 90.256 | 98.2680412371134 | 195 | 17 | 100 | 2 | 1 | 194 | 875 | 682 | Diachea mitchellii strain MA-Fungi 96407 alpha-tubulin (aTUB) gene, partial cds | blastn | 19064 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Diachea | Diachea mitchellii | ||
| 11849205 | 11849205 | PRJNA274362_S_NODE_24210_length_191_cov_0.964789_g24090_i0 | PRJNA274362 | 24210 | 191 | 0.964789 | 1.84274699 | Flabellula sp. SBGL1 | 1215617 | Tubulinea | other_Eukaryota | 191 | 3.34e-44 | NTclustered | gi|1475408521|dbj|LC341034.1| | 1215617 | g24090 | i0 | 86.286 | 96.2198952879581 | 175 | 24 | 92 | 0 | 15 | 189 | 482 | 656 | Flabellula sp. SBGL1 gene for actin, partial cds, clone: 4 | blastn | 18378 | 191 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Flabellula | Flabellula sp. SBGL1 | ||
| 11849233 | 11849233 | PRJNA274362_S_NODE_25510_length_186_cov_3.802920_g25390_i0 | PRJNA274362 | 25510 | 186 | 3.80292 | 7.0734312 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 252 | 1.46e-62 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g25390 | i0 | 91.713 | 95.0322580645161 | 181 | 15 | 97 | 0 | 6 | 186 | 333 | 513 | Platyamoeba placida actin mRNA, partial cds | blastn | 17676 | 252 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 15086209 | 15086209 | PRJNA274362_S_NODE_31172_length_171_cov_0.991803_g31052_i0 | PRJNA274362 | 31172 | 171 | 0.991803 | 1.69598313 | Didymium | 5792 | Evosea | other_Eukaryota | 174 | 2.93e-39 | NTclustered | gi|2049856602|gb|MG963730.1| | 289976 | g31052 | i0 | 88.356 | 84.8479532163743 | 146 | 16 | 85 | 1 | 1 | 145 | 504 | 649 | Didymium clavus strain MA-Fungi 51663 alpha-tubulin (a-Tub) gene, partial cds | blastn | 14509 | 174 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium clavus | ||
| 15673662 | 15673662 | PRJNA274362_S_NODE_9453_length_281_cov_4.978448_g9333_i0 | PRJNA274362 | 9453 | 281 | 4.978448 | 13.98943888 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 444 | 3.66e-120 | NTclustered | gi|1269228436|gb|MF683561.1| | 2047822 | g9333 | i0 | 95.374 | 100.555160142349 | 281 | 9 | 100 | 4 | 1 | 281 | 394 | 118 | Ripella decalvata clone 26.2.18 18S ribosomal RNA gene, partial sequence | blastn | 28256 | 444 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 18222401 | 18222401 | PRJNA274362_S_NODE_30515_length_172_cov_1.650407_g30395_i0 | PRJNA274362 | 30515 | 172 | 1.650407 | 2.83870004 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 222 | 1.04e-53 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g30395 | i0 | 100 | 81.6860465116279 | 120 | 0 | 70 | 0 | 53 | 172 | 683 | 564 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 14050 | 222 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 18222412 | 18222412 | PRJNA274362_S_NODE_31135_length_171_cov_1.122951_g31015_i0 | PRJNA274362 | 31135 | 171 | 1.122951 | 1.92024621 | Filamoeba nolandi | 136452 | Evosea | other_Eukaryota | 161 | 2.28e-35 | NTclustered | gi|146448849|gb|EF513192.1| | 136452 | g31015 | i0 | 86 | 81.7426900584795 | 150 | 21 | 88 | 0 | 15 | 164 | 538 | 687 | Filamoeba nolandi elongation factor 1A (EF1A) gene, partial cds | blastn | 13978 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba nolandi | ||||
| 20771961 | 20771961 | PRJNA274362_S_NODE_21057_length_202_cov_1.052288_g20937_i0 | PRJNA274362 | 21057 | 202 | 1.052288 | 2.12562176 | Amoebozoa sp. SZA28 | 688090 | Root_unresolved | Root_unresolved | 182 | 2.15e-41 | NTclustered | gi|406717743|emb|HE598749.1| | 688090 | g20937 | i0 | 88.591 | 75.4009900990099 | 149 | 17 | 74 | 0 | 1 | 149 | 888 | 740 | Amoebozoa sp. SZA 28 partial actin gene, isolate SZA 28 | blastn | 15231 | 182 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. SZA28 | |||||||
| 24596653 | 24596653 | PRJNA274362_S_NODE_22800_length_195_cov_1.753425_g22680_i0 | PRJNA274362 | 22800 | 195 | 1.753425 | 3.41917875 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|470406023|ref|XM_004335858.1| | 1257118 | g22680 | i0 | 100 | 3.45128205128205 | 29 | 0 | 15 | 0 | 167 | 195 | 1058 | 1086 | Acanthamoeba castellanii str. Neff Poly(ADPribose) polymerase catalytic domain containing protein (ACA1_364190), partial mRNA | blastn | 673 | 54.7 | 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);;