contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545367 | 545367 | PRJNA561212_P_NODE_22641_length_248_cov_1.228571_g22430_i0 | PRJNA561212 | 22641 | 248 | 1.228571 | 3.04685608 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 84.2 | 7.95e-12 | NTclustered | gi|66817435|ref|XM_637479.1| | 352472 | g22430 | i0 | 81.818 | 0.516129032258065 | 99 | 18 | 40 | 0 | 126 | 224 | 901 | 803 | Dictyostelium discoideum AX4 aldose 1-epimerase family protein (DDB_G0277669) mRNA, complete cds | blastn | 128 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 2406107 | 2406107 | PRJNA561212_P_NODE_25202_length_243_cov_1.200000_g24991_i0 | PRJNA561212 | 25202 | 243 | 1.2 | 2.916 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.6 | 7.82e-7 | NTclustered | gi|66828296|ref|XM_642411.1| | 352472 | g24991 | i0 | 100 | 25.8189300411523 | 36 | 0 | 15 | 0 | 140 | 175 | 1871 | 1836 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0268030) mRNA, complete cds | blastn | 6274 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 3096435 | 3096435 | PRJNA561212_P_NODE_3583_length_584_cov_0.911937_g3376_i0 | PRJNA561212 | 3583 | 584 | 0.911937 | 5.32571208 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 60.2 | 3.45e-4 | NTclustered | gi|66823500|ref|XM_640013.1| | 352472 | g3376 | i0 | 94.737 | 0.229452054794521 | 38 | 2 | 7 | 0 | 29 | 66 | 2583 | 2546 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0272486) mRNA, complete cds | blastn | 134 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5649197 | 5649197 | PRJNA561212_P_NODE_20345_length_253_cov_0.866667_g20134_i0 | PRJNA561212 | 20345 | 253 | 0.866667 | 2.19266751 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|330790290|ref|XM_003283183.1| | 5786 | g20134 | i0 | 92.308 | 0.154150197628458 | 39 | 3 | 15 | 0 | 203 | 241 | 201 | 163 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_74181), partial mRNA | blastn | 39 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 6923485 | 6923485 | PRJNA561212_P_NODE_25046_length_244_cov_0.865497_g24835_i0 | PRJNA561212 | 25046 | 244 | 0.865497 | 2.11181268 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 60.2 | 1.32e-4 | NTclustered | gi|66801224|ref|XM_629536.1| | 352472 | g24835 | i0 | 94.872 | 5.5 | 39 | 1 | 16 | 1 | 144 | 182 | 2114 | 2077 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0292556) mRNA, complete cds | blastn | 1342 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 8198460 | 8198460 | PRJNA561212_P_NODE_8387_length_379_cov_1.343137_g8176_i0 | PRJNA561212 | 8387 | 379 | 1.343137 | 5.09048923 | Cavenderia subdiscoidea | 3067639 | Evosea | other_Eukaryota | 84.2 | 1.28e-11 | NTclustered | gi|2558374431|gb|OP168900.1| | 3067639 | g8176 | i0 | 75.576 | 19.2981530343008 | 217 | 28 | 53 | 17 | 91 | 292 | 50885 | 51091 | Cavenderia subdiscoidea strain TH1A voucher DSC<USA-NY>:DBS0350779 mitochondrion, complete genome | blastn | 7314 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia subdiscoidea | ||
| 12609681 | 12609681 | PRJNA561212_P_NODE_3670_length_577_cov_1.849206_g3463_i0 | PRJNA561212 | 3670 | 577 | 1.849206 | 10.66991862 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 215 | 6.87e-51 | NTclustered | gi|187764061|ref|NC_010653.1| | 261658 | g3463 | i0 | 81.818 | 37.7781629116118 | 264 | 40 | 45 | 7 | 310 | 568 | 20784 | 21044 | Dictyostelium fasciculatum mitochondrion, complete genome | blastn | 21798 | 217 | 0.990783410138249 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 13299407 | 13299407 | PRJNA561212_P_NODE_1671_length_837_cov_3.289267_g1484_i0 | PRJNA561212 | 1671 | 837 | 3.289267 | 27.53116479 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 63.9 | 3.89e-5 | NTclustered | gi|66815284|ref|XM_636567.1| | 352472 | g1484 | i0 | 93.023 | 0.0513739545997611 | 43 | 3 | 5 | 0 | 281 | 323 | 955 | 913 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0279493) mRNA, complete cds | blastn | 43 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13884563 | 13884563 | PRJNA561212_P_NODE_551_length_1363_cov_126.851163_g448_i0 | PRJNA561212 | 551 | 1363 | 126.851163 | 1728.98135169 | Entamoeba | 5758 | Evosea | other_Eukaryota | 856 | 0 | NTclustered | gi|511083902|dbj|AK419160.1| | 5759 | g448 | i0 | 80.694 | 82.443873807777 | 1124 | 197 | 82 | 18 | 71 | 1184 | 29 | 1142 | Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS | blastn | 112371 | 856 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 17123024 | 17123024 | PRJNA561212_P_NODE_1674_length_837_cov_1.806283_g1487_i0 | PRJNA561212 | 1674 | 837 | 1.806283 | 15.11858871 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 712 | 0 | NTclustered | gi|330802803|ref|XM_003289355.1| | 5786 | g1487 | i0 | 82.497 | 96.2234169653525 | 817 | 137 | 97 | 6 | 7 | 820 | 1034 | 221 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72679), mRNA | blastn | 80539 | 712 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 17708663 | 17708663 | PRJNA561212_P_NODE_3834_length_565_cov_1.075203_g3627_i0 | PRJNA561212 | 3834 | 565 | 1.075203 | 6.07489695 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.015 | NTclustered | gi|330818738|ref|XM_003291448.1| | 5786 | g3627 | i0 | 76.577 | 0.761061946902655 | 111 | 18 | 19 | 7 | 439 | 548 | 707 | 604 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_89422), partial mRNA | blastn | 430 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21532708 | 21532708 | PRJNA561212_P_NODE_16137_length_281_cov_1.673077_g15926_i0 | PRJNA561212 | 16137 | 281 | 1.673077 | 4.70134637 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|34328658|gb|AY232273.1| | 44689 | g15926 | i0 | 94.595 | 0.362989323843416 | 37 | 1 | 13 | 1 | 223 | 258 | 521 | 557 | Dictyostelium discoideum putative protein Roco11 (roco11) gene, complete cds | blastn | 102 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 23497803 | 23497803 | PRJNA561212_P_NODE_24259_length_245_cov_0.906977_g24048_i0 | PRJNA561212 | 24259 | 245 | 0.906977 | 2.22209365 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|66804734|ref|XM_631008.1| | 352472 | g24048 | i0 | 94.286 | 0.142857142857143 | 35 | 2 | 14 | 0 | 163 | 197 | 2593 | 2559 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0289755) mRNA, complete cds | blastn | 35 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 24771619 | 24771619 | PRJNA561212_P_NODE_19440_length_258_cov_0.848649_g19229_i0 | PRJNA561212 | 19440 | 258 | 0.848649 | 2.18951442 | Diachea silvaepluvialis | 2928462 | Evosea | other_Eukaryota | 187 | 6.169999999999998e-43 | NTclustered | gi|2329703300|gb|MW240029.1| | 2928462 | g19229 | i0 | 83.099 | 88.3565891472868 | 213 | 28 | 81 | 8 | 14 | 222 | 837 | 629 | Diachea silvaepluvialis strain MA-Fungi 51896 elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 22796 | 187 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Diachea | Diachea silvaepluvialis |
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);;