contig_metadata
8 rows where bioproject = "PRJNA404067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 414410 | 414410 | PRJNA404067_P_NODE_18481_length_242_cov_14.325967_g18094_i0 | PRJNA404067 | 18481 | 242 | 14.325967 | 34.66884014 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.53e-68 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g18094 | i0 | 86.885 | 72.6446280991736 | 244 | 29 | 100 | 3 | 1 | 242 | 1408 | 1166 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 17580 | 270 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 2965556 | 2965556 | PRJNA404067_P_NODE_38243_length_201_cov_1.657143_g37856_i0 | PRJNA404067 | 38243 | 201 | 1.657143 | 3.33085743 | uncultured Limnofilidae | 1938437 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 5.5e-97 | NTclustered | gi|1915673552|emb|LR867171.1| | 1938437 | g37856 | i0 | 99.502 | 100.402985074627 | 201 | 1 | 100 | 0 | 1 | 201 | 53 | 253 | uncultured Limnofilidae partial 18S rRNA gene | blastn | 20181 | 366 | 1 | Eukaryota | Sar | Cercozoa | Limnofilidae | uncultured Limnofilidae | |||||
| 3632158 | 3632158 | PRJNA404067_P_NODE_25903_length_220_cov_3.025157_g25516_i0 | PRJNA404067 | 25903 | 220 | 3.025157 | 6.6553454 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 3.629999999999999e-104 | NTclustered | gi|65306224|gb|AY965867.1| | 328349 | g25516 | i0 | 98.636 | 99.6136363636364 | 220 | 3 | 100 | 0 | 1 | 220 | 1631 | 1412 | Soil flagellate AND24 18S ribosomal RNA gene, partial sequence | blastn | 21915 | 390 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | soil flagellate AND24 | ||||
| 5518659 | 5518659 | PRJNA404067_P_NODE_45785_length_163_cov_5.147059_g45398_i0 | PRJNA404067 | 45785 | 163 | 5.147059 | 8.38970617 | Viridiraptor invadens | 1435003 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.24e-67 | NTclustered | gi|565682836|gb|KF207867.1| | 1435003 | g45398 | i0 | 99.324 | 83.0306748466258 | 148 | 1 | 91 | 0 | 16 | 163 | 521 | 668 | Viridiraptor invadens strain VirI02 18S ribosomal RNA gene, partial sequence | blastn | 13534 | 268 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Viridiraptor | Viridiraptor invadens | |||
| 15109002 | 15109002 | PRJNA404067_P_NODE_19312_length_239_cov_1.556180_g18925_i0 | PRJNA404067 | 19312 | 239 | 1.55618 | 3.7192702 | Protaspis | 188977 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 9.31e-51 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g18925 | i0 | 83.058 | 59.2301255230126 | 242 | 34 | 100 | 7 | 1 | 239 | 2569 | 2806 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 14156 | 215 | 0.990697674418605 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 17659147 | 17659147 | PRJNA404067_P_NODE_6174_length_510_cov_16.737194_g5801_i0 | PRJNA404067 | 6174 | 510 | 16.737194 | 85.3596894 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 4.08e-20 | NR | MES1911029.1 | 1215613 | g5801 | i0 | 47.4 | 0.682352941176471 | 116 | 59 | 68.2 | 1 | 9 | 356 | 188 | 301 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 348 | 95.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 22091388 | 22091388 | PRJNA404067_P_NODE_9418_length_361_cov_4.436667_g9033_i0 | PRJNA404067 | 9418 | 361 | 4.436667 | 16.01636787 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 5.11e-80 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g9033 | i0 | 83.668 | 48.9445983379501 | 349 | 38 | 96 | 10 | 1 | 348 | 3688 | 4018 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17669 | 311 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 22758475 | 22758475 | PRJNA404067_P_NODE_44898_length_168_cov_4.672897_g44511_i0 | PRJNA404067 | 44898 | 168 | 4.672897 | 7.85046696 | Cercomonadida | 188941 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 2.85e-49 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g44511 | i0 | 89.697 | 65.6488095238095 | 165 | 14 | 98 | 3 | 1 | 164 | 1355 | 1517 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 11029 | 209 | 0.990430622009569 | 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);;