contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3718454 | 3718454 | PRJNA674308_P_NODE_9063_length_316_cov_2.520599_g8828_i0 | PRJNA674308 | 9063 | 316 | 2.520599 | 7.96509284 | Entamoeba | 5758 | Evosea | other_Eukaryota | 183 | 1.01e-41 | NTclustered | gi|158940|gb|L02417.1|ENHEF2 | 5759 | g8828 | i0 | 85.475 | 4.94620253164557 | 179 | 22 | 56 | 4 | 119 | 295 | 464 | 288 | Entamoeba histolytica translation elongation factor-2 (EF-2) mRNA, complete cds | blastn | 1563 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 9573210 | 9573210 | PRJNA674308_P_NODE_2468_length_624_cov_18.902609_g2245_i0 | PRJNA674308 | 2468 | 624 | 18.902609000000002 | 117.95228016 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 944 | 0 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g2245 | i0 | 96.213 | 59.2596153846154 | 581 | 15 | 92 | 7 | 49 | 624 | 4 | 582 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 36978 | 944 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 10848848 | 10848848 | PRJNA674308_P_NODE_3849_length_489_cov_1.872727_g3615_i0 | PRJNA674308 | 3849 | 489 | 1.872727 | 9.15763503 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 377 | 6.93e-100 | NTclustered | gi|330791897|ref|XM_003283980.1| | 5786 | g3615 | i0 | 81.41 | 49.0531697341513 | 468 | 82 | 96 | 3 | 19 | 485 | 846 | 1309 | Dictyostelium purpureum 26S proteasome ATPase 2 subunit (DICPUDRAFT_96551), mRNA | blastn | 23987 | 377 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 10848859 | 10848859 | PRJNA674308_P_NODE_39669_length_168_cov_0.873950_g39434_i0 | PRJNA674308 | 39669 | 168 | 0.87395 | 1.468236 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 243 | 7.8e-60 | NTclustered | gi|470394462|ref|XM_004334945.1| | 1257118 | g39434 | i0 | 98.54 | 4.07738095238095 | 137 | 2 | 82 | 0 | 1 | 137 | 137 | 1 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_096510), partial mRNA | blastn | 685 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12124202 | 12124202 | PRJNA674308_P_NODE_49630_length_163_cov_1.350877_g49395_i0 | PRJNA674308 | 49630 | 163 | 1.350877 | 2.20192951 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|1160573070|ref|XM_020576713.1| | 670386 | g49395 | i0 | 100 | 0.177914110429448 | 29 | 0 | 18 | 0 | 79 | 107 | 589 | 561 | Polysphondylium pallidum PN500 Ras guanine nucleotide exchange factor (gefG), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 13398999 | 13398999 | PRJNA674308_P_NODE_54411_length_157_cov_4.953704_g54176_i0 | PRJNA674308 | 54411 | 157 | 4.953704 | 7.77731528 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 263 | 5.5000000000000005e-66 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g54176 | i0 | 96.815 | 1.98726114649682 | 157 | 5 | 100 | 0 | 1 | 157 | 7046 | 6890 | 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 | 312 | 263 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13920451 | 13920451 | PRJNA674308_P_NODE_2171_length_671_cov_91.607717_g1959_i0 | PRJNA674308 | 2171 | 671 | 91.607717 | 614.68778107 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 913 | 0 | NTclustered | gi|59876024|gb|AY785057.1| | 313998 | g1959 | i0 | 91.241 | 55.6304023845007 | 685 | 38 | 100 | 18 | 1 | 671 | 47 | 723 | Cochliopodium sp. strain Kiel 18S ribosomal RNA gene, partial sequence | blastn | 37328 | 913 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium sp. strain Kiel | |||
| 15947396 | 15947396 | PRJNA674308_P_NODE_3113_length_551_cov_2.071713_g2882_i0 | PRJNA674308 | 3113 | 551 | 2.071713 | 11.41513863 | Dictyostelium sp. | 5784 | Evosea | other_Eukaryota | 320 | 1.35e-82 | NTclustered | gi|2558374474|gb|OP168901.1| | 5784 | g2882 | i0 | 80.769 | 59.6370235934664 | 416 | 75 | 75 | 4 | 1 | 415 | 46451 | 46040 | Dictyostelium sp. voucher DSC<USA-NY>:DBS0350784 mitochondrion, complete genome | blastn | 32860 | 320 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium sp. | ||
| 17222828 | 17222828 | PRJNA674308_P_NODE_31614_length_180_cov_1.274809_g31379_i0 | PRJNA674308 | 31614 | 180 | 1.274809 | 2.2946562 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 263 | 6.479999999999999e-66 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g31379 | i0 | 92.222 | 1.23333333333333 | 180 | 14 | 100 | 0 | 1 | 180 | 7831 | 7652 | Acanthamoeba castellanii 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 | 222 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18497123 | 18497123 | PRJNA674308_P_NODE_35335_length_170_cov_1.677686_g35100_i0 | PRJNA674308 | 35335 | 170 | 1.677686 | 2.8520662 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 126 | 8.26e-25 | NTclustered | gi|330845265|ref|XM_003294466.1| | 5786 | g35100 | i0 | 89.109 | 0.594117647058824 | 101 | 11 | 59 | 0 | 39 | 139 | 598 | 698 | Dictyostelium purpureum tyrosine-tRNA ligase (DICPUDRAFT_159524), partial mRNA | blastn | 101 | 126 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18497329 | 18497329 | PRJNA674308_P_NODE_8775_length_321_cov_15.360294_g8540_i0 | PRJNA674308 | 8775 | 321 | 15.360294 | 49.30654374 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 459 | 1.5199999999999996e-124 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g8540 | i0 | 93.291 | 36.9781931464174 | 313 | 17 | 96 | 3 | 13 | 321 | 1760 | 1448 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 11870 | 459 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 18497339 | 18497339 | PRJNA674308_P_NODE_9795_length_304_cov_1.545098_g9560_i0 | PRJNA674308 | 9795 | 304 | 1.545098 | 4.69709792 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 540 | 4.96e-149 | NTclustered | gi|659103845|gb|KJ569729.1| | 1512276 | g9560 | i0 | 98.684 | 99.4243421052632 | 304 | 4 | 100 | 0 | 1 | 304 | 133 | 436 | Cochliopodium kieliense isolate 2 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 30225 | 540 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 19771468 | 19771468 | PRJNA674308_P_NODE_14856_length_250_cov_16.641791_g14621_i0 | PRJNA674308 | 14856 | 250 | 16.641791 | 41.6044775 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 357 | 4.28e-94 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g14621 | i0 | 92.248 | 54.076 | 258 | 11 | 100 | 7 | 1 | 250 | 2000 | 1744 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 13519 | 357 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 19771737 | 19771737 | PRJNA674308_P_NODE_45336_length_165_cov_0.896552_g45101_i0 | PRJNA674308 | 45336 | 165 | 0.896552 | 1.4793108 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 100 | 4.86e-17 | NTclustered | gi|167393759|ref|XM_001740644.1| | 370354 | g45101 | i0 | 85.417 | 5.66060606060606 | 96 | 14 | 58 | 0 | 1 | 96 | 2631 | 2726 | Entamoeba dispar SAW760 DNA-directed RNA polymerase I subunit RPA2, putative (EDI_303700), partial mRNA | blastn | 934 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 19771838 | 19771838 | PRJNA674308_P_NODE_6116_length_384_cov_3.322388_g5881_i0 | PRJNA674308 | 6116 | 384 | 3.322388 | 12.75796992 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|470247590|ref|XM_004366621.1| | 261658 | g5881 | i0 | 92.308 | 0.1015625 | 39 | 3 | 10 | 0 | 195 | 233 | 471 | 433 | Cavenderia fasciculata uncharacterized protein (DFA_02288), partial mRNA | blastn | 39 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 21047412 | 21047412 | PRJNA674308_P_NODE_49457_length_163_cov_1.789474_g49222_i0 | PRJNA674308 | 49457 | 163 | 1.789474 | 2.91684262 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 231 | 1.63e-56 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g49222 | i0 | 92.169 | 1.01840490797546 | 166 | 9 | 99 | 3 | 1 | 162 | 5920 | 5755 | Acanthamoeba castellanii 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 | 166 | 231 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22844202 | 22844202 | PRJNA674308_P_NODE_54378_length_158_cov_2.752294_g54143_i0 | PRJNA674308 | 54378 | 158 | 2.752294 | 4.34862452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 292 | 7.07e-75 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g54143 | i0 | 100 | 6.49367088607595 | 158 | 0 | 100 | 0 | 1 | 158 | 1002 | 1159 | 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 | 1026 | 292 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;