metadata: contig_metadata: 6 rows where bioproject = "PRJNA692200", tax_clade = "Metamonada" and tax

6 rows where bioproject = "PRJNA692200", tax_clade = "Metamonada" 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_phylum	tax_order	tax_family	tax_genus	tax_species
3223460	3223460	PRJNA692200_S_NODE_12083_length_205_cov_41.480769_g12026_i0	PRJNA692200	12083	205	41.480769	85.03557645	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	95.3	2.93e-15	NTclustered	gi\|1270119057\|gb\|MG264531.1\|	2049346	g12026	i0	88.75	44.7560975609756	80	5	39	4	127	205	146	222	Blattamonas nauphoetae strain Z61EP small subunit ribosomal RNA gene, partial sequence	blastn	9175	95.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
22350371	22350371	PRJNA692200_S_NODE_938_length_448_cov_830.137845_g895_i0	PRJNA692200	938	448	830.137845	3719.0175456	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	125	4.21e-33	NR	XP_068360038.1	1144522	g895	i0	53.3	3.20758928571429	120	56	80.4	0	442	83	58	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	1437	125	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28030207	28030207	PRJNA692200_S_NODE_505_length_503_cov_19.074890_g472_i0	PRJNA692200	505	503	19.07489	95.9466967	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	75.1	3.51e-13	NR	KAJ5073093.1	1746090	g472	i0	71.7	0.31610337972167	53	15	31.6	0	3	161	152	204	KAJ5073093.1 ribosomal protein L15 [Anaeramoeba ignava]	diamond	159	75.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28440727	28440727	PRJNA692200_S_NODE_21886_length_162_cov_1.938053_g21829_i0	PRJNA692200	21886	162	1.938053	3.13964586	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	42	0.0243	NR	KAJ5073099.1	1746090	g21829	i0	46.9	0.592592592592593	32	17	59.3	0	135	40	803	834	KAJ5073099.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava]	diamond	96	42	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30177278	30177278	PRJNA692200_S_NODE_11452_length_211_cov_1.259259_g11395_i0	PRJNA692200	11452	211	1.259259	2.65703649	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	47	7.7e-4	NR	XP_067766430.1	348837	g11395	i0	39.4	0.938388625592417	66	40	93.8	0	12	209	39	104	XP_067766430.1 putative flagellar associated protein [Spironucleus salmonicida]	diamond	198	47	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
32843339	32843339	PRJNA692200_S_NODE_1560_length_403_cov_23.420904_g1504_i0	PRJNA692200	1560	403	23.420904	94.38624312	root	1	Root_unresolved	Root_unresolved	114	3.63e-30	NR	KAA6379614.1	222440	g1504	i0	58.1	2.72456575682382	93	39	69.2	0	15	293	1	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1098	114	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix

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