metadata: contig_metadata: 6 rows where bioproject = "PRJNA657343", tax_clade = "Apusozoa" and tax

6 rows where bioproject = "PRJNA657343", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_order	tax_family	tax_genus	tax_species
17201181	17201181	PRJNA657343_P_NODE_43374_length_163_cov_0.912281_g43350_i0	PRJNA657343	43374	163	0.912281	1.48701803	Amastigomonas marina	234594	Root_unresolved	Root_unresolved	165	1.67e-36	NTclustered	gi\|31982973\|gb\|AY236711.1\|	234594	g43350	i0	89.844	31.2699386503067	128	13	79	0	24	151	409	536	Amastigomonas marina heat shock protein 90 (Hsp90) gene, partial cds	blastn	5097	165	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Amastigomonas	Amastigomonas marina
24849099	24849099	PRJNA657343_P_NODE_12360_length_248_cov_1.979899_g12336_i0	PRJNA657343	12360	248	1.979899	4.91014952	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	110	7.9e-26	NR	XP_013759314.1	461836	g12336	i0	73.2	7.25806451612903	71	19	85.9	0	6	218	478	548	XP_013759314.1 ATP-binding cassette transporter [Thecamonas trahens ATCC 50062]	diamond	1800	110	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
26923203	26923203	PRJNA657343_P_NODE_39902_length_165_cov_1.724138_g39878_i0	PRJNA657343	39902	165	1.724138	2.8448277	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	57	1.23e-7	NR	XP_013759900.1	461836	g39878	i0	53.8	0.945454545454545	52	24	94.5	0	165	10	59	110	XP_013759900.1 monooxygenase [Thecamonas trahens ATCC 50062]	diamond	156	57	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27156433	27156433	PRJNA657343_P_NODE_6562_length_313_cov_2.606061_g6538_i0	PRJNA657343	6562	313	2.606061	8.15697093	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	113	1.33e-28	NR	XP_013754328.1	461836	g6538	i0	54.4	6.91054313099042	103	47	98.7	0	311	3	48	150	XP_013754328.1 60S ribosomal protein L7 [Thecamonas trahens ATCC 50062]	diamond	2163	114	0.991228070175439	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27851546	27851546	PRJNA657343_P_NODE_9704_length_271_cov_1.585586_g9680_i0	PRJNA657343	9704	271	1.585586	4.29693806	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.4	0.00123	NR	XP_013760463.1	461836	g9680	i0	47.2	6.57564575645756	53	26	58.7	1	99	257	120	170	XP_013760463.1 uncharacterized protein AMSG_03132 [Thecamonas trahens ATCC 50062]	diamond	1782	47.8	0.99163179916318	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32452825	32452825	PRJNA657343_P_NODE_10039_length_267_cov_4.022936_g10015_i0	PRJNA657343	10039	267	4.022936	10.74123912	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	65.9	3.84e-10	NR	XP_013757117.1	461836	g10015	i0	44.6	0.831460674157303	74	37	83.1	1	4	225	1472	1541	XP_013757117.1 uncharacterized protein AMSG_11960 [Thecamonas trahens ATCC 50062]	diamond	222	65.9	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens

Advanced export

JSON shape: default, array, newline-delimited

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