contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 215528 | 215528 | PRJNA1111146_P_NODE_117681_length_234_cov_2.193370_g116543_i0 | PRJNA1111146 | 117681 | 234 | 2.19337 | 5.1324858 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.09e-90 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g116543 | i0 | 93.191 | 66.1111111111111 | 235 | 14 | 100 | 2 | 1 | 234 | 2379 | 2146 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15470 | 344 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 1490213 | 1490213 | PRJNA1111146_P_NODE_104882_length_240_cov_8.342246_g103744_i0 | PRJNA1111146 | 104882 | 240 | 8.342246 | 20.0213904 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.49e-83 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g103744 | i0 | 90.909 | 43.05 | 242 | 19 | 100 | 3 | 1 | 240 | 1875 | 1635 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 10332 | 322 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 2766231 | 2766231 | PRJNA1111146_P_NODE_114223_length_236_cov_1.475410_g113085_i0 | PRJNA1111146 | 114223 | 236 | 1.47541 | 3.4819676 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 4.52e-9 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g113085 | i0 | 84.615 | 15.9364406779661 | 78 | 9 | 33 | 3 | 77 | 154 | 1751 | 1825 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 3761 | 75 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 9143814 | 9143814 | PRJNA1111146_P_NODE_269108_length_192_cov_4.366906_g267970_i0 | PRJNA1111146 | 269108 | 192 | 4.366906 | 8.38445952 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.14e-83 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g267970 | i0 | 96.875 | 100.473958333333 | 192 | 6 | 100 | 0 | 1 | 192 | 1415 | 1606 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 19291 | 322 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12500675 | 12500675 | PRJNA1111146_P_NODE_285530_length_189_cov_2.257353_g284392_i0 | PRJNA1111146 | 285530 | 189 | 2.257353 | 4.26639717 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.14e-92 | NTclustered | gi|1695785|gb|U42447.1|HGU42447 | 45107 | g284392 | i0 | 100 | 99.989417989418 | 189 | 0 | 100 | 0 | 1 | 189 | 1458 | 1646 | Heteromita globosa 18S ribosomal RNA gene, complete sequence | blastn | 18898 | 350 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 15518885 | 15518885 | PRJNA1111146_P_NODE_290553_length_188_cov_3.762963_g289415_i0 | PRJNA1111146 | 290553 | 188 | 3.762963 | 7.07437044 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 1.84e-91 | NTclustered | gi|68271541|gb|DQ086722.1| | 45107 | g289415 | i0 | 100 | 100.744680851064 | 188 | 0 | 100 | 0 | 1 | 188 | 532 | 345 | Heteromita globosa isolate HETEGLOB large subunit ribosomal RNA gene, partial sequence | blastn | 18940 | 348 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 19341419 | 19341419 | PRJNA1111146_P_NODE_105276_length_240_cov_1.802139_g104138_i0 | PRJNA1111146 | 105276 | 240 | 1.802139 | 4.3251336 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.51e-73 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g104138 | i0 | 96.552 | 72.6875 | 174 | 6 | 73 | 0 | 67 | 240 | 3838 | 3665 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17445 | 289 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24442947 | 24442947 | PRJNA1111146_P_NODE_443460_length_173_cov_3.108333_g442322_i0 | PRJNA1111146 | 443460 | 173 | 3.108333 | 5.37741609 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.69e-76 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g442322 | i0 | 97.688 | 98.3699421965318 | 173 | 4 | 100 | 0 | 1 | 173 | 1395 | 1223 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 17018 | 298 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;