contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA512103" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4939110 | 4939110 | PRJNA512103_P_NODE_8304_length_439_cov_1.979487_g7893_i0 | PRJNA512103 | 8304 | 439 | 1.979487 | 8.68994793 | Bigyra | 2683628 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 2.99e-68 | NTclustered | gi|855314976|ref|XM_013043241.1| | 12968 | g7893 | i0 | 79.389 | 88.2847380410023 | 393 | 75 | 89 | 3 | 41 | 430 | 834 | 445 | Blastocystis hominis mRNA | blastn | 38757 | 272 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 13240038 | 13240038 | PRJNA512103_P_NODE_29051_length_173_cov_2.274194_g28639_i0 | PRJNA512103 | 29051 | 173 | 2.274194 | 3.93435562 | Diplophrys mutabilis | 1407010 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.32e-72 | NTclustered | gi|550533550|dbj|AB856527.1| | 1407010 | g28639 | i0 | 100 | 24.8670520231214 | 154 | 0 | 89 | 0 | 11 | 164 | 1493 | 1646 | Diplophrys mutabilis gene for 18S ribosomal RNA, partial sequence | blastn | 4302 | 285 | 1 | Eukaryota | Sar | Bigyra | Amphitremida | Diplophrys | Diplophrys mutabilis | ||||
| 14514383 | 14514383 | PRJNA512103_P_NODE_11292_length_339_cov_2.427586_g10880_i0 | PRJNA512103 | 11292 | 339 | 2.427586 | 8.22951654 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 1.1799999999999996e-165 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g10880 | i0 | 99.39 | 96.9616519174041 | 328 | 2 | 97 | 0 | 3 | 330 | 11 | 338 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 32870 | 595 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17062688 | 17062688 | PRJNA512103_P_NODE_10254_length_368_cov_2.426332_g9842_i0 | PRJNA512103 | 10254 | 368 | 2.426332 | 8.92890176 | Diplophrys mutabilis | 1407010 | SAR_Eukaryotes | SAR_Eukaryotes | 566 | 1.0099999999999999e-156 | NTclustered | gi|550533550|dbj|AB856527.1| | 1407010 | g9842 | i0 | 95.278 | 50.3994565217391 | 360 | 12 | 97 | 5 | 1 | 356 | 1660 | 2018 | Diplophrys mutabilis gene for 18S ribosomal RNA, partial sequence | blastn | 18547 | 566 | 1 | Eukaryota | Sar | Bigyra | Amphitremida | Diplophrys | Diplophrys mutabilis | ||||
| 17063337 | 17063337 | PRJNA512103_P_NODE_2774_length_1015_cov_4.642857_g2502_i0 | PRJNA512103 | 2774 | 1015 | 4.642857 | 47.12499855 | Diplophrys mutabilis | 1407010 | SAR_Eukaryotes | SAR_Eukaryotes | 1099 | 0 | NTclustered | gi|550533550|dbj|AB856527.1| | 1407010 | g2502 | i0 | 86.403 | 36.6394088669951 | 1037 | 84 | 99 | 32 | 1 | 1006 | 1333 | 323 | Diplophrys mutabilis gene for 18S ribosomal RNA, partial sequence | blastn | 37189 | 1099 | 1 | Eukaryota | Sar | Bigyra | Amphitremida | Diplophrys | Diplophrys mutabilis | ||||
| 21512811 | 21512811 | PRJNA512103_P_NODE_2097_length_1218_cov_2.473909_g1876_i0 | PRJNA512103 | 2097 | 1218 | 2.473909 | 30.13221162 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 7.43e-4 | NTclustered | gi|2785757308|ref|XM_067215750.1| | 5824 | g1876 | i0 | 100 | 0.0525451559934319 | 32 | 0 | 3 | 0 | 492 | 523 | 914 | 883 | Plasmodium brasilianum Cg2 protein (MKS88_000468), partial mRNA | blastn | 64 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 22787900 | 22787900 | PRJNA512103_P_NODE_29278_length_173_cov_0.951613_g28866_i0 | PRJNA512103 | 29278 | 173 | 0.951613 | 1.64629049 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 3.87e-33 | NTclustered | gi|325181596|emb|FR824063.1| | 890382 | g28866 | i0 | 84.516 | 128.410404624277 | 155 | 24 | 90 | 0 | 19 | 173 | 56455 | 56301 | Albugo laibachii Nc14, genomic contig CONTIG_18_NC14_v4_198151_220 | blastn | 22215 | 154 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii |
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);;