RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJDB3785", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJDB3785 · 5 ✖

analysis 1

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
26810954 26810954 PRJDB3785_S_NODE_7901_length_267_cov_1.403670_g7748_i0 PRJDB3785 7901 267 1.40367 3.7477989 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 75.9 3.99e-14   NR MES1912576.1 1215613 g7748 i0 37.5 1.97752808988764 88 55 98.9 0 1 264 169 256 MES1912576.1 hypothetical protein [Cercozoa sp. M6MM] diamond 528 75.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27221865 27221865 PRJDB3785_S_NODE_20523_length_176_cov_1.078740_g20370_i0 PRJDB3785 20523 176 1.07874 1.8985824 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 61.6 3.38e-10   NR MES1916553.1 1215613 g20370 i0 63.6 0.75 44 16 75 0 176 45 81 124 MES1916553.1 hypothetical protein [Cercozoa sp. M6MM] diamond 132 61.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28169487 28169487 PRJDB3785_S_NODE_6326_length_299_cov_19.552000_g6173_i0 PRJDB3785 6326 299 19.552 58.46048 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 91.7 3.29e-22   NR MES1911722.1 1215613 g6173 i0 76.9 0.521739130434783 52 12 52.2 0 275 120 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 91.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28643257 28643257 PRJDB3785_S_NODE_18667_length_183_cov_1.141791_g18514_i0 PRJDB3785 18667 183 1.141791 2.08947753 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87.8 2.38e-19   NR MES1909335.1 1215613 g18514 i0 63.3 1.9672131147541 60 22 98.4 0 182 3 14 73 MES1909335.1 Eukaryotic translation initiation factor 6 [Cercozoa sp. M6MM] diamond 360 87.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31454605 31454605 PRJDB3785_S_NODE_9496_length_245_cov_2.040816_g9343_i0 PRJDB3785 9496 245 2.040816 4.9999992 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.51e-14   NR AAT09102.1 227086 g9343 i0 49.2 0.795918367346939 65 33 79.6 0 199 5 21 85 AAT09102.1 cysteine proteinase, partial [Bigelowiella natans] diamond 195 73.9 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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