RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1174207 · 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
28493372 28493372 PRJNA1174207_P_NODE_33967_length_250_cov_1.740113_g33438_i0 PRJNA1174207 33967 250 1.740113 4.3502825 Paulinella micropora 1928728 SAR_Eukaryotes SAR_Eukaryotes 90.5 3.4800000000000006e-21   NR BBE07976.1 1928728 g33438 i0 48.8 0.96 80 34 87.6 1 27 245 5 84 BBE07976.1 LIM and SH3 domain protein [Paulinella micropora] diamond 240 90.5 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella micropora
29491220 29491220 PRJNA1174207_P_NODE_38550_length_245_cov_0.895349_g38021_i0 PRJNA1174207 38550 245 0.895349 2.19360505 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 99 1.6700000000000001e-22   NR MES1912634.1 1215613 g38021 i0 60 2.65714285714286 75 30 91.8 0 244 20 23 97 MES1912634.1 hypothetical protein [Cercozoa sp. M6MM] diamond 651 99.8 0.991983967935872 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29996726 29996726 PRJNA1174207_P_NODE_32531_length_254_cov_1.535912_g32002_i0 PRJNA1174207 32531 254 1.535912 3.90121648 Cercozoa 136419 SAR_Eukaryotes SAR_Eukaryotes 86.7 3.55e-19   NR AAY21202.1 227086 g32002 i0 71.2 4.38188976377953 59 16 69.7 1 178 2 19 76 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 1113 86.7 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
30293677 30293677 PRJNA1174207_P_NODE_31532_length_258_cov_1.664865_g31003_i0 PRJNA1174207 31532 258 1.664865 4.2953517 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 133 7.19e-38   NR ACF24571.1 67809 g31003 i0 72.9 1.97674418604651 85 23 98.8 0 3 257 58 142 ACF24571.1 ubiquitin-conjugating enzyme 2 [Gymnochlora stellata] diamond 510 133 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
31304404 31304404 PRJNA1174207_P_NODE_33135_length_251_cov_2.404494_g32606_i0 PRJNA1174207 33135 251 2.404494 6.03527994 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 65.9 9.5e-11   NR MES1908571.1 1215613 g32606 i0 53.8 0.956175298804781 80 37 95.6 0 1 240 116 195 MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] diamond 240 65.9 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);;