contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax_phylum = "Discosea"
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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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);;