contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA606583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 583458 | 583458 | PRJNA606583_P_NODE_17421_length_296_cov_2.173745_g16992_i0 | PRJNA606583 | 17421 | 296 | 2.173745 | 6.4342852 | Euglena splendens | 392894 | Euglenozoa | other_Eukaryota | 65.8 | 3.53e-6 | NTclustered | gi|261361923|gb|FJ719613.1| | 392894 | g16992 | i0 | 100 | 0.472972972972973 | 35 | 0 | 12 | 0 | 261 | 295 | 1189 | 1155 | Euglena splendens strain CP110601 18S ribosomal RNA gene, partial sequence | blastn | 140 | 65.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena splendens | ||
| 1859435 | 1859435 | PRJNA606583_P_NODE_22962_length_240_cov_1.152709_g22533_i0 | PRJNA606583 | 22962 | 240 | 1.152709 | 2.7665016 | Euglena splendens | 392894 | Euglenozoa | other_Eukaryota | 361 | 3.16e-95 | NTclustered | gi|209362329|gb|DQ140107.2| | 392894 | g22533 | i0 | 93.776 | 96.7041666666667 | 241 | 13 | 100 | 2 | 1 | 240 | 3129 | 2890 | Euglena splendens strain Michigan (MI) 47 large subunit ribosomal RNA gene, partial sequence | blastn | 23209 | 361 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena splendens | ||
| 4411154 | 4411154 | PRJNA606583_P_NODE_15444_length_322_cov_2.442105_g15015_i0 | PRJNA606583 | 15444 | 322 | 2.442105 | 7.8635781 | Euglena rubra | 459220 | Euglenozoa | other_Eukaryota | 344 | 4.45e-90 | NTclustered | gi|1218592469|gb|KY541838.1| | 459220 | g15015 | i0 | 85.635 | 83.0993788819876 | 362 | 12 | 100 | 19 | 1 | 322 | 3512 | 3151 | Euglena rubra culture UTEX:2535 18S ribosomal RNA gene, partial sequence | blastn | 26758 | 344 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena rubra | ||
| 6961854 | 6961854 | PRJNA606583_P_NODE_26466_length_214_cov_1.293785_g26037_i0 | PRJNA606583 | 26466 | 214 | 1.293785 | 2.7686999 | Euglena cantabrica | 167850 | Euglenozoa | other_Eukaryota | 117 | 6.5900000000000005e-22 | NTclustered | gi|209362315|gb|AY523020.2| | 167850 | g26037 | i0 | 85.217 | 1.4018691588785 | 115 | 15 | 53 | 2 | 101 | 214 | 2704 | 2817 | Euglena cantabrica strain SAG1224-25 large subunit ribosomal RNA gene, partial sequence | blastn | 300 | 117 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena cantabrica | ||
| 8236626 | 8236626 | PRJNA606583_P_NODE_14967_length_329_cov_1.955479_g14538_i0 | PRJNA606583 | 14967 | 329 | 1.955479 | 6.43352591 | Euglena rubra | 459220 | Euglenozoa | other_Eukaryota | 126 | 1.7999999999999997e-24 | NTclustered | gi|1218592469|gb|KY541838.1| | 459220 | g14538 | i0 | 96.104 | 3.10942249240122 | 77 | 3 | 23 | 0 | 26 | 102 | 2167 | 2091 | Euglena rubra culture UTEX:2535 18S ribosomal RNA gene, partial sequence | blastn | 1023 | 126 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena rubra | ||
| 12062876 | 12062876 | PRJNA606583_P_NODE_17090_length_300_cov_2.254753_g16661_i0 | PRJNA606583 | 17090 | 300 | 2.254753 | 6.764259 | Euglena splendens | 392894 | Euglenozoa | other_Eukaryota | 257 | 5.51e-64 | NTclustered | gi|209362329|gb|DQ140107.2| | 392894 | g16661 | i0 | 84.42 | 49.74 | 276 | 28 | 92 | 11 | 1 | 276 | 454 | 194 | Euglena splendens strain Michigan (MI) 47 large subunit ribosomal RNA gene, partial sequence | blastn | 14922 | 257 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena splendens | ||
| 13337721 | 13337721 | PRJNA606583_P_NODE_31851_length_185_cov_1.581081_g31422_i0 | PRJNA606583 | 31851 | 185 | 1.581081 | 2.92499985 | Euglena splendens | 392894 | Euglenozoa | other_Eukaryota | 316 | 5.07e-82 | NTclustered | gi|209362329|gb|DQ140107.2| | 392894 | g31422 | i0 | 97.826 | 98.5837837837838 | 184 | 2 | 99 | 2 | 1 | 183 | 3878 | 3696 | Euglena splendens strain Michigan (MI) 47 large subunit ribosomal RNA gene, partial sequence | blastn | 18238 | 316 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena splendens | ||
| 17161382 | 17161382 | PRJNA606583_P_NODE_36434_length_167_cov_1.976923_g36005_i0 | PRJNA606583 | 36434 | 167 | 1.976923 | 3.30146141 | Euglena rubra | 459220 | Euglenozoa | other_Eukaryota | 65.8 | 1.8e-6 | NTclustered | gi|1218592469|gb|KY541838.1| | 459220 | g36005 | i0 | 100 | 0.209580838323353 | 35 | 0 | 21 | 0 | 133 | 167 | 1384 | 1418 | Euglena rubra culture UTEX:2535 18S ribosomal RNA gene, partial sequence | blastn | 35 | 65.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena rubra | ||
| 19710283 | 19710283 | PRJNA606583_P_NODE_8516_length_464_cov_1.681499_g8096_i0 | PRJNA606583 | 8516 | 464 | 1.681499 | 7.80215536 | Euglena rubra | 459220 | Euglenozoa | other_Eukaryota | 771 | 0 | NTclustered | gi|1218592469|gb|KY541838.1| | 459220 | g8096 | i0 | 97.978 | 93.75 | 445 | 8 | 96 | 1 | 1 | 444 | 2879 | 2435 | Euglena rubra culture UTEX:2535 18S ribosomal RNA gene, partial sequence | blastn | 43500 | 771 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena rubra | ||
| 20985960 | 20985960 | PRJNA606583_P_NODE_34737_length_173_cov_1.676471_g34308_i0 | PRJNA606583 | 34737 | 173 | 1.676471 | 2.90029483 | Euglena rubra | 459220 | Euglenozoa | other_Eukaryota | 185 | 1.3699999999999999e-42 | NTclustered | gi|1218592469|gb|KY541838.1| | 459220 | g34308 | i0 | 95.69 | 64.9364161849711 | 116 | 4 | 67 | 1 | 58 | 173 | 145 | 31 | Euglena rubra culture UTEX:2535 18S ribosomal RNA gene, partial sequence | blastn | 11234 | 185 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena rubra | ||
| 24809936 | 24809936 | PRJNA606583_P_NODE_36760_length_166_cov_1.852713_g36331_i0 | PRJNA606583 | 36760 | 166 | 1.852713 | 3.07550358 | Euglena splendens | 392894 | Euglenozoa | other_Eukaryota | 207 | 2.8e-49 | NTclustered | gi|2581904473|gb|OR601801.1| | 392894 | g36331 | i0 | 89.157 | 39.1144578313253 | 166 | 18 | 100 | 0 | 1 | 166 | 855 | 690 | Euglena splendens strain SHNUQ24C1 large subunit ribosomal RNA gene, partial sequence | blastn | 6493 | 207 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena splendens |
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);;