contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1037795 | 1037795 | PRJNA1158727_P_NODE_88501_length_317_cov_1.032787_g81040_i0 | PRJNA1158727 | 88501 | 317 | 1.032787 | 3.27393479 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 427 | 4.22e-115 | NTclustered | gi|330840543|ref|XM_003292226.1| | 5786 | g81040 | i0 | 91.586 | 97.6214511041009 | 309 | 26 | 97 | 0 | 9 | 317 | 437 | 129 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92832), mRNA | blastn | 30946 | 429 | 0.995337995337995 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 1580172 | 1580172 | PRJNA1158727_P_NODE_46622_length_533_cov_4.036957_g39176_i0 | PRJNA1158727 | 46622 | 533 | 4.036957 | 21.51698081 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 815 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g39176 | i0 | 94.393 | 101.15947467167 | 535 | 23 | 100 | 7 | 1 | 533 | 14 | 543 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 53918 | 815 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 3588239 | 3588239 | PRJNA1158727_P_NODE_77403_length_347_cov_3.817518_g69942_i0 | PRJNA1158727 | 77403 | 347 | 3.817518 | 13.24678746 | Vannellidae | 95227 | Discosea | other_Eukaryota | 577 | 4.3799999999999985e-160 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g69942 | i0 | 96.821 | 100.190201729107 | 346 | 10 | 99 | 1 | 2 | 347 | 1679 | 1335 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 34766 | 579 | 0.996545768566494 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 4865559 | 4865559 | PRJNA1158727_P_NODE_144584_length_248_cov_0.880000_g137122_i0 | PRJNA1158727 | 144584 | 248 | 0.88 | 2.1824 | Cryptodifflugia | 1078833 | Tubulinea | other_Eukaryota | 453 | 5.2600000000000005e-123 | NTclustered | gi|345294024|gb|JF694280.1| | 1078836 | g137122 | i0 | 99.597 | 90.2056451612903 | 248 | 1 | 100 | 0 | 1 | 248 | 1521 | 1768 | Cryptodifflugia operculata small subunit ribosomal RNA gene, partial sequence | blastn | 22371 | 453 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 4865730 | 4865730 | PRJNA1158727_P_NODE_57764_length_440_cov_1.117166_g50303_i0 | PRJNA1158727 | 57764 | 440 | 1.117166 | 4.9155304 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 551 | 3.4399999999999983e-152 | NTclustered | gi|330841829|ref|XM_003292845.1| | 5786 | g50303 | i0 | 89.607 | 97.2772727272727 | 433 | 45 | 98 | 0 | 7 | 439 | 1042 | 610 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_73394), mRNA | blastn | 42802 | 556 | 0.991007194244604 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 5408974 | 5408974 | PRJNA1158727_P_NODE_59385_length_429_cov_1.721910_g51924_i0 | PRJNA1158727 | 59385 | 429 | 1.72191 | 7.3869939 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 224 | 8.289999999999998e-54 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g51924 | i0 | 80.201 | 65.5990675990676 | 298 | 59 | 69 | 0 | 1 | 298 | 418 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 28142 | 224 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6140593 | 6140593 | PRJNA1158727_P_NODE_79625_length_341_cov_0.787313_g72164_i0 | PRJNA1158727 | 79625 | 341 | 0.787313 | 2.68473733 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 586 | 7.14e-163 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g72164 | i0 | 97.654 | 75.950146627566 | 341 | 8 | 100 | 0 | 1 | 341 | 2270 | 2610 | 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 | 25899 | 586 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6681669 | 6681669 | PRJNA1158727_P_NODE_132726_length_253_cov_1.677778_g125265_i0 | PRJNA1158727 | 132726 | 253 | 1.677778 | 4.24477834 | Stenamoeba aeronauta | 2971262 | Discosea | other_Eukaryota | 403 | 5.499999999999998e-108 | NTclustered | gi|2283789716|gb|OP179856.1| | 2971262 | g125265 | i0 | 95.331 | 76.2806324110672 | 257 | 7 | 100 | 5 | 1 | 253 | 391 | 136 | Stenamoeba aeronauta strain Stenaero small subunit ribosomal RNA gene, partial sequence | blastn | 19299 | 403 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba aeronauta | |||
| 6683225 | 6683225 | PRJNA1158727_P_NODE_41866_length_592_cov_1.495183_g34462_i0 | PRJNA1158727 | 41866 | 592 | 1.495183 | 8.85148336 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 483 | 1.7499999999999999e-131 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g34462 | i0 | 81.802 | 89.3361486486486 | 577 | 103 | 97 | 2 | 17 | 592 | 1839 | 1264 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 52887 | 483 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6684722 | 6684722 | PRJNA1158727_P_NODE_94066_length_305_cov_0.995690_g86605_i0 | PRJNA1158727 | 94066 | 305 | 0.99569 | 3.0368545 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 102 | 2.78e-17 | NTclustered | gi|470459156|ref|XM_004341277.1| | 1257118 | g86605 | i0 | 92.857 | 2.89508196721311 | 70 | 5 | 23 | 0 | 1 | 70 | 1097 | 1166 | Acanthamoeba castellanii str. Neff ribosomal protein L3, putative (ACA1_264110), partial mRNA | blastn | 883 | 102 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9232408 | 9232408 | PRJNA1158727_P_NODE_164788_length_238_cov_2.478788_g157326_i0 | PRJNA1158727 | 164788 | 238 | 2.478788 | 5.89951544 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 176 | 1.22e-39 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g157326 | i0 | 83.59 | 82.0168067226891 | 195 | 25 | 80 | 7 | 48 | 238 | 1376 | 1185 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 19520 | 176 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 18155428 | 18155428 | PRJNA1158727_P_NODE_125615_length_261_cov_1.367021_g118154_i0 | PRJNA1158727 | 125615 | 261 | 1.367021 | 3.56792481 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 399 | 7.379999999999998e-107 | NTclustered | gi|2467140639|dbj|LC720133.1| | 668358 | g118154 | i0 | 94.253 | 52.5210727969349 | 261 | 15 | 100 | 0 | 1 | 261 | 11 | 271 | Tychosporium acutostipes YIP-60 gene for 18S rRNA, partial sequence | blastn | 13708 | 399 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 18155975 | 18155975 | PRJNA1158727_P_NODE_153175_length_244_cov_1.801170_g145713_i0 | PRJNA1158727 | 153175 | 244 | 1.80117 | 4.3948548 | Echinamoeba thermarum | 197648 | Tubulinea | other_Eukaryota | 331 | 2.5200000000000006e-86 | NTclustered | gi|27526824|emb|AJ489261.1| | 197648 | g145713 | i0 | 91.429 | 98.7254098360656 | 245 | 15 | 98 | 5 | 1 | 240 | 432 | 189 | Echinamoeba thermarum 18S rRNA gene, isolate OSB1, clone 5 | blastn | 24089 | 331 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba thermarum | |||
| 18158002 | 18158002 | PRJNA1158727_P_NODE_72095_length_366_cov_1.576792_g64634_i0 | PRJNA1158727 | 72095 | 366 | 1.576792 | 5.77105872 | Arcyria cinerea | 137621 | Evosea | other_Eukaryota | 231 | 4.16e-56 | NTclustered | gi|2772191635|gb|PQ014995.1| | 137621 | g64634 | i0 | 78.857 | 71.0027322404372 | 350 | 68 | 95 | 6 | 17 | 363 | 170 | 516 | Arcyria cinerea voucher TUF105910 translation elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 25987 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria cinerea | ||
| 19432768 | 19432768 | PRJNA1158727_P_NODE_90316_length_312_cov_2.577406_g82855_i0 | PRJNA1158727 | 90316 | 312 | 2.577406 | 8.04150672 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 483 | 8.729999999999998e-132 | NTclustered | gi|256550195|gb|FJ792703.1| | 668358 | g82855 | i0 | 94.551 | 21.9711538461538 | 312 | 17 | 100 | 0 | 1 | 312 | 542 | 853 | Tychosporium acutostipes strain KE11AL small subunit ribosomal RNA gene, partial sequence | blastn | 6855 | 483 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 21979907 | 21979907 | PRJNA1158727_P_NODE_100618_length_292_cov_1.050228_g93157_i0 | PRJNA1158727 | 100618 | 292 | 1.050228 | 3.06666576 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|330795589|ref|XM_003285807.1| | 5786 | g93157 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 244 | 271 | 951 | 978 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_94041), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21982138 | 21982138 | PRJNA1158727_P_NODE_39738_length_622_cov_4.289617_g32355_i0 | PRJNA1158727 | 39738 | 622 | 4.289617 | 26.68141774 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 455 | 4.02e-123 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g32355 | i0 | 80.56 | 60.2958199356913 | 607 | 105 | 97 | 9 | 21 | 622 | 2520 | 1922 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 37504 | 455 | 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);;