RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14664 · 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
19146681 19146681 PRJEB14664_P_NODE_1476_length_758_cov_2.964039_g1378_i0 PRJEB14664 1476 758 2.964039 22.46741562 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 240 4.08e-75   NR MES1911029.1 1215613 g1378 i0 62.9 2.56860158311346 197 68 76 3 3 578 79 275 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1947 240 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19146737 19146737 PRJEB14664_P_NODE_236_length_1686_cov_13.820715_g212_i0 PRJEB14664 236 1686 13.820715 233.0172549 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 695 2.159999999999999e-247   NR MES1909605.1 1215613 g212 i0 77.1 4.71708185053381 433 99 77 0 1664 366 1 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 7953 701 0.991440798858773 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
21697859 21697859 PRJEB14664_P_NODE_1218_length_843_cov_2.857673_g1130_i0 PRJEB14664 1218 843 2.857673 24.09018339 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 332 3.51e-111   NR ADK26624.1 323453 g1130 i0 65 0.925266903914591 260 69 84.7 2 842 129 17 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 780 332 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
27696833 27696833 PRJEB14664_P_NODE_17424_length_165_cov_1.230769_g17294_i0 PRJEB14664 17424 165 1.230769 2.03076885 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.17e-4   NR MES1911260.1 1215613 g17294 i0 38.5 0.945454545454545 52 32 94.5 0 158 3 521 572 MES1911260.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 47.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31897956 31897956 PRJEB14664_P_NODE_9337_length_254_cov_0.913242_g9207_i0 PRJEB14664 9337 254 0.913242 2.31963468 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 53.5 6.5e-6   NR MES1909771.1 1215613 g9207 i0 65.7 0.413385826771654 35 12 41.3 0 109 5 74 108 MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] diamond 105 53.5 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);;