RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA217180" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA217180 · 8 ✖

analysis 1

  • diamond · 8 ✖

tax_kingdom 0

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
26725380 26725380 PRJNA217180_P_NODE_11661_length_173_cov_1.225806_g11561_i0 PRJNA217180 11661 173 1.225806 2.12064438 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 42 0.0273   NR XP_009525707.1 67593 g11561 i0 39.5 0.745664739884393 43 26 74.6 0 132 4 137 179 XP_009525707.1 hypothetical protein PHYSODRAFT_300026 [Phytophthora sojae] diamond 129 42 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
26852723 26852723 PRJNA217180_P_NODE_14101_length_164_cov_0.886957_g14001_i0 PRJNA217180 14101 164 0.886957 1.45460948 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.75e-9   NR KAK1743039.1 267567 g14001 i0 75.9 0.98780487804878 54 9 97 3 4 162 1 51 KAK1743039.1 fatty acid desaturase [Skeletonema marinoi] diamond 162 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27263742 27263742 PRJNA217180_P_NODE_13023_length_166_cov_0.871795_g12923_i0 PRJNA217180 13023 166 0.871795 1.4471797 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 74.7 6.7e-14   NR KAK1744668.1 267567 g12923 i0 67.9 0.957831325301205 53 16 94 1 158 3 378 430 KAK1744668.1 zinc finger CCCH domain-containing protein [Skeletonema marinoi] diamond 159 74.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27674415 27674415 PRJNA217180_P_NODE_13584_length_165_cov_0.879310_g13484_i0 PRJNA217180 13584 165 0.87931 1.4508615 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 100 7.619999999999999e-23   NR KAK1742928.1 267567 g13484 i0 87 0.981818181818182 54 7 98.2 0 164 3 258 311 KAK1742928.1 hypothetical protein QTG54_006525 [Skeletonema marinoi] diamond 162 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29663000 29663000 PRJNA217180_P_NODE_13470_length_165_cov_0.879310_g13370_i0 PRJNA217180 13470 165 0.87931 1.4508615 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 52 7.23e-6   NR KAK1737781.1 267567 g13370 i0 68.8 0.581818181818182 32 10 58.2 0 70 165 343 374 KAK1737781.1 phosphatidylinositol-4-phosphate 5-kinase-related protein [Skeletonema marinoi] diamond 96 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29852908 29852908 PRJNA217180_P_NODE_12931_length_166_cov_0.871795_g12831_i0 PRJNA217180 12931 166 0.871795 1.4471797 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0456   NR KAF0689747.1 120398 g12831 i0 54.3 0.632530120481928 35 16 63.3 0 153 49 64 98 KAF0689747.1 hypothetical protein As57867_018751 [Aphanomyces stellatus] diamond 105 41.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
29884594 29884594 PRJNA217180_P_NODE_14471_length_163_cov_0.894737_g14371_i0 PRJNA217180 14471 163 0.894737 1.45842131 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 112 1.94e-28   NR OWZ19706.1 4795 g14371 i0 98.1 2.92638036809816 53 1 97.5 0 161 3 210 262 OWZ19706.1 Nuclear LIM factor interactor-interacting protein spore-specific form [Phytophthora megakarya] diamond 477 112 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
30705768 30705768 PRJNA217180_P_NODE_12894_length_166_cov_0.871795_g12794_i0 PRJNA217180 12894 166 0.871795 1.4471797 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.38e-18   NR CAE7860308.1 2951 g12794 i0 63.6 0.993975903614458 55 20 99.4 0 2 166 267 321 CAE7860308.1 dda [Symbiodinium microadriaticum] diamond 165 87.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;