contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 918969 | 918969 | PRJNA940501_S_NODE_20461_length_361_cov_2.144654_g19643_i0 | PRJNA940501 | 20461 | 361 | 2.144654 | 7.74220094 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 121 | 9.25e-23 | NTclustered | gi|831753332|ref|XM_012892328.1| | 1410327 | g19643 | i0 | 82.069 | 0.803324099722992 | 145 | 22 | 40 | 3 | 186 | 328 | 782 | 640 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 290 | 121 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 2196715 | 2196715 | PRJNA940501_S_NODE_43162_length_295_cov_9.638889_g42344_i0 | PRJNA940501 | 43162 | 295 | 9.638889 | 28.43472255 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 111 | 4.45e-20 | NTclustered | gi|470459156|ref|XM_004341277.1| | 1257118 | g42344 | i0 | 92.308 | 6.76271186440678 | 78 | 6 | 26 | 0 | 27 | 104 | 1089 | 1166 | Acanthamoeba castellanii str. Neff ribosomal protein L3, putative (ACA1_264110), partial mRNA | blastn | 1995 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 3468547 | 3468547 | PRJNA940501_S_NODE_116043_length_228_cov_1.778378_g115225_i0 | PRJNA940501 | 116043 | 228 | 1.778378 | 4.05470184 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|831759414|ref|XM_012894185.1| | 1410327 | g115225 | i0 | 100 | 1.00438596491228 | 29 | 0 | 13 | 0 | 52 | 80 | 109 | 81 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 229 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 3470854 | 3470854 | PRJNA940501_S_NODE_271083_length_173_cov_5.100000_g270265_i0 | PRJNA940501 | 271083 | 173 | 5.1 | 8.823 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 281 | 1.7e-71 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g270265 | i0 | 95.954 | 16.6531791907514 | 173 | 7 | 100 | 0 | 1 | 173 | 1109 | 937 | 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 | 2881 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 5086568 | 5086568 | PRJNA940501_S_NODE_385824_length_151_cov_1.740741_g385006_i0 | PRJNA940501 | 385824 | 151 | 1.740741 | 2.62851891 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 279 | 5.19e-71 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g385006 | i0 | 100 | 66.0132450331126 | 151 | 0 | 100 | 0 | 1 | 151 | 2779 | 2629 | 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 | 9968 | 279 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6023947 | 6023947 | PRJNA940501_S_NODE_342065_length_159_cov_1.215517_g341247_i0 | PRJNA940501 | 342065 | 159 | 1.215517 | 1.93267203 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 128 | 2.13e-25 | NTclustered | gi|330805165|ref|XM_003290509.1| | 5786 | g341247 | i0 | 83.942 | 4.72327044025157 | 137 | 18 | 85 | 3 | 9 | 143 | 445 | 579 | Dictyostelium purpureum NADH-ubiquinone oxidoreductase 23 kDa subunit (DICPUDRAFT_89000), partial mRNA | blastn | 751 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 11121216 | 11121216 | PRJNA940501_S_NODE_108409_length_232_cov_3.354497_g107591_i0 | PRJNA940501 | 108409 | 232 | 3.354497 | 7.78243304 | Clastoderma debaryanum | 137625 | Evosea | other_Eukaryota | 267 | 6.809999999999999e-67 | NTclustered | gi|385258608|gb|JF263592.1| | 137625 | g107591 | i0 | 88.889 | 92.0431034482759 | 216 | 24 | 93 | 0 | 17 | 232 | 241 | 26 | Clastoderma debaryanum elongation factor 1 alpha (EF-1alpha) gene, partial cds | blastn | 21354 | 267 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Clastodermataceae | Clastoderma | Clastoderma debaryanum | ||
| 11462183 | 11462183 | PRJNA940501_S_NODE_52909_length_281_cov_1.348739_g52091_i0 | PRJNA940501 | 52909 | 281 | 1.348739 | 3.78995659 | Trichiidae | 208472 | Evosea | other_Eukaryota | 76.8 | 1.54e-9 | NTclustered | gi|2250222277|gb|ON713379.1| | 647301 | g52091 | i0 | 92.453 | 5.66903914590747 | 53 | 4 | 19 | 0 | 1 | 53 | 1315 | 1367 | Trichia decipiens voucher MA83070 small subunit ribosomal RNA gene, partial sequence | blastn | 1593 | 76.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Trichia | Trichia decipiens | ||
| 11462217 | 11462217 | PRJNA940501_S_NODE_60389_length_271_cov_8.508772_g59571_i0 | PRJNA940501 | 60389 | 271 | 8.508772 | 23.05877212 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 5.34e-4 | NTclustered | gi|330791506|ref|XM_003283786.1| | 5786 | g59571 | i0 | 92.5 | 1.82656826568266 | 40 | 3 | 15 | 0 | 79 | 118 | 6288 | 6327 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45096), partial mRNA | blastn | 495 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 12400499 | 12400499 | PRJNA940501_S_NODE_40250_length_301_cov_1.457364_g39432_i0 | PRJNA940501 | 40250 | 301 | 1.457364 | 4.38666564 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|166240234|ref|XM_630671.2| | 352472 | g39432 | i0 | 92.308 | 0.59468438538206 | 39 | 1 | 12 | 2 | 1 | 37 | 101 | 63 | Dictyostelium discoideum AX4 RNase P protein subunit (drpp21) mRNA, complete cds | blastn | 179 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14950114 | 14950114 | PRJNA940501_S_NODE_8832_length_495_cov_18.805310_g8051_i0 | PRJNA940501 | 8832 | 495 | 18.80531 | 93.0862845 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 200 | 1.63e-46 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g8051 | i0 | 79.054 | 9.41818181818182 | 296 | 58 | 59 | 4 | 3 | 296 | 229 | 522 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 4662 | 200 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 17835281 | 17835281 | PRJNA940501_S_NODE_256954_length_177_cov_1.402985_g256136_i0 | PRJNA940501 | 256954 | 177 | 1.402985 | 2.48328345 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 3.21e-4 | NTclustered | gi|66805702|ref|XM_631481.1| | 352472 | g256136 | i0 | 90.698 | 1.32203389830508 | 43 | 4 | 24 | 0 | 97 | 139 | 671 | 713 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0288683) mRNA, complete cds | blastn | 234 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 21319599 | 21319599 | PRJNA940501_S_NODE_10557_length_457_cov_10.429952_g9759_i0 | PRJNA940501 | 10557 | 457 | 10.429952 | 47.66488064 | Vannellidae sp. | 2491907 | Discosea | other_Eukaryota | 226 | 2.4699999999999993e-54 | NTclustered | gi|1523769315|gb|MH535957.1| | 2491907 | g9759 | i0 | 80.769 | 39.6542669584245 | 312 | 41 | 67 | 14 | 112 | 419 | 699 | 403 | Vannellidae sp. strain 151-1SVA_C2 18S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18122 | 226 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannellidae sp. | ||||
| 21320387 | 21320387 | PRJNA940501_S_NODE_15377_length_395_cov_8.139205_g14563_i0 | PRJNA940501 | 15377 | 395 | 8.139205 | 32.14985975 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 189 | 2.7599999999999998e-43 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g14563 | i0 | 79.211 | 18.2 | 279 | 52 | 70 | 5 | 3 | 278 | 43 | 318 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 7189 | 189 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22596201 | 22596201 | PRJNA940501_S_NODE_218518_length_187_cov_1.812500_g217700_i0 | PRJNA940501 | 218518 | 187 | 1.8125 | 3.389375 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 207 | 3.23e-49 | NTclustered | gi|470455615|ref|XM_004340928.1| | 1257118 | g217700 | i0 | 86.631 | 8.19786096256684 | 187 | 25 | 100 | 0 | 1 | 187 | 369 | 183 | Acanthamoeba castellanii str. Neff ribosomal protein S23 (S12), putative (ACA1_232480), partial mRNA | blastn | 1533 | 207 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 23870847 | 23870847 | PRJNA940501_S_NODE_16099_length_389_cov_3.592486_g15284_i0 | PRJNA940501 | 16099 | 389 | 3.592486 | 13.97477054 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 228 | 5.749999999999998e-55 | NTclustered | gi|262262917|gb|FJ766460.1| | 472931 | g15284 | i0 | 83.665 | 39.0282776349614 | 251 | 31 | 63 | 6 | 143 | 389 | 709 | 953 | Protostelium mycophagum strain PRA-128 small subunit ribosomal RNA gene, partial sequence | blastn | 15182 | 228 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 23871183 | 23871183 | PRJNA940501_S_NODE_182099_length_199_cov_1.320513_g181281_i0 | PRJNA940501 | 182099 | 199 | 1.320513 | 2.62782087 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 305 | 1.2e-78 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g181281 | i0 | 98.276 | 87.8643216080402 | 174 | 3 | 87 | 0 | 26 | 199 | 2274 | 2447 | 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 | 17485 | 305 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 25145591 | 25145591 | PRJNA940501_S_NODE_226200_length_185_cov_1.387324_g225382_i0 | PRJNA940501 | 226200 | 185 | 1.387324 | 2.5665494 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 309 | 8.49e-80 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g225382 | i0 | 96.757 | 1 | 185 | 6 | 100 | 0 | 1 | 185 | 1531 | 1347 | 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 | 185 | 309 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 25484947 | 25484947 | PRJNA940501_S_NODE_53900_length_279_cov_5.072034_g53082_i0 | PRJNA940501 | 53900 | 279 | 5.072034 | 14.15097486 | Trichiida | 208471 | Evosea | other_Eukaryota | 219 | 2.3899999999999993e-52 | NTclustered | gi|2250222240|gb|ON713360.1| | 1334559 | g53082 | i0 | 85 | 43.8673835125448 | 220 | 28 | 78 | 5 | 4 | 222 | 1485 | 1270 | Prototrichia metallica voucher MA80049 small subunit ribosomal RNA gene, partial sequence | blastn | 12239 | 220 | 0.995454545454545 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Prototrichia | Prototrichia metallica |
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);;