contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA771359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 747028 | 747028 | PRJNA771359_S_NODE_2361_length_218_cov_2.867403_g2278_i0 | PRJNA771359 | 2361 | 218 | 2.867403 | 6.25093854 | Paramoeba aparasomata | 2583407 | Discosea | other_Eukaryota | 287 | 4.85e-73 | NTclustered | gi|1767098935|gb|MK518072.1| | 2583407 | g2278 | i0 | 91.787 | 27.0275229357798 | 207 | 16 | 94 | 1 | 13 | 218 | 15258 | 15464 | Paramoeba aparasomata mitochondrion, complete genome | blastn | 5892 | 287 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba aparasomata | ||
| 747051 | 747051 | PRJNA771359_S_NODE_3841_length_171_cov_7.761194_g3758_i0 | PRJNA771359 | 3841 | 171 | 7.761194 | 13.27164174 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 250 | 4.73e-62 | NTclustered | gi|470237391|ref|XM_004350602.1| | 261658 | g3758 | i0 | 92.982 | 99.9239766081871 | 171 | 12 | 100 | 0 | 1 | 171 | 393 | 223 | Cavenderia fasciculata actin (DFA_11706), partial mRNA | blastn | 17087 | 250 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 747078 | 747078 | PRJNA771359_S_NODE_5181_length_151_cov_1.052632_g5098_i0 | PRJNA771359 | 5181 | 151 | 1.052632 | 1.58947432 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 248 | 1.46e-61 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g5098 | i0 | 100 | 87.953642384106 | 134 | 0 | 89 | 0 | 18 | 151 | 1396 | 1529 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 13281 | 248 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 3298236 | 3298236 | PRJNA771359_S_NODE_2483_length_212_cov_5.502857_g2400_i0 | PRJNA771359 | 2483 | 212 | 5.502857 | 11.66605684 | Vannella sp. strain 4354/I | 325074 | Discosea | other_Eukaryota | 387 | 4.5e-103 | NTclustered | gi|62865936|gb|AY929911.1| | 325074 | g2400 | i0 | 99.528 | 100.533018867925 | 212 | 1 | 100 | 0 | 1 | 212 | 1803 | 1592 | Vannella sp. strain 4354/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 21313 | 387 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4354/I | |||
| 4575319 | 4575319 | PRJNA771359_S_NODE_2984_length_194_cov_1.949045_g2901_i0 | PRJNA771359 | 2984 | 194 | 1.949045 | 3.7811473 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 111 | 2.72e-20 | NTclustered | gi|421976300|gb|JQ519406.1| | 5778 | g2901 | i0 | 87.5 | 2.85051546391753 | 96 | 12 | 49 | 0 | 17 | 112 | 36 | 131 | Vermamoeba vermiformis clone JG10.126_a3c3b3 14-3-3 protein gene, partial cds | blastn | 553 | 111 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5035091 | 5035091 | PRJNA771359_S_NODE_2944_length_195_cov_2.069620_g2861_i0 | PRJNA771359 | 2944 | 195 | 2.06962 | 4.035759 | Flamella | 490353 | Evosea | other_Eukaryota | 359 | 8.87e-95 | NTclustered | gi|163943979|gb|EU186023.1| | 490516 | g2861 | i0 | 100 | 99.4923076923077 | 194 | 0 | 99 | 0 | 2 | 195 | 928 | 735 | Flamella balnearia 18S ribosomal RNA gene, partial sequence | blastn | 19401 | 359 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella balnearia | |||
| 5850584 | 5850584 | PRJNA771359_S_NODE_2925_length_195_cov_22.924051_g2842_i0 | PRJNA771359 | 2925 | 195 | 22.924051 | 44.70189945 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 327 | 2.5e-85 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g2842 | i0 | 96.923 | 100.466666666667 | 195 | 6 | 100 | 0 | 1 | 195 | 3821 | 3627 | Vannella septentrionalis 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 | 19591 | 327 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 6310790 | 6310790 | PRJNA771359_S_NODE_3465_length_180_cov_49.482517_g3382_i0 | PRJNA771359 | 3465 | 180 | 49.482517 | 89.0685306 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 294 | 2.3e-75 | NTclustered | gi|62865954|gb|AY929929.1| | 325076 | g3382 | i0 | 96.133 | 81.9611111111111 | 181 | 5 | 100 | 2 | 1 | 180 | 388 | 209 | Vannella sp. strain 4432/I internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 14753 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4432/I | |||
| 12226768 | 12226768 | PRJNA771359_S_NODE_470_length_449_cov_25.075243_g387_i0 | PRJNA771359 | 470 | 449 | 25.075243 | 112.58784107 | Vannella sp. ECH30 | 1215635 | Discosea | other_Eukaryota | 808 | 0 | NTclustered | gi|399764220|gb|JQ271731.1| | 1215635 | g387 | i0 | 99.109 | 97.1581291759465 | 449 | 4 | 100 | 0 | 1 | 449 | 635 | 1083 | Vannella sp. ECH30 18S ribosomal RNA gene, partial sequence | blastn | 43624 | 808 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ECH30 | |||
| 13500791 | 13500791 | PRJNA771359_S_NODE_3651_length_176_cov_1.381295_g3568_i0 | PRJNA771359 | 3651 | 176 | 1.381295 | 2.4310792 | Vannella danica | 703018 | Discosea | other_Eukaryota | 191 | 3.02e-44 | NTclustered | gi|284808943|gb|GQ354159.1| | 703018 | g3568 | i0 | 86.705 | 96.3636363636364 | 173 | 22 | 98 | 1 | 2 | 174 | 55 | 226 | Vannella danica strain CCAP 1589/17 clone A135.1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 16960 | 191 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella danica | |||
| 13500799 | 13500799 | PRJNA771359_S_NODE_4291_length_163_cov_2.912698_g4208_i0 | PRJNA771359 | 4291 | 163 | 2.912698 | 4.7476977400000004 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 161 | 2.16e-35 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g4208 | i0 | 84.659 | 152.20245398773 | 176 | 11 | 98 | 5 | 2 | 161 | 33432 | 33257 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 24809 | 161 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 14775922 | 14775922 | PRJNA771359_S_NODE_2232_length_224_cov_1.780749_g2149_i0 | PRJNA771359 | 2232 | 224 | 1.780749 | 3.98887776 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 141 | 4.13e-29 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g2149 | i0 | 78.879 | 10.9196428571429 | 232 | 32 | 99 | 14 | 1 | 221 | 32081 | 32306 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 2446 | 141 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 16049612 | 16049612 | PRJNA771359_S_NODE_1093_length_318_cov_3.419929_g1010_i0 | PRJNA771359 | 1093 | 318 | 3.419929 | 10.87537422 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 438 | 1.9599999999999992e-118 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g1010 | i0 | 91.536 | 95.1918238993711 | 319 | 26 | 100 | 1 | 1 | 318 | 1055 | 737 | Platyamoeba placida actin mRNA, partial cds | blastn | 30271 | 438 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 17325391 | 17325391 | PRJNA771359_S_NODE_4214_length_164_cov_5.440945_g4131_i0 | PRJNA771359 | 4214 | 164 | 5.440945 | 8.9231498 | Vannella sp. strain 4362V/II | 325075 | Discosea | other_Eukaryota | 287 | 3.45e-73 | NTclustered | gi|62865934|gb|AY929909.1| | 325075 | g4131 | i0 | 98.171 | 101.323170731707 | 164 | 3 | 100 | 0 | 1 | 164 | 1088 | 1251 | Vannella sp. strain 4362V/II 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16617 | 287 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4362V/II | |||
| 18598829 | 18598829 | PRJNA771359_S_NODE_635_length_390_cov_3.269122_g552_i0 | PRJNA771359 | 635 | 390 | 3.269122 | 12.7495758 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 243 | 2.06e-59 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g552 | i0 | 80.308 | 77.0589743589744 | 325 | 60 | 83 | 4 | 68 | 390 | 53109 | 52787 | Paravannella minima mitochondrion, complete genome | blastn | 30053 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 24973668 | 24973668 | PRJNA771359_S_NODE_3820_length_172_cov_1.459259_g3737_i0 | PRJNA771359 | 3820 | 172 | 1.459259 | 2.50992548 | Paramoeba aparasomata | 2583407 | Discosea | other_Eukaryota | 147 | 6.429999999999999e-31 | NTclustered | gi|1767098935|gb|MK518072.1| | 2583407 | g3737 | i0 | 84.314 | 0.88953488372093 | 153 | 21 | 87 | 3 | 21 | 170 | 14854 | 14702 | Paramoeba aparasomata mitochondrion, complete genome | blastn | 153 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba aparasomata | ||
| 24973679 | 24973679 | PRJNA771359_S_NODE_4320_length_163_cov_1.230159_g4237_i0 | PRJNA771359 | 4320 | 163 | 1.230159 | 2.00515917 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 62.1 | 2.26e-5 | NTclustered | gi|1160575580|ref|XM_020582530.1| | 670386 | g4237 | i0 | 85.246 | 1.23312883435583 | 61 | 7 | 37 | 2 | 52 | 111 | 448 | 507 | Polysphondylium pallidum PN500 S60 ribosomal protein L34 (rpl34), partial mRNA | blastn | 201 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;