RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA756891" 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

  • PRJNA756891 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27621755 27621755 PRJNA756891_P_NODE_4044_length_418_cov_1.278261_g3975_i0 PRJNA756891 4044 418 1.278261 5.34313098 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62 4.26e-8   NR MES1910748.1 1215613 g3975 i0 43.9 0.409090909090909 57 31 40.9 1 248 418 183 238 MES1910748.1 hypothetical protein [Cercozoa sp. M6MM] diamond 171 62 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27726570 27726570 PRJNA756891_P_NODE_1784_length_616_cov_1.836096_g1717_i0 PRJNA756891 1784 616 1.836096 11.31035136 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 119 3.17e-27   NR MES1911532.1 1215613 g1717 i0 36.1 3.99837662337662 205 130 99.4 1 2 613 344 548 MES1911532.1 hypothetical protein [Cercozoa sp. M6MM] diamond 2463 119 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29547446 29547446 PRJNA756891_P_NODE_12950_length_249_cov_0.875000_g12881_i0 PRJNA756891 12950 249 0.875 2.17875 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.41e-21   NR MES1916673.1 1215613 g12881 i0 48.1 1.91566265060241 79 41 95.2 0 238 2 85 163 MES1916673.1 hypothetical protein [Cercozoa sp. M6MM] diamond 477 94.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32329531 32329531 PRJNA756891_P_NODE_7859_length_309_cov_1.563559_g7790_i0 PRJNA756891 7859 309 1.563559 4.83139731 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 51.6 6.07e-5   NR MES1907101.1 1215613 g7790 i0 33.3 0.757281553398058 78 50 75.7 1 253 20 470 545 MES1907101.1 hypothetical protein [Cercozoa sp. M6MM] diamond 234 51.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32802561 32802561 PRJNA756891_P_NODE_5200_length_371_cov_2.067114_g5131_i0 PRJNA756891 5200 371 2.067114 7.66899294 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 129 1.6199999999999998e-32   NR MES1909471.1 1215613 g5131 i0 54.6 0.962264150943396 119 54 96.2 0 1 357 224 342 MES1909471.1 hypothetical protein [Cercozoa sp. M6MM] diamond 357 129 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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