contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20722 | 20722 | PRJEB12237_P_NODE_921_length_765_cov_5.484932_g774_i0 | PRJEB12237 | 921 | 765 | 5.484932 | 41.9597298 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 344 | 1.13e-89 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g774 | i0 | 79.31 | 60.4901960784314 | 522 | 85 | 67 | 18 | 49 | 559 | 13 | 522 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 46275 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1294924 | 1294924 | PRJEB12237_P_NODE_6902_length_216_cov_23.005525_g6706_i0 | PRJEB12237 | 6902 | 216 | 23.005525 | 49.691934 | Filamoeba nolandi | 136452 | Evosea | other_Eukaryota | 394 | 2.75e-105 | NTclustered | gi|57546814|gb|AY714368.1| | 136452 | g6706 | i0 | 99.537 | 101.333333333333 | 216 | 1 | 100 | 0 | 1 | 216 | 1690 | 1475 | Filamoeba nolandi strain CCAP1526 small subunit ribosomal RNA gene, complete sequence | blastn | 21888 | 394 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba nolandi | ||||
| 6398789 | 6398789 | PRJEB12237_P_NODE_1186_length_668_cov_4.592417_g1025_i0 | PRJEB12237 | 1186 | 668 | 4.592417 | 30.67734556 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 311 | 9.94e-80 | NTclustered | gi|470441658|ref|XM_004339391.1| | 1257118 | g1025 | i0 | 78.571 | 58.312874251497 | 490 | 92 | 73 | 12 | 128 | 612 | 540 | 59 | Acanthamoeba castellanii str. Neff ribosomal L5P family Cterminus, putative (ACA1_061660), partial mRNA | blastn | 38953 | 311 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7672870 | 7672870 | PRJEB12237_P_NODE_1647_length_564_cov_1.933837_g1467_i0 | PRJEB12237 | 1647 | 564 | 1.933837 | 10.90684068 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 167 | 1.9e-36 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g1467 | i0 | 81.517 | 21.1418439716312 | 211 | 32 | 37 | 5 | 201 | 408 | 2295 | 2089 | 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 | 11924 | 167 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 8947668 | 8947668 | PRJEB12237_P_NODE_3788_length_336_cov_1.571429_g3592_i0 | PRJEB12237 | 3788 | 336 | 1.571429 | 5.28000144 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 137 | 8.51e-28 | NTclustered | gi|831753332|ref|XM_012892328.1| | 1410327 | g3592 | i0 | 79.703 | 1.37202380952381 | 202 | 31 | 59 | 7 | 136 | 332 | 571 | 767 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 461 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 11498716 | 11498716 | PRJEB12237_P_NODE_5550_length_253_cov_2.357798_g5354_i0 | PRJEB12237 | 5550 | 253 | 2.357798 | 5.96522894 | Vannella sp. LITHOV | 1215650 | Discosea | other_Eukaryota | 435 | 1.95e-117 | NTclustered | gi|399764235|gb|JQ271746.1| | 1215650 | g5354 | i0 | 97.638 | 97.296442687747 | 254 | 4 | 100 | 2 | 1 | 253 | 441 | 189 | Vannella sp. LITHOV 18S ribosomal RNA gene, partial sequence | blastn | 24616 | 435 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. LITHOV | |||
| 11498719 | 11498719 | PRJEB12237_P_NODE_6130_length_236_cov_1.099502_g5934_i0 | PRJEB12237 | 6130 | 236 | 1.099502 | 2.59482472 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|111226891|ref|XM_639539.2| | 352472 | g5934 | i0 | 100 | 0.23728813559322 | 28 | 0 | 12 | 0 | 36 | 63 | 2100 | 2073 | Dictyostelium discoideum AX4 adaptor-related protein complex 2, alpha subunit (ap2a1-2) mRNA, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14048770 | 14048770 | PRJEB12237_P_NODE_10412_length_164_cov_1.550388_g10216_i0 | PRJEB12237 | 10412 | 164 | 1.550388 | 2.54263632 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 281 | 1.6000000000000001e-71 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g10216 | i0 | 97.561 | 92.0670731707317 | 164 | 4 | 100 | 0 | 1 | 164 | 4029 | 4192 | 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 | 15099 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 14048786 | 14048786 | PRJEB12237_P_NODE_152_length_1587_cov_7.943299_g107_i0 | PRJEB12237 | 152 | 1587 | 7.943299 | 126.06015513 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 859 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g107 | i0 | 94.803 | 31.3503465658475 | 558 | 18 | 35 | 10 | 2 | 556 | 550 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 49753 | 859 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 15322878 | 15322878 | PRJEB12237_P_NODE_6733_length_220_cov_1.756757_g6537_i0 | PRJEB12237 | 6733 | 220 | 1.756757 | 3.8648654 | Vannella sp. BEN3V | 1215631 | Discosea | other_Eukaryota | 335 | 1.7299999999999996e-87 | NTclustered | gi|399764216|gb|JQ271727.1| | 1215631 | g6537 | i0 | 94.545 | 75.0545454545454 | 220 | 7 | 100 | 5 | 1 | 220 | 662 | 876 | Vannella sp. BEN3V 18S ribosomal RNA gene, partial sequence | blastn | 16512 | 335 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. BEN3V | |||
| 16597489 | 16597489 | PRJEB12237_P_NODE_3714_length_339_cov_20.973684_g3518_i0 | PRJEB12237 | 3714 | 339 | 20.973684 | 71.10078876 | Filamoeba nolandi | 136452 | Evosea | other_Eukaryota | 532 | 9.38e-147 | NTclustered | gi|57546814|gb|AY714368.1| | 136452 | g3518 | i0 | 95.536 | 59.4247787610619 | 336 | 10 | 98 | 5 | 7 | 339 | 1524 | 1191 | Filamoeba nolandi strain CCAP1526 small subunit ribosomal RNA gene, complete sequence | blastn | 20145 | 532 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba nolandi | ||||
| 19146192 | 19146192 | PRJEB12237_P_NODE_7016_length_214_cov_1.787709_g6820_i0 | PRJEB12237 | 7016 | 214 | 1.787709 | 3.82569726 | Lamproderma scintillans | 1115720 | Evosea | other_Eukaryota | 169 | 1.7899999999999998e-37 | NTclustered | gi|2306687673|gb|MZ234286.1| | 1115720 | g6820 | i0 | 80.93 | 23.6448598130841 | 215 | 39 | 100 | 2 | 1 | 214 | 306 | 93 | Lamproderma scintillans voucher LE297459 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 5060 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans | ||
| 20112206 | 20112206 | PRJEB12237_P_NODE_9796_length_171_cov_1.176471_g9600_i0 | PRJEB12237 | 9796 | 171 | 1.176471 | 2.01176541 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 202 | 1.34e-47 | NTclustered | gi|330792727|ref|XM_003284391.1| | 5786 | g9600 | i0 | 88.166 | 100.485380116959 | 169 | 20 | 99 | 0 | 1 | 169 | 388 | 220 | Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA | blastn | 17183 | 202 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 22972655 | 22972655 | PRJEB12237_P_NODE_2439_length_451_cov_2.009615_g2243_i0 | PRJEB12237 | 2439 | 451 | 2.009615 | 9.06336365 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 737 | 0 | NTclustered | gi|1269228431|gb|MF683556.1| | 2047822 | g2243 | i0 | 96.637 | 99.310421286031 | 446 | 12 | 99 | 2 | 7 | 451 | 1572 | 1129 | Ripella decalvata clone 26.2.11 18S ribosomal RNA gene, partial sequence | blastn | 44789 | 737 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata |
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);;