RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA278119" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA278119 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
14400563 14400563 PRJNA278119_P_NODE_7612_length_431_cov_1.484293_g7365_i0 PRJNA278119 7612 431 1.484293 6.39730283 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 250 2.96e-83   NR ADK26622.1 323453 g7365 i0 94.5 0.890951276102088 128 7 89.1 0 46 429 1 128 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 384 250 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
22735531 22735531 PRJNA278119_P_NODE_17018_length_253_cov_1.274510_g16769_i0 PRJNA278119 17018 253 1.27451 3.2245103 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 126 2.16e-33   NR MES1907458.1 1215613 g16769 i0 75 0.99604743083004 84 21 99.6 0 252 1 47 130 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 252 126 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27074045 27074045 PRJNA278119_P_NODE_14962_length_280_cov_3.575758_g14713_i0 PRJNA278119 14962 280 3.575758 10.0121224 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82.4 7.66e-18   NR MES1912234.1 1215613 g14713 i0 53.8 1.67142857142857 78 32 83.6 2 19 252 46 119 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 468 82.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30200228 30200228 PRJNA278119_P_NODE_12152_length_327_cov_12.679856_g11904_i0 PRJNA278119 12152 327 12.679856 41.46312912 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 60.5 9.11e-10   NR MES1911722.1 1215613 g11904 i0 70.3 0.339449541284404 37 11 33.9 0 320 210 1 37 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 111 60.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31749075 31749075 PRJNA278119_P_NODE_10697_length_355_cov_4.405229_g10450_i0 PRJNA278119 10697 355 4.405229 15.63856295 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 85.1 2.53e-19   NR MES1911722.1 1215613 g10450 i0 72.5 0.430985915492958 51 14 43.1 0 354 202 2 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 153 85.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32002313 32002313 PRJNA278119_P_NODE_16818_length_255_cov_19.810680_g16569_i0 PRJNA278119 16818 255 19.81068 50.517234 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87.8 6.16e-21   NR MES1911722.1 1215613 g16569 i0 75 0.611764705882353 52 13 61.2 0 8 163 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 87.8 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);;