contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2149907 | 2149907 | PRJNA900028_P_NODE_135082_length_166_cov_0.871795_g134333_i0 | PRJNA900028 | 135082 | 166 | 0.871795 | 1.4471797 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 207 | 2.8e-49 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g134333 | i0 | 93.525 | 79.8313253012048 | 139 | 9 | 84 | 0 | 28 | 166 | 1725 | 1863 | 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 | 13252 | 207 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 3797685 | 3797685 | PRJNA900028_P_NODE_8723_length_371_cov_1.642857_g7977_i0 | PRJNA900028 | 8723 | 371 | 1.642857 | 6.09499947 | Physaraceae | 1115744 | Evosea | other_Eukaryota | 239 | 2.52e-58 | NTclustered | gi|34979689|gb|AY321115.1| | 246612 | g7977 | i0 | 87.981 | 46.9919137466307 | 208 | 17 | 55 | 6 | 168 | 371 | 774 | 571 | Physaridae sp. W2i small subunit ribosomal RNA gene, partial sequence | blastn | 17434 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physaridae sp. W2i | |||
| 4704364 | 4704364 | PRJNA900028_P_NODE_58804_length_198_cov_1.369128_g58055_i0 | PRJNA900028 | 58804 | 198 | 1.369128 | 2.71087344 | Physarum pseudonotabile | 1158133 | Evosea | other_Eukaryota | 366 | 5.4e-97 | NTclustered | gi|1133507925|emb|LT670567.1| | 1158133 | g58055 | i0 | 100 | 100.787878787879 | 198 | 0 | 100 | 0 | 1 | 198 | 107 | 304 | Physarum pseudonotabile partial 18S rRNA gene, specimen voucher LE255717 | blastn | 19956 | 366 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum pseudonotabile | ||
| 7252572 | 7252572 | PRJNA900028_P_NODE_120566_length_167_cov_0.864407_g119817_i0 | PRJNA900028 | 120566 | 167 | 0.864407 | 1.44355969 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 309 | 7.53e-80 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g119817 | i0 | 100 | 1 | 167 | 0 | 100 | 0 | 1 | 167 | 13376 | 13542 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 167 | 309 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7623010 | 7623010 | PRJNA900028_P_NODE_186606_length_161_cov_2.250000_g185857_i0 | PRJNA900028 | 186606 | 161 | 2.25 | 3.6225 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 298 | 1.56e-76 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g185857 | i0 | 100 | 80.472049689441 | 161 | 0 | 100 | 0 | 1 | 161 | 2341 | 2501 | 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 | 12956 | 298 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9804129 | 9804129 | PRJNA900028_P_NODE_98908_length_176_cov_1.606299_g98159_i0 | PRJNA900028 | 98908 | 176 | 1.606299 | 2.82708624 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 137 | 3.98e-28 | NTclustered | gi|374255694|emb|HE614594.1| | 435424 | g98159 | i0 | 87.097 | 48.1988636363636 | 124 | 12 | 69 | 2 | 1 | 121 | 328 | 206 | Soliformovum irregulare partial 18S rRNA gene, strain ATCC 26826 | blastn | 8483 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 11079037 | 11079037 | PRJNA900028_P_NODE_4129_length_529_cov_1.314583_g3404_i0 | PRJNA900028 | 4129 | 529 | 1.314583 | 6.95414407 | Physarum sp. LE 255714 | 1216082 | Evosea | other_Eukaryota | 592 | 2.4699999999999993e-164 | NTclustered | gi|440919836|gb|JX035987.2| | 1216082 | g3404 | i0 | 86.94 | 77.1153119092628 | 536 | 59 | 100 | 9 | 1 | 529 | 637 | 106 | Physarum sp. LE 255714 18S ribosomal RNA gene, partial sequence | blastn | 40794 | 592 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum sp. LE 255714 | ||
| 11449447 | 11449447 | PRJNA900028_P_NODE_869_length_1417_cov_1.751462_g443_i0 | PRJNA900028 | 869 | 1417 | 1.751462 | 24.81821654 | Didymium | 5792 | Evosea | other_Eukaryota | 1692 | 0 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g443 | i0 | 88.636 | 21.7960479887085 | 1408 | 137 | 98 | 16 | 1 | 1395 | 1264 | 2661 | D.iridis LSU rRNA gene | blastn | 30885 | 1692 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 13629551 | 13629551 | PRJNA900028_P_NODE_6051_length_437_cov_1.644330_g5309_i0 | PRJNA900028 | 6051 | 437 | 1.64433 | 7.1857221 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 464 | 4.58e-126 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g5309 | i0 | 86.105 | 31.7414187643021 | 439 | 52 | 100 | 9 | 1 | 437 | 6312 | 5881 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 13871 | 464 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 16547159 | 16547159 | PRJNA900028_P_NODE_116853_length_168_cov_1.193277_g116104_i0 | PRJNA900028 | 116853 | 168 | 1.193277 | 2.00470536 | Physarum | 5790 | Evosea | other_Eukaryota | 302 | 1.27e-77 | NTclustered | gi|379141567|gb|JQ478431.1| | 1158133 | g116104 | i0 | 99.398 | 93.3154761904762 | 166 | 1 | 99 | 0 | 1 | 166 | 1070 | 905 | Physarum pseudonotabile voucher 255438 LE 18S ribosomal RNA gene, partial sequence | blastn | 15677 | 305 | 0.99016393442623 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum pseudonotabile | ||
| 17453301 | 17453301 | PRJNA900028_P_NODE_182154_length_162_cov_0.902655_g181405_i0 | PRJNA900028 | 182154 | 162 | 0.902655 | 1.4623011 | Physarum pusillum | 385468 | Evosea | other_Eukaryota | 169 | 1.28e-37 | NTclustered | gi|1543031419|gb|MK336174.1| | 385468 | g181405 | i0 | 85.455 | 83.8827160493827 | 165 | 21 | 100 | 2 | 1 | 162 | 1728 | 1892 | Physarum pusillum voucher RC14091001 small subunit ribosomal RNA gene, partial sequence | blastn | 13589 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum pusillum | ||
| 17453509 | 17453509 | PRJNA900028_P_NODE_22014_length_263_cov_1.906542_g21265_i0 | PRJNA900028 | 22014 | 263 | 1.906542 | 5.01420546 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 193 | 1.36e-44 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g21265 | i0 | 87.135 | 2.32319391634981 | 171 | 20 | 65 | 2 | 3 | 172 | 13834 | 14003 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 611 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 17454231 | 17454231 | PRJNA900028_P_NODE_8194_length_381_cov_1.536145_g7448_i0 | PRJNA900028 | 8194 | 381 | 1.536145 | 5.85271245 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 675 | 0 | NTclustered | gi|381139266|emb|HE655083.1| | 159720 | g7448 | i0 | 98.681 | 67.5616797900262 | 379 | 5 | 99 | 0 | 1 | 379 | 1269 | 1647 | Fuligo septica partial 28S rRNA gene, isolate Mx-K28 | blastn | 25741 | 675 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 19097168 | 19097168 | PRJNA900028_P_NODE_78295_length_186_cov_1.116788_g77546_i0 | PRJNA900028 | 78295 | 186 | 1.116788 | 2.07722568 | Physaraceae | 1115744 | Evosea | other_Eukaryota | 344 | 2.34e-90 | NTclustered | gi|34979689|gb|AY321115.1| | 246612 | g77546 | i0 | 100 | 96.5537634408602 | 186 | 0 | 100 | 0 | 1 | 186 | 1541 | 1726 | Physaridae sp. W2i small subunit ribosomal RNA gene, partial sequence | blastn | 17959 | 344 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physaridae sp. W2i | |||
| 21277677 | 21277677 | PRJNA900028_P_NODE_56397_length_201_cov_1.000000_g55648_i0 | PRJNA900028 | 56397 | 201 | 1 | 2.01 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 372 | 1.18e-98 | NTclustered | gi|701726736|gb|KM220702.1| | 5778 | g55648 | i0 | 100 | 100.189054726368 | 201 | 0 | 100 | 0 | 1 | 201 | 15 | 215 | Vermamoeba vermiformis isolate 143A 18S ribosomal RNA gene, partial sequence | blastn | 20138 | 372 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23827011 | 23827011 | PRJNA900028_P_NODE_155619_length_164_cov_0.886957_g154870_i0 | PRJNA900028 | 155619 | 164 | 0.886957 | 1.45460948 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|330792529|ref|XM_003284293.1| | 5786 | g154870 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 91 | 118 | 1090 | 1063 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_148108), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23827858 | 23827858 | PRJNA900028_P_NODE_50979_length_207_cov_0.962025_g50230_i0 | PRJNA900028 | 50979 | 207 | 0.962025 | 1.99139175 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 255 | 1.29e-63 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g50230 | i0 | 98.611 | 57.6280193236715 | 144 | 2 | 70 | 0 | 64 | 207 | 6897 | 7040 | Polyschismium peyerimhoffii 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 | 11929 | 255 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 25100546 | 25100546 | PRJNA900028_P_NODE_128100_length_167_cov_0.864407_g127351_i0 | PRJNA900028 | 128100 | 167 | 0.864407 | 1.44355969 | Echinostelium coelocephalum | 300234 | Evosea | other_Eukaryota | 99 | 1.77e-16 | NTclustered | gi|210062521|gb|AY842033.2| | 300234 | g127351 | i0 | 95.161 | 0.37125748502994 | 62 | 3 | 37 | 0 | 78 | 139 | 299 | 238 | Echinostelium coelocephalum strain ATCC MYA-2964 18S ribosomal RNA gene, partial sequence | blastn | 62 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium coelocephalum |
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);;