RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA689790" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA689790 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
21071150 21071150 PRJNA689790_S_NODE_15897_length_153_cov_3.000000_g15782_i0 PRJNA689790 15897 153 3 4.59 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 58.5 2.82e-8   NR MES1910324.1 1215613 g15782 i0 46.7 0.882352941176471 45 24 88.2 0 2 136 291 335 MES1910324.1 hypothetical protein [Cercozoa sp. M6MM] diamond 135 58.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26607344 26607344 PRJNA689790_S_NODE_2201_length_439_cov_2.522388_g2089_i0 PRJNA689790 2201 439 2.522388 11.07328332 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 146 1.08e-40   NR MES1912193.1 1215613 g2089 i0 57.4 5.70615034168565 136 58 92.9 0 408 1 6 141 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 2505 146 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26639142 26639142 PRJNA689790_S_NODE_1681_length_509_cov_5.671610_g1574_i0 PRJNA689790 1681 509 5.67161 28.8684949 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 118 2.44e-29   NR MES1907754.1 1215613 g1574 i0 39.9 0.842829076620825 143 86 84.3 0 505 77 113 255 MES1907754.1 hypothetical protein [Cercozoa sp. M6MM] diamond 429 118 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28882302 28882302 PRJNA689790_S_NODE_4308_length_292_cov_2.929412_g4193_i0 PRJNA689790 4308 292 2.929412 8.55388304 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82.4 7.32e-16   NR MES1910324.1 1215613 g4193 i0 47.9 0.986301369863014 96 38 87.3 3 255 1 50 144 MES1910324.1 hypothetical protein [Cercozoa sp. M6MM] diamond 288 82.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30998688 30998688 PRJNA689790_S_NODE_8794_length_199_cov_1.913580_g8679_i0 PRJNA689790 8794 199 1.91358 3.8080242 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 86.3 3.73e-18   NR MES1914381.1 1215613 g8679 i0 67.8 0.889447236180904 59 19 88.9 0 2 178 264 322 MES1914381.1 hypothetical protein [Cercozoa sp. M6MM] diamond 177 86.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32831945 32831945 PRJNA689790_S_NODE_10600_length_182_cov_2.103448_g10485_i0 PRJNA689790 10600 182 2.103448 3.82827536 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 64.7 2.91e-10   NR MES1910324.1 1215613 g10485 i0 51.7 0.956043956043956 58 27 95.6 1 6 179 375 431 MES1910324.1 hypothetical protein [Cercozoa sp. M6MM] diamond 174 64.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32831958 32831958 PRJNA689790_S_NODE_6720_length_229_cov_2.385417_g6605_i0 PRJNA689790 6720 229 2.385417 5.46260493 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 64.7 5.31e-10   NR MES1909771.1 1215613 g6605 i0 50.7 0.982532751091703 75 35 95.6 1 227 9 359 433 MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] diamond 225 64.7 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);;