contig_metadata
13 rows where bioproject = "PRJEB25789" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1297260 | 1297260 | PRJEB25789_S_NODE_12062_length_284_cov_2.000000_g11983_i0 | PRJEB25789 | 12062 | 284 | 2 | 5.68 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 424 | 4.82e-114 | NTclustered | gi|290988433|ref|XM_002676880.1| | 5762 | g11983 | i0 | 94.014 | 41.4225352112676 | 284 | 10 | 99 | 5 | 2 | 284 | 1429 | 1152 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA | blastn | 11764 | 424 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6401270 | 6401270 | PRJEB25789_S_NODE_16466_length_251_cov_1.870787_g16387_i0 | PRJEB25789 | 16466 | 251 | 1.870787 | 4.69567537 | Jakoba libera | 143017 | Root_unresolved | Root_unresolved | 78.7 | 3.75e-10 | NTclustered | gi|501595239|ref|NC_021127.1| | 143017 | g16387 | i0 | 82.955 | 0.721115537848606 | 88 | 13 | 35 | 2 | 157 | 243 | 92317 | 92403 | Jakoba libera strain ATCC 50422 mitochondrion, complete genome | blastn | 181 | 78.7 | 1 | Eukaryota | Discoba | Jakobida | Jakobidae | Jakoba | Jakoba libera | ||||
| 7675448 | 7675448 | PRJEB25789_S_NODE_17927_length_247_cov_0.885057_g17848_i0 | PRJEB25789 | 17927 | 247 | 0.885057 | 2.18609079 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 451 | 1.88e-122 | NTclustered | gi|290988433|ref|XM_002676880.1| | 5762 | g17848 | i0 | 99.597 | 96.2145748987854 | 248 | 0 | 100 | 1 | 1 | 247 | 276 | 29 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA | blastn | 23765 | 451 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 10225856 | 10225856 | PRJEB25789_S_NODE_13649_length_271_cov_1.277778_g13570_i0 | PRJEB25789 | 13649 | 271 | 1.277778 | 3.46277838 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 331 | 2.8500000000000002e-86 | NTclustered | gi|290992301|ref|XM_002678727.1| | 5762 | g13570 | i0 | 91.667 | 0.885608856088561 | 240 | 18 | 88 | 2 | 1 | 239 | 473 | 711 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_32592), partial mRNA | blastn | 240 | 331 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 11501144 | 11501144 | PRJEB25789_S_NODE_15790_length_256_cov_1.404372_g15711_i0 | PRJEB25789 | 15790 | 256 | 1.404372 | 3.59519232 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 363 | 9.47e-96 | NTclustered | gi|290989207|ref|XM_002677187.1| | 5762 | g15711 | i0 | 95.575 | 4.1953125 | 226 | 10 | 88 | 0 | 1 | 226 | 301 | 526 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56165), mRNA | blastn | 1074 | 363 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 16599848 | 16599848 | PRJEB25789_S_NODE_10994_length_295_cov_1.009009_g10915_i0 | PRJEB25789 | 10994 | 295 | 1.009009 | 2.97657655 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 446 | 1.07e-120 | NTclustered | gi|290983033|ref|XM_002674188.1| | 5762 | g10915 | i0 | 94.464 | 3.3728813559322 | 289 | 16 | 98 | 0 | 6 | 294 | 166 | 454 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_80683), mRNA | blastn | 995 | 446 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17874722 | 17874722 | PRJEB25789_S_NODE_14315_length_266_cov_1.528497_g14236_i0 | PRJEB25789 | 14315 | 266 | 1.528497 | 4.06580202 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 442 | 1.2399999999999995e-119 | NTclustered | gi|290992383|ref|XM_002678768.1| | 5762 | g14236 | i0 | 96.617 | 4 | 266 | 9 | 100 | 0 | 1 | 266 | 165 | 430 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_38656), mRNA | blastn | 1064 | 442 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 19148845 | 19148845 | PRJEB25789_S_NODE_9536_length_311_cov_0.928571_g9457_i0 | PRJEB25789 | 9536 | 311 | 0.928571 | 2.88785581 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 477 | 4.05e-130 | NTclustered | gi|290981412|ref|XM_002673379.1| | 5762 | g9457 | i0 | 95.333 | 0.964630225080386 | 300 | 14 | 96 | 0 | 3 | 302 | 306 | 7 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82733), mRNA | blastn | 300 | 477 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22975016 | 22975016 | PRJEB25789_S_NODE_11359_length_291_cov_1.399083_g11280_i0 | PRJEB25789 | 11359 | 291 | 1.399083 | 4.07133153 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 499 | 8.01e-137 | NTclustered | gi|290988433|ref|XM_002676880.1| | 5762 | g11280 | i0 | 97.595 | 80.4158075601375 | 291 | 7 | 100 | 0 | 1 | 291 | 796 | 1086 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA | blastn | 23401 | 499 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22975092 | 22975092 | PRJEB25789_S_NODE_15159_length_260_cov_1.235294_g15080_i0 | PRJEB25789 | 15159 | 260 | 1.235294 | 3.2117644 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 442 | 1.1999999999999999e-119 | NTclustered | gi|290987137|ref|XM_002676234.1| | 5762 | g15080 | i0 | 97.308 | 1 | 260 | 7 | 100 | 0 | 1 | 260 | 262 | 3 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_39446), mRNA | blastn | 260 | 442 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24248923 | 24248923 | PRJEB25789_S_NODE_13480_length_272_cov_2.316583_g13401_i0 | PRJEB25789 | 13480 | 272 | 2.316583 | 6.3011057599999996 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 459 | 1.2599999999999999e-124 | NTclustered | gi|290980060|ref|XM_002672705.1| | 5762 | g13401 | i0 | 97.398 | 0.988970588235294 | 269 | 7 | 99 | 0 | 1 | 269 | 116 | 384 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_81126), partial mRNA | blastn | 269 | 459 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24249025 | 24249025 | PRJEB25789_S_NODE_18660_length_245_cov_0.895349_g18581_i0 | PRJEB25789 | 18660 | 245 | 0.895349 | 2.19360505 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 431 | 2.4299999999999996e-116 | NTclustered | gi|290991601|ref|XM_002678378.1| | 5762 | g18581 | i0 | 98.367 | 3.99183673469388 | 245 | 4 | 100 | 0 | 1 | 245 | 276 | 520 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36356), partial mRNA | blastn | 978 | 431 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32587795 | 32587795 | PRJEB25789_S_NODE_13959_length_269_cov_1.010204_g13880_i0 | PRJEB25789 | 13959 | 269 | 1.010204 | 2.71744876 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 8.189999999999999e-38 | NR | QLA09565.1 | 3039 | g13880 | i0 | 74.7 | 23.0408921933086 | 83 | 21 | 92.6 | 0 | 268 | 20 | 118 | 200 | QLA09565.1 40S small subunit ribosomal protein uS3 [Euglena gracilis] | diamond | 6198 | 136 | 0.992647058823529 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis |
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);;