contig_metadata
9 rows where bioproject = "PRJNA1123436", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2830423 | 2830423 | PRJNA1123436_P_NODE_45083_length_374_cov_1.189369_g43869_i0 | PRJNA1123436 | 45083 | 374 | 1.189369 | 4.44824006 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 8.589999999999998e-103 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g43869 | i0 | 86.376 | 61.5882352941176 | 367 | 35 | 98 | 9 | 10 | 374 | 4018 | 3665 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 23034 | 387 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 2830645 | 2830645 | PRJNA1123436_P_NODE_56623_length_331_cov_1.748062_g55409_i0 | PRJNA1123436 | 56623 | 331 | 1.748062 | 5.78608522 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 4.79e-60 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g55409 | i0 | 95.455 | 38.6676737160121 | 154 | 6 | 47 | 1 | 16 | 169 | 3696 | 3848 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 12799 | 244 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19406529 | 19406529 | PRJNA1123436_P_NODE_89596_length_260_cov_1.352941_g88382_i0 | PRJNA1123436 | 89596 | 260 | 1.352941 | 3.5176466 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.04e-40 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g88382 | i0 | 79.848 | 25.0884615384615 | 263 | 39 | 99 | 12 | 1 | 257 | 3746 | 4000 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 6523 | 180 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20681218 | 20681218 | PRJNA1123436_P_NODE_43777_length_380_cov_1.302932_g42563_i0 | PRJNA1123436 | 43777 | 380 | 1.302932 | 4.9511416 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.58e-45 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g42563 | i0 | 92.086 | 28.2526315789474 | 139 | 11 | 37 | 0 | 4 | 142 | 3699 | 3837 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 10736 | 196 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20681357 | 20681357 | PRJNA1123436_P_NODE_51137_length_349_cov_1.750000_g49923_i0 | PRJNA1123436 | 51137 | 349 | 1.75 | 6.1075 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 6.840000000000001e-29 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g49923 | i0 | 92.079 | 13.7277936962751 | 101 | 6 | 28 | 1 | 2 | 100 | 3737 | 3837 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4791 | 141 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21956468 | 21956468 | PRJNA1123436_P_NODE_41418_length_391_cov_3.729560_g40204_i0 | PRJNA1123436 | 41418 | 391 | 3.72956 | 14.5825796 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.69e-53 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g40204 | i0 | 91.018 | 42.7544757033248 | 167 | 11 | 42 | 4 | 1 | 164 | 3680 | 3845 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16717 | 222 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21956804 | 21956804 | PRJNA1123436_P_NODE_57958_length_327_cov_10.440945_g56744_i0 | PRJNA1123436 | 57958 | 327 | 10.440945 | 34.14189015 | Lotharella oceanica | 641309 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 3.05e-7 | NTclustered | gi|1009104511|ref|NC_029731.1| | 641309 | g56744 | i0 | 77.119 | 0.36085626911315 | 118 | 27 | 36 | 0 | 197 | 314 | 22583 | 22466 | Lotharella oceanica strain CCMP622 mitochondrion, complete genome | blastn | 118 | 69.4 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella oceanica | ||||
| 21957137 | 21957137 | PRJNA1123436_P_NODE_74218_length_289_cov_1.004630_g73004_i0 | PRJNA1123436 | 74218 | 289 | 1.00463 | 2.9033807 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 1.0699999999999997e-105 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g73004 | i0 | 92.527 | 97.598615916955 | 281 | 14 | 97 | 5 | 1 | 280 | 1766 | 2040 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 28206 | 396 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 23982156 | 23982156 | PRJNA1123436_P_NODE_78259_length_281_cov_1.490385_g77045_i0 | PRJNA1123436 | 78259 | 281 | 1.490385 | 4.18798185 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.629999999999999e-125 | NTclustered | gi|1915673916|emb|LR867535.1| | 404700 | g77045 | i0 | 99.603 | 94.085409252669 | 252 | 1 | 90 | 0 | 14 | 265 | 253 | 2 | uncultured Cercomonadida partial 18S rRNA gene | blastn | 26438 | 460 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadida environmental sample |
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);;