contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA859990" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3788096 | 3788096 | PRJNA859990_S_NODE_7363_length_367_cov_1.697279_g7102_i0 | PRJNA859990 | 7363 | 367 | 1.697279 | 6.22901393 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 139 | 2.6e-28 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g7102 | i0 | 84.507 | 22.2506811989101 | 142 | 21 | 39 | 1 | 225 | 366 | 5057 | 5197 | Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 8166 | 139 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8498732 | 8498732 | PRJNA859990_S_NODE_13467_length_283_cov_1.285714_g13206_i0 | PRJNA859990 | 13467 | 283 | 1.285714 | 3.63857062 | Lula levis | 2939029 | Heterolobosea | other_Eukaryota | 95.3 | 4.28e-15 | NTclustered | gi|2234449040|gb|ON417697.1| | 2939029 | g13206 | i0 | 77.987 | 37.2155477031802 | 159 | 29 | 55 | 6 | 103 | 257 | 1480 | 1324 | Lula levis strain HFCC 1607 large subunit ribosomal RNA gene, partial sequence | blastn | 10532 | 95.3 | 1 | Eukaryota | Discoba | Heterolobosea | Percolomonadidae | Lula | Lula levis | ||||
| 12325058 | 12325058 | PRJNA859990_S_NODE_18390_length_249_cov_12.994318_g18129_i0 | PRJNA859990 | 18390 | 249 | 12.994318 | 32.35585182 | Allovahlkampfia sp. strain SO/1P | 500012 | Heterolobosea | other_Eukaryota | 453 | 5.29e-123 | NTclustered | gi|529154115|gb|EU266548.2| | 500012 | g18129 | i0 | 99.598 | 71.0562248995984 | 249 | 0 | 100 | 1 | 1 | 249 | 1525 | 1772 | Allovahlkampfia sp. strain SO/1P small subunit ribosomal RNA gene, complete sequence | blastn | 17693 | 453 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. strain SO/1P | ||||
| 12325137 | 12325137 | PRJNA859990_S_NODE_4450_length_456_cov_5.375979_g4189_i0 | PRJNA859990 | 4450 | 456 | 5.375979 | 24.51446424 | Allovahlkampfia sp. S35YCH | 2919519 | Heterolobosea | other_Eukaryota | 800 | 0 | NTclustered | gi|2199280130|dbj|LC683687.1| | 2919519 | g4189 | i0 | 98.462 | 39.3706140350877 | 455 | 5 | 99 | 1 | 1 | 455 | 1 | 453 | Allovahlkampfia sp. S35YCH gene for 18S ribosomal RNA, partial sequence | blastn | 17953 | 800 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. S35YCH | ||||
| 16148714 | 16148714 | PRJNA859990_S_NODE_6733_length_382_cov_2.899676_g6472_i0 | PRJNA859990 | 6733 | 382 | 2.899676 | 11.07676232 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 678 | 0 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g6472 | i0 | 98.691 | 29.9214659685864 | 382 | 5 | 100 | 0 | 1 | 382 | 3347 | 3728 | Allovahlkampfia sp. isolate S28D2 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 | 11430 | 678 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 17424040 | 17424040 | PRJNA859990_S_NODE_2054_length_637_cov_2.820922_g1801_i0 | PRJNA859990 | 2054 | 637 | 2.820922 | 17.96927314 | Allovahlkampfia sp. strain SO/1P | 500012 | Heterolobosea | other_Eukaryota | 985 | 0 | NTclustered | gi|529154115|gb|EU266548.2| | 500012 | g1801 | i0 | 97.902 | 74.0753532182104 | 572 | 7 | 90 | 5 | 1 | 571 | 1369 | 802 | Allovahlkampfia sp. strain SO/1P small subunit ribosomal RNA gene, complete sequence | blastn | 47186 | 985 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. strain SO/1P | ||||
| 17424077 | 17424077 | PRJNA859990_S_NODE_2594_length_574_cov_2.111776_g2338_i0 | PRJNA859990 | 2594 | 574 | 2.111776 | 12.12159424 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 880 | 0 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g2338 | i0 | 94.58 | 22.6271777003484 | 572 | 26 | 99 | 5 | 1 | 571 | 3794 | 4361 | Allovahlkampfia sp. isolate S28D2 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 | 12988 | 880 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 17424155 | 17424155 | PRJNA859990_S_NODE_8474_length_344_cov_2.439114_g8213_i0 | PRJNA859990 | 8474 | 344 | 2.439114 | 8.39055216 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 363 | 1.32e-95 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g8213 | i0 | 85.838 | 3.86046511627907 | 346 | 44 | 100 | 2 | 1 | 344 | 2414 | 2756 | Allovahlkampfia sp. isolate S28D2 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 | 1328 | 363 | 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);;