contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB12366" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20816 | 20816 | PRJEB12366_P_NODE_8221_length_272_cov_1.350211_g8031_i0 | PRJEB12366 | 8221 | 272 | 1.350211 | 3.67257392 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 503 | 5.729999999999998e-138 | NTclustered | gi|1172045910|gb|KY859412.1| | 312471 | g8031 | i0 | 100 | 96.4816176470588 | 272 | 0 | 100 | 0 | 1 | 272 | 477 | 748 | Neobodo designis breed flagellate small subunit ribosomal RNA gene, partial sequence | blastn | 26243 | 503 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 10223576 | 10223576 | PRJEB12366_S_NODE_309_length_277_cov_8.421488_g301_i0 | PRJEB12366 | 309 | 277 | 8.421488 | 23.32752176 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 501 | 2.11e-137 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g301 | i0 | 99.281 | 69.4259927797834 | 278 | 1 | 100 | 1 | 1 | 277 | 2979 | 3256 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19231 | 501 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 12774429 | 12774429 | PRJEB12366_S_NODE_1571_length_194_cov_2.647799_g1563_i0 | PRJEB12366 | 1571 | 194 | 2.647799 | 5.13673006 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 309 | 9e-80 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g1563 | i0 | 96.757 | 1.94845360824742 | 185 | 6 | 95 | 0 | 1 | 185 | 1947 | 2131 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 378 | 309 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 14048856 | 14048856 | PRJEB12366_P_NODE_13092_length_201_cov_0.951807_g12902_i0 | PRJEB12366 | 13092 | 201 | 0.951807 | 1.91313207 | Acrasis rosea | 43695 | Heterolobosea | other_Eukaryota | 176 | 9.94e-40 | NTclustered | gi|12083876|gb|AF190771.1|AF190771 | 43695 | g12902 | i0 | 84.066 | 96.2636815920398 | 182 | 29 | 91 | 0 | 19 | 200 | 827 | 1008 | Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds | blastn | 19349 | 176 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 15322924 | 15322924 | PRJEB12366_P_NODE_14133_length_191_cov_1.307692_g13943_i0 | PRJEB12366 | 14133 | 191 | 1.307692 | 2.49769172 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2031944425|emb|OD958362.1| | 5763 | g13943 | i0 | 100 | 0.43979057591623 | 28 | 0 | 15 | 0 | 159 | 186 | 2497 | 2524 | Naegleria fowleri Karachi_NF001 strain | blastn | 84 | 52.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 15322945 | 15322945 | PRJEB12366_P_NODE_18093_length_162_cov_1.259843_g17903_i0 | PRJEB12366 | 18093 | 162 | 1.259843 | 2.04094566 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 294 | 2.03e-75 | NTclustered | gi|116222274|gb|DQ980523.1| | 312471 | g17903 | i0 | 99.383 | 107.135802469136 | 162 | 1 | 100 | 0 | 1 | 162 | 424 | 585 | Neobodo designis clone ndtub2 beta tubulin gene, partial cds | blastn | 17356 | 294 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 18837459 | 18837459 | PRJEB12366_S_NODE_375_length_260_cov_9.004444_g367_i0 | PRJEB12366 | 375 | 260 | 9.004444 | 23.4115544 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 481 | 2.55e-131 | NTclustered | gi|399764157|gb|JQ271668.1| | 1217110 | g367 | i0 | 100 | 25.9692307692308 | 260 | 0 | 100 | 0 | 1 | 260 | 511 | 252 | Allovahlkampfia sp. PKD 2011a strain 4165 18S ribosomal RNA gene, partial sequence | blastn | 6752 | 481 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 19146308 | 19146308 | PRJEB12366_P_NODE_8176_length_273_cov_1.638655_g7986_i0 | PRJEB12366 | 8176 | 273 | 1.638655 | 4.47352815 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 449 | 7.61e-122 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g7986 | i0 | 96.35 | 3.01831501831502 | 274 | 9 | 100 | 1 | 1 | 273 | 3701 | 3974 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 824 | 449 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. |
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);;