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

6 rows where bioproject = "PRJNA492406", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"

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
2374785	2374785	PRJNA492406_P_NODE_26242_length_252_cov_1.508380_g25943_i0	PRJNA492406	26242	252	1.50838	3.8011176	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	117	7.99e-22	NTclustered	gi\|74039647\|gb\|DQ118092.1\|	342808	g25943	i0	86.667	6.96825396825397	105	14	42	0	3	107	513	409	Trimastix pyriformis ribosomal protein L7A mRNA, complete cds	blastn	1756	117	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27992512	27992512	PRJNA492406_P_NODE_15645_length_317_cov_1.459016_g15346_i0	PRJNA492406	15645	317	1.459016	4.62508072	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	50.8	2.57e-5	NR	KAK2953571.1	2049346	g15346	i0	42.1	0.539432176656151	57	30	51.1	1	284	123	64	120	KAK2953571.1 putative microtubule binding protein [Blattamonas nauphoetae]	diamond	171	50.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
29097601	29097601	PRJNA492406_P_NODE_26428_length_251_cov_1.544944_g26129_i0	PRJNA492406	26428	251	1.544944	3.87780944	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	100	1.62e-25	NR	KAA6379614.1	222440	g26129	i0	56.6	2.79681274900398	83	36	99.2	0	251	3	11	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	702	100	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
29350149	29350149	PRJNA492406_P_NODE_20509_length_281_cov_1.403846_g20210_i0	PRJNA492406	20509	281	1.403846	3.94480726	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	51.6	4.69e-5	NR	KAJ4462339.1	342808	g20210	i0	40.5	0.896797153024911	84	42	83.3	5	259	26	791	872	KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis]	diamond	252	51.6	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30613412	30613412	PRJNA492406_P_NODE_28113_length_248_cov_1.062857_g27814_i0	PRJNA492406	28113	248	1.062857	2.63588536	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	43.1	0.0282	NR	KAA6362374.1	222440	g27814	i0	31.1	0.737903225806452	61	40	71.4	1	248	72	238	298	KAA6362374.1 MAG: hypothetical protein EZS28_042099, partial [Streblomastix strix]	diamond	183	43.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30866228	30866228	PRJNA492406_P_NODE_23494_length_266_cov_1.424870_g23195_i0	PRJNA492406	23494	266	1.42487	3.7901542	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	70.5	8.68e-12	NR	KAJ4459234.1	342808	g23195	i0	37.5	3.04511278195489	88	54	98.1	1	1	261	186	273	KAJ4459234.1 putative Growth hormone-regulated TBC protein 1 [Paratrimastix pyriformis]	diamond	810	70.5	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis

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