contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 197584 | 197584 | PRJNA1092581_P_NODE_68201_length_317_cov_10.840164_g67668_i0 | PRJNA1092581 | 68201 | 317 | 10.840164 | 34.36331988 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 141 | 6.16e-29 | NTclustered | gi|1160553880|ref|XM_020572765.1| | 670386 | g67668 | i0 | 85.714 | 3.68769716088328 | 133 | 19 | 42 | 0 | 21 | 153 | 143 | 275 | Polysphondylium pallidum PN500 cytochrome c (cytC), partial mRNA | blastn | 1169 | 141 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 1471133 | 1471133 | PRJNA1092581_P_NODE_27402_length_531_cov_4.886463_g26870_i0 | PRJNA1092581 | 27402 | 531 | 4.886463 | 25.94711853 | Stemonitopsis subcaespitosa | 1048528 | Evosea | other_Eukaryota | 510 | 7.1499999999999995e-140 | NTclustered | gi|426281760|gb|JX681133.1| | 1048528 | g26870 | i0 | 88.889 | 77.7645951035782 | 414 | 46 | 78 | 0 | 118 | 531 | 6 | 419 | Stemonitopsis subcaespitosa actin gene, partial cds | blastn | 41293 | 510 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Stemonitopsis | Stemonitopsis subcaespitosa | ||
| 7850517 | 7850517 | PRJNA1092581_P_NODE_78407_length_292_cov_19.059361_g77874_i0 | PRJNA1092581 | 78407 | 292 | 19.059361 | 55.65333412 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 78.7 | 4.47e-10 | NTclustered | gi|470236133|ref|XM_004349965.1| | 261658 | g77874 | i0 | 86.111 | 0.246575342465753 | 72 | 10 | 25 | 0 | 6 | 77 | 888 | 959 | Cavenderia fasciculata G beta like protein (gpbB), partial mRNA | blastn | 72 | 78.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 10399768 | 10399768 | PRJNA1092581_P_NODE_25289_length_553_cov_12.304167_g24761_i0 | PRJNA1092581 | 25289 | 553 | 12.304167 | 68.04204351 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 396 | 2.18e-105 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g24761 | i0 | 82.851 | 29.493670886076 | 484 | 41 | 82 | 29 | 11 | 466 | 7032 | 6563 | 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 | 16310 | 396 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 11676728 | 11676728 | PRJNA1092581_P_NODE_88370_length_272_cov_5.040201_g87837_i0 | PRJNA1092581 | 88370 | 272 | 5.040201 | 13.70934672 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 244 | 3.8399999999999996e-60 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g87837 | i0 | 88.67 | 13.0772058823529 | 203 | 19 | 74 | 4 | 72 | 272 | 5257 | 5057 | D.iridis LSU rRNA gene | blastn | 3557 | 244 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 14226449 | 14226449 | PRJNA1092581_P_NODE_73892_length_303_cov_3.834783_g73359_i0 | PRJNA1092581 | 73892 | 303 | 3.834783 | 11.61939249 | Arcyria sp. 'tenuissima' | 3129282 | Evosea | other_Eukaryota | 412 | 1.1199999999999997e-110 | NTclustered | gi|2698738389|gb|PP491458.1| | 3129282 | g73359 | i0 | 92.708 | 0.95049504950495 | 288 | 17 | 94 | 2 | 1 | 284 | 3856 | 3569 | Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence | blastn | 288 | 412 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria sp. 'tenuissima' | ||
| 15499167 | 15499167 | PRJNA1092581_P_NODE_28433_length_520_cov_103.310962_g27901_i0 | PRJNA1092581 | 28433 | 520 | 103.310962 | 537.2170024 | Physarum cinereum | 289951 | Evosea | other_Eukaryota | 859 | 0 | NTclustered | gi|374255699|emb|HE614599.1| | 289951 | g27901 | i0 | 98.367 | 91.6019230769231 | 490 | 6 | 94 | 2 | 12 | 501 | 1752 | 1265 | Physarum cinereum partial 18S rRNA gene, strain Idn-2 | blastn | 47633 | 859 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum cinereum | ||
| 19322890 | 19322890 | PRJNA1092581_P_NODE_51956_length_372_cov_3.561873_g51423_i0 | PRJNA1092581 | 51956 | 372 | 3.561873 | 13.25016756 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 344 | 5.21e-90 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g51423 | i0 | 85.503 | 24.7043010752688 | 338 | 39 | 90 | 8 | 20 | 354 | 687 | 1017 | D.iridis LSU rRNA gene | blastn | 9190 | 344 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 20598777 | 20598777 | PRJNA1092581_P_NODE_74337_length_302_cov_3.235808_g73804_i0 | PRJNA1092581 | 74337 | 302 | 3.235808 | 9.77214016 | Didymium clavus | 289976 | Evosea | other_Eukaryota | 490 | 5.03e-134 | NTclustered | gi|381139240|emb|HE655047.1| | 289976 | g73804 | i0 | 97.88 | 59.9569536423841 | 283 | 6 | 94 | 0 | 20 | 302 | 1012 | 1294 | Didymium clavus partial 28S rRNA gene, isolate It-IG45 | blastn | 18107 | 490 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium clavus | ||
| 20599159 | 20599159 | PRJNA1092581_P_NODE_89357_length_270_cov_10.294416_g88824_i0 | PRJNA1092581 | 89357 | 270 | 10.294416 | 27.7949232 | Entamoeba gingivalis | 38877 | Evosea | other_Eukaryota | 351 | 2.1799999999999995e-92 | NTclustered | gi|2425687086|gb|OQ225454.1| | 38877 | g88824 | i0 | 98.98 | 71.1555555555556 | 196 | 2 | 73 | 0 | 1 | 196 | 196 | 1 | Entamoeba gingivalis isolate IH_ST2 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 19212 | 351 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba gingivalis | |||
| 21873720 | 21873720 | PRJNA1092581_P_NODE_41758_length_422_cov_2.931232_g41225_i0 | PRJNA1092581 | 41758 | 422 | 2.931232 | 12.36979904 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 569 | 9.069999999999996e-158 | NTclustered | gi|15284027|dbj|AB070525.1| | 5791 | g41225 | i0 | 92.327 | 51.0260663507109 | 404 | 26 | 95 | 5 | 1 | 401 | 465 | 64 | Physarum polycephalum ub1 mRNA for ubiquitin 1, complete cds | blastn | 21533 | 569 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 22694713 | 22694713 | PRJNA1092581_P_NODE_112538_length_236_cov_2.509202_g112005_i0 | PRJNA1092581 | 112538 | 236 | 2.509202 | 5.92171672 | Didymiaceae | 1115745 | Evosea | other_Eukaryota | 147 | 9.44e-31 | NTclustered | gi|116010585|emb|AM407430.1| | 290853 | g112005 | i0 | 89.655 | 3.72881355932203 | 116 | 10 | 49 | 2 | 27 | 141 | 1915 | 2029 | Lepidoderma carestianum partial 26S rRNA gene, isolate K18 | blastn | 880 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Lepidoderma | Lepidoderma carestianum |
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);;