contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20423466 | 20423466 | PRJEB20058_S_NODE_4997_length_274_cov_20.291080_g4959_i0 | PRJEB20058 | 4997 | 274 | 20.29108 | 55.5975592 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 363 | 1.02e-95 | NTclustered | gi|2031940840|emb|OD957768.1| | 5763 | g4959 | i0 | 96.364 | 1.89416058394161 | 220 | 8 | 80 | 0 | 1 | 220 | 220 | 1 | Naegleria fowleri Karachi_NF001 strain | blastn | 519 | 363 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 25517703 | 25517703 | PRJEB20058_P_NODE_214177_length_246_cov_6.886486_g211353_i0 | PRJEB20058 | 214177 | 246 | 6.886486 | 16.94075556 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2031941174|emb|OD957839.1| | 5763 | g211353 | i0 | 92.308 | 1.67479674796748 | 39 | 3 | 16 | 0 | 17 | 55 | 363 | 401 | Naegleria fowleri Karachi_NF001 strain | blastn | 412 | 56.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 25648934 | 25648934 | PRJEB20058_P_NODE_105442_length_394_cov_45.741742_g102634_i0 | PRJEB20058 | 105442 | 394 | 45.741742 | 180.22246348 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 446 | 1.4799999999999999e-120 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g102634 | i0 | 88.267 | 24.5456852791878 | 375 | 41 | 94 | 2 | 23 | 394 | 1850 | 2224 | 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 | 9671 | 446 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 25650204 | 25650204 | PRJEB20058_P_NODE_13450_length_1131_cov_4.816822_g11754_i0 | PRJEB20058 | 13450 | 1131 | 4.816822 | 54.47825682 | Vahlkampfia sp. | 1874882 | Heterolobosea | other_Eukaryota | 1480 | 0 | NTclustered | gi|2651357786|gb|PP174301.1| | 1874882 | g11754 | i0 | 90.506 | 10.6728558797524 | 1127 | 98 | 99 | 8 | 9 | 1131 | 4262 | 3141 | Vahlkampfia sp. isolate 24M 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 | 12071 | 1480 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia sp. | ||||
| 25655217 | 25655217 | PRJEB20058_P_NODE_31802_length_743_cov_134.868035_g29295_i0 | PRJEB20058 | 31802 | 743 | 134.868035 | 1002.06950005 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 292 | 4.03e-74 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g29295 | i0 | 78.71 | 16.0080753701211 | 465 | 79 | 61 | 15 | 265 | 720 | 2482 | 2029 | 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 | 11894 | 292 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 25786707 | 25786707 | PRJEB20058_P_NODE_142307_length_325_cov_3.359848_g139486_i0 | PRJEB20058 | 142307 | 325 | 3.359848 | 10.919506 | Vahlkampfia sp. | 1874882 | Heterolobosea | other_Eukaryota | 470 | 7.11e-128 | NTclustered | gi|2651357786|gb|PP174301.1| | 1874882 | g139486 | i0 | 94.444 | 52.2492307692308 | 306 | 15 | 94 | 2 | 1 | 305 | 3139 | 2835 | Vahlkampfia sp. isolate 24M 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 | 16981 | 470 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia sp. | ||||
| 25790905 | 25790905 | PRJEB20058_P_NODE_249051_length_196_cov_8.459259_g246226_i0 | PRJEB20058 | 249051 | 196 | 8.459259 | 16.58014764 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 204 | 4.42e-48 | NTclustered | gi|2031942541|emb|OD958147.1| | 5763 | g246226 | i0 | 90.062 | 2.18877551020408 | 161 | 11 | 82 | 4 | 36 | 196 | 7 | 162 | Naegleria fowleri Karachi_NF001 strain | blastn | 429 | 204 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 26059175 | 26059175 | PRJEB20058_P_NODE_14973_length_1072_cov_7.070227_g13173_i0 | PRJEB20058 | 14973 | 1072 | 7.070227 | 75.79283344 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 167 | 3.73e-36 | NTclustered | gi|2031942577|emb|OD958156.1| | 5763 | g13173 | i0 | 78.656 | 0.236007462686567 | 253 | 52 | 24 | 2 | 18 | 269 | 1 | 252 | Naegleria fowleri Karachi_NF001 strain | blastn | 253 | 167 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 26193330 | 26193330 | PRJEB20058_P_NODE_10230_length_1303_cov_14.684380_g8769_i0 | PRJEB20058 | 10230 | 1303 | 14.68438 | 191.3374714 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 664 | 0 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g8769 | i0 | 79.286 | 13.8296239447429 | 1009 | 164 | 84 | 29 | 18 | 1001 | 3262 | 4250 | 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 | 18020 | 664 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 26292559 | 26292559 | PRJEB20058_P_NODE_124486_length_356_cov_1.732203_g121668_i0 | PRJEB20058 | 124486 | 356 | 1.732203 | 6.16664268 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 191 | 6.84e-44 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g121668 | i0 | 81.2 | 16.7977528089888 | 250 | 36 | 70 | 7 | 108 | 356 | 5057 | 5296 | 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 | 5980 | 191 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 26469787 | 26469787 | PRJEB20058_P_NODE_202272_length_255_cov_0.896907_g199448_i0 | PRJEB20058 | 202272 | 255 | 0.896907 | 2.28711285 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 224 | 4.639999999999999e-54 | NTclustered | gi|2031939764|emb|OD957623.1| | 5763 | g199448 | i0 | 82.545 | 1.07843137254902 | 275 | 28 | 100 | 7 | 1 | 255 | 838 | 564 | Naegleria fowleri Karachi_NF001 strain | blastn | 275 | 224 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri |
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);;