contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1719192 | 1719192 | PRJNA473201_P_NODE_69542_length_249_cov_0.875000_g68800_i0 | PRJNA473201 | 69542 | 249 | 0.875 | 2.17875 | Didymium quitense | 2059305 | Evosea | other_Eukaryota | 215 | 2.72e-51 | NTclustered | gi|1368344018|gb|MG672463.1| | 2059305 | g68800 | i0 | 85.446 | 22.2971887550201 | 213 | 23 | 84 | 5 | 38 | 246 | 441 | 649 | Didymium quitense voucher MA-88326 elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 5552 | 215 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium quitense | ||
| 2994502 | 2994502 | PRJNA473201_P_NODE_4043_length_1007_cov_2.058887_g3524_i0 | PRJNA473201 | 4043 | 1007 | 2.058887 | 20.73299209 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 54.7 | 0.028 | NTclustered | gi|470265358|ref|XM_004361422.1| | 261658 | g3524 | i0 | 100 | 0.05759682224429 | 29 | 0 | 3 | 0 | 769 | 797 | 324 | 352 | Cavenderia fasciculata uncharacterized protein (DFA_05762), partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 5547685 | 5547685 | PRJNA473201_P_NODE_55025_length_279_cov_1.868932_g54283_i0 | PRJNA473201 | 55025 | 279 | 1.868932 | 5.21432028 | Cribraria violacea | 1334538 | Evosea | other_Eukaryota | 237 | 6.61e-58 | NTclustered | gi|501417113|gb|JX481322.1| | 1334538 | g54283 | i0 | 82.27 | 22.0752688172043 | 282 | 42 | 99 | 7 | 2 | 279 | 540 | 817 | Cribraria violacea voucher AMFD172 elongation factor 1A (EF1A) gene, partial cds | blastn | 6159 | 237 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Cribrariaceae | Cribraria | Cribraria violacea | ||
| 6821108 | 6821108 | PRJNA473201_P_NODE_21546_length_425_cov_1.829545_g20804_i0 | PRJNA473201 | 21546 | 425 | 1.829545 | 7.77556625 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 254 | 1.05e-62 | NTclustered | gi|1160564092|ref|XM_020582838.1| | 670386 | g20804 | i0 | 79.058 | 12.4235294117647 | 382 | 70 | 89 | 9 | 49 | 425 | 16 | 392 | Polysphondylium pallidum PN500 S60 ribosomal protein L10 (rpl10), partial mRNA | blastn | 5280 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 8096445 | 8096445 | PRJNA473201_P_NODE_14667_length_521_cov_6.198661_g13926_i0 | PRJNA473201 | 14667 | 521 | 6.198661 | 32.295023810000004 | Physarella oblonga | 1092565 | Evosea | other_Eukaryota | 730 | 0 | NTclustered | gi|381139255|emb|HE655072.1| | 1092565 | g13926 | i0 | 91.969 | 73.6679462571977 | 523 | 38 | 100 | 4 | 1 | 521 | 1496 | 976 | Physarella oblonga partial 28S rRNA gene | blastn | 38381 | 730 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarella | Physarella oblonga | ||
| 8097827 | 8097827 | PRJNA473201_P_NODE_9207_length_668_cov_4.374790_g8486_i0 | PRJNA473201 | 9207 | 668 | 4.37479 | 29.2235972 | Physarella oblonga | 1092565 | Evosea | other_Eukaryota | 926 | 0 | NTclustered | gi|374255698|emb|HE614598.1| | 1092565 | g8486 | i0 | 91.892 | 87.7365269461078 | 666 | 49 | 99 | 5 | 7 | 668 | 1899 | 1235 | Physarella oblonga partial 18S rRNA gene, strain USA | blastn | 58608 | 926 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarella | Physarella oblonga | ||
| 13198353 | 13198353 | PRJNA473201_P_NODE_9911_length_642_cov_7.527241_g9182_i0 | PRJNA473201 | 9911 | 642 | 7.527241 | 48.32488722 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 484 | 5.309999999999998e-132 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g9182 | i0 | 84.879 | 24.4968847352025 | 496 | 58 | 76 | 15 | 4 | 488 | 5884 | 6373 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 15727 | 484 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 14472061 | 14472061 | PRJNA473201_P_NODE_18132_length_466_cov_1.959288_g17390_i0 | PRJNA473201 | 18132 | 466 | 1.959288 | 9.13028208 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 62.1 | 7.52e-5 | NTclustered | gi|1160555948|ref|XM_020573799.1| | 670386 | g17390 | i0 | 85.965 | 0.122317596566524 | 57 | 8 | 12 | 0 | 397 | 453 | 149 | 93 | Polysphondylium pallidum PN500 40S ribosomal protein S30 (rps30-2), partial mRNA | blastn | 57 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 14472330 | 14472330 | PRJNA473201_P_NODE_3332_length_1094_cov_6.864838_g2882_i0 | PRJNA473201 | 3332 | 1094 | 6.864838 | 75.10132772 | Physarella sp. BX-2002 | 211109 | Evosea | other_Eukaryota | 1144 | 0 | NTclustered | gi|24711449|gb|AY145524.1| | 211109 | g2882 | i0 | 85.791 | 87.2385740402194 | 1112 | 121 | 100 | 33 | 1 | 1094 | 1104 | 12 | Physarella sp. BX-2002 18S ribosomal RNA gene, partial sequence | blastn | 95439 | 1144 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarella | Physarella sp. BX-2002 | ||
| 15123034 | 15123034 | PRJNA473201_P_NODE_63332_length_257_cov_1.673913_g62590_i0 | PRJNA473201 | 63332 | 257 | 1.673913 | 4.30195641 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 8.17e-22 | NTclustered | gi|260909292|gb|FJ766478.1| | 435420 | g62590 | i0 | 95.833 | 27.8287937743191 | 72 | 3 | 28 | 0 | 186 | 257 | 1373 | 1302 | Schizoplasmodiopsis amoeboidea strain BG7A-12B piece G 18S ribosomal RNA gene, partial sequence | blastn | 7152 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Schizoplasmodiopsis | Schizoplasmodiopsis amoeboidea | |||
| 15746580 | 15746580 | PRJNA473201_P_NODE_45233_length_303_cov_2.008696_g44491_i0 | PRJNA473201 | 45233 | 303 | 2.008696 | 6.08634888 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 89.8 | 2.15e-13 | NTclustered | gi|470236133|ref|XM_004349965.1| | 261658 | g44491 | i0 | 88.889 | 0.455445544554455 | 72 | 8 | 24 | 0 | 37 | 108 | 888 | 959 | Cavenderia fasciculata G beta like protein (gpbB), partial mRNA | blastn | 138 | 89.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 16397879 | 16397879 | PRJNA473201_P_NODE_73693_length_247_cov_0.885057_g72951_i0 | PRJNA473201 | 73693 | 247 | 0.885057 | 2.18609079 | Evosea | 2605435 | Evosea | other_Eukaryota | 311 | 3.34e-80 | NTclustered | gi|330802803|ref|XM_003289355.1| | 5786 | g72951 | i0 | 89.712 | 98.5991902834008 | 243 | 25 | 98 | 0 | 1 | 243 | 438 | 680 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72679), mRNA | blastn | 24354 | 313 | 0.993610223642173 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 20220945 | 20220945 | PRJNA473201_P_NODE_32316_length_348_cov_1.680000_g31574_i0 | PRJNA473201 | 32316 | 348 | 1.68 | 5.8464 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 510 | 4.52e-140 | NTclustered | gi|426281754|gb|JX681130.1| | 289989 | g31574 | i0 | 93.103 | 100.965517241379 | 348 | 24 | 100 | 0 | 1 | 348 | 806 | 459 | Didymium squamulosum actin gene, partial cds | blastn | 35136 | 510 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium squamulosum | ||
| 24669484 | 24669484 | PRJNA473201_P_NODE_15680_length_503_cov_7.634884_g14939_i0 | PRJNA473201 | 15680 | 503 | 7.634884 | 38.40346652 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 292 | 2.66e-74 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g14939 | i0 | 89.912 | 10.8946322067594 | 228 | 22 | 45 | 1 | 12 | 239 | 13789 | 14015 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 5480 | 292 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica |
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);;