contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1664435 | 1664435 | PRJNA330616_P_NODE_27702_length_165_cov_0.879310_g27293_i0 | PRJNA330616 | 27702 | 165 | 0.87931 | 1.4508615 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 87.9 | 3.78e-13 | NTclustered | gi|831790587|ref|XM_012903983.1| | 1410327 | g27293 | i0 | 80 | 0.787878787878788 | 130 | 16 | 76 | 7 | 41 | 165 | 1139 | 1015 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 130 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 2940503 | 2940503 | PRJNA330616_P_NODE_5003_length_378_cov_2.325228_g4594_i0 | PRJNA330616 | 5003 | 378 | 2.325228 | 8.78936184 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 688 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4594 | i0 | 99.471 | 26.6243386243386 | 378 | 2 | 100 | 0 | 1 | 378 | 1214 | 1591 | Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 10064 | 688 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5493126 | 5493126 | PRJNA330616_P_NODE_1665_length_705_cov_22.914634_g1298_i0 | PRJNA330616 | 1665 | 705 | 22.914634 | 161.5481697 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 357 | 1.33e-93 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g1298 | i0 | 80.658 | 33.4567375886525 | 486 | 72 | 68 | 20 | 152 | 629 | 472 | 1 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 23587 | 357 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 5493253 | 5493253 | PRJNA330616_P_NODE_24285_length_171_cov_2.000000_g23876_i0 | PRJNA330616 | 24285 | 171 | 2 | 3.42 | Stemonitopsis subcaespitosa | 1048528 | Evosea | other_Eukaryota | 235 | 1.3199999999999998e-57 | NTclustered | gi|426281760|gb|JX681133.1| | 1048528 | g23876 | i0 | 91.716 | 98.9239766081871 | 169 | 14 | 99 | 0 | 3 | 171 | 800 | 632 | Stemonitopsis subcaespitosa actin gene, partial cds | blastn | 16916 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Stemonitopsis | Stemonitopsis subcaespitosa | ||
| 7447207 | 7447207 | PRJNA330616_P_NODE_21066_length_184_cov_1.511111_g20657_i0 | PRJNA330616 | 21066 | 184 | 1.511111 | 2.78044424 | Planopodium | 2823620 | Discosea | other_Eukaryota | 340 | 2.99e-89 | NTclustered | gi|330902850|gb|JF298244.1| | 2773111 | g20657 | i0 | 100 | 62.6467391304348 | 184 | 0 | 100 | 0 | 1 | 184 | 990 | 807 | Ovalopodium desertum clone 3702 18S ribosomal RNA gene, partial sequence | blastn | 11527 | 340 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Planopodium | Planopodium desertum | |||
| 8721896 | 8721896 | PRJNA330616_P_NODE_2147_length_617_cov_2.813380_g1754_i0 | PRJNA330616 | 2147 | 617 | 2.81338 | 17.3585546 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 130 | 2.75e-25 | NTclustered | gi|28194602|gb|AF479546.1| | 65658 | g1754 | i0 | 76.735 | 10.6385737439222 | 245 | 49 | 39 | 7 | 195 | 435 | 922 | 682 | Acanthamoeba astronyxis strain ATCC 30137 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 6564 | 130 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba astronyxis | |||
| 9997632 | 9997632 | PRJNA330616_P_NODE_828_length_1050_cov_15.271728_g560_i0 | PRJNA330616 | 828 | 1050 | 15.271728 | 160.353144 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 1881 | 0 | NTclustered | gi|441475833|emb|FN562425.4| | 688089 | g560 | i0 | 98.95 | 34.4419047619048 | 1048 | 11 | 99 | 0 | 3 | 1050 | 1061 | 14 | Amoebozoa sp. SZA36 18S rRNA gene, isolate SZA36 | blastn | 36164 | 1892 | 0.994186046511628 | Eukaryota | Amoebozoa | Amoebozoa sp. SZA36 | |||||||
| 10593281 | 10593281 | PRJNA330616_P_NODE_15889_length_210_cov_1.267081_g15480_i0 | PRJNA330616 | 15889 | 210 | 1.267081 | 2.6608701 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 366 | 5.7900000000000005e-97 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g15480 | i0 | 98.095 | 86.5666666666667 | 210 | 4 | 100 | 0 | 1 | 210 | 19499 | 19290 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 18179 | 366 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10593453 | 10593453 | PRJNA330616_P_NODE_27489_length_165_cov_1.318966_g27080_i0 | PRJNA330616 | 27489 | 165 | 1.318966 | 2.1762939 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 244 | 2.12e-60 | NTclustered | gi|330902858|gb|JF298255.1| | 1017091 | g27080 | i0 | 93.976 | 13.6666666666667 | 166 | 3 | 100 | 5 | 1 | 165 | 762 | 921 | Cochliopodium larifeili clone 904 18S ribosomal RNA gene, partial sequence | blastn | 2255 | 244 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 11868233 | 11868233 | PRJNA330616_P_NODE_17270_length_202_cov_1.228758_g16861_i0 | PRJNA330616 | 17270 | 202 | 1.228758 | 2.48209116 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 97.1 | 8.01e-16 | NTclustered | gi|330822615|ref|XM_003291697.1| | 5786 | g16861 | i0 | 83.019 | 0.787128712871287 | 106 | 18 | 52 | 0 | 33 | 138 | 771 | 876 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_39483), partial mRNA | blastn | 159 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 11868327 | 11868327 | PRJNA330616_P_NODE_24330_length_171_cov_1.672131_g23921_i0 | PRJNA330616 | 24330 | 171 | 1.672131 | 2.85934401 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 132 | 1.79e-26 | NTclustered | gi|831767714|ref|XM_012896732.1| | 1410327 | g23921 | i0 | 82.877 | 6.63157894736842 | 146 | 25 | 85 | 0 | 26 | 171 | 822 | 677 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 1134 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 13143410 | 13143410 | PRJNA330616_P_NODE_5771_length_349_cov_3.393333_g5362_i0 | PRJNA330616 | 5771 | 349 | 3.393333 | 11.84273217 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 612 | 1.21e-170 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g5362 | i0 | 98.555 | 24.6848137535817 | 346 | 5 | 99 | 0 | 4 | 349 | 7086 | 6741 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 8615 | 612 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15097168 | 15097168 | PRJNA330616_P_NODE_20232_length_187_cov_2.768116_g19823_i0 | PRJNA330616 | 20232 | 187 | 2.768116 | 5.17637692 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 335 | 1.4199999999999996e-87 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g19823 | i0 | 98.93 | 6.20855614973262 | 187 | 2 | 100 | 0 | 1 | 187 | 1144 | 958 | Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1161 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16967162 | 16967162 | PRJNA330616_P_NODE_31594_length_161_cov_28.339286_g31185_i0 | PRJNA330616 | 31594 | 161 | 28.339286 | 45.62625046 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 278 | 2.03e-70 | NTclustered | gi|1040460865|dbj|LC159244.1| | 44689 | g31185 | i0 | 100 | 65.4347826086957 | 150 | 0 | 93 | 0 | 12 | 161 | 354 | 205 | Dictyostelium discoideum genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 26S rRNA, partial and complete sequence, strain: WS-18 | blastn | 10535 | 278 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19515669 | 19515669 | PRJNA330616_P_NODE_31316_length_162_cov_0.902655_g30907_i0 | PRJNA330616 | 31316 | 162 | 0.902655 | 1.4623011 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 137 | 3.6199999999999997e-28 | NTclustered | gi|330795499|ref|XM_003285763.1| | 5786 | g30907 | i0 | 85.496 | 2.2716049382716 | 131 | 19 | 81 | 0 | 30 | 160 | 1918 | 2048 | Dictyostelium purpureum P-type ATPase (DICPUDRAFT_149704), partial mRNA | blastn | 368 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 19515674 | 19515674 | PRJNA330616_P_NODE_31536_length_162_cov_0.902655_g31127_i0 | PRJNA330616 | 31536 | 162 | 0.902655 | 1.4623011 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 130 | 6.05e-26 | NTclustered | gi|470239817|ref|XM_004351826.1| | 261658 | g31127 | i0 | 86.441 | 74.0617283950617 | 118 | 16 | 73 | 0 | 16 | 133 | 554 | 437 | Cavenderia fasciculata glyceraldehyde-3-phosphate dehydrogenase (gpdA), partial mRNA | blastn | 11998 | 130 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 20791203 | 20791203 | PRJNA330616_P_NODE_26477_length_166_cov_1.307692_g26068_i0 | PRJNA330616 | 26477 | 166 | 1.307692 | 2.17076872 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 154 | 3.699999999999999e-33 | NTclustered | gi|1160573212|ref|XM_020576784.1| | 670386 | g26068 | i0 | 87.879 | 19.2168674698795 | 132 | 14 | 79 | 2 | 2 | 132 | 131 | 1 | Polysphondylium pallidum PN500 calmodulin (calA), partial mRNA | blastn | 3190 | 154 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 22746260 | 22746260 | PRJNA330616_P_NODE_24478_length_170_cov_29.809917_g24069_i0 | PRJNA330616 | 24478 | 170 | 29.809917 | 50.6768589 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 8.32e-20 | NTclustered | gi|62865955|gb|AY929930.1| | 325074 | g24069 | i0 | 91.358 | 49.2235294117647 | 81 | 6 | 47 | 1 | 69 | 148 | 305 | 225 | Vannella sp. strain 4354/I internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 8368 | 110 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4354/I | |||
| 24615760 | 24615760 | PRJNA330616_P_NODE_20860_length_185_cov_1.463235_g20451_i0 | PRJNA330616 | 20860 | 185 | 1.463235 | 2.70698475 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 263 | 6.7e-66 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g20451 | i0 | 92.391 | 99.5243243243243 | 184 | 14 | 99 | 0 | 2 | 185 | 137 | 320 | Platyamoeba placida actin mRNA, partial cds | blastn | 18412 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida |
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);;