metadata: contig_metadata: 6 rows where bioproject = "PRJNA1215813" and tax

6 rows where bioproject = "PRJNA1215813" 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
16908898	16908898	PRJNA1215813_P_NODE_3354_length_414_cov_16.524927_g3274_i0	PRJNA1215813	3354	414	16.524927	68.41319778	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.5	1.72e-18	NR	KAJ4453711.1	342808	g3274	i0	58.9	1.04347826086957	73	26	52.9	2	385	167	2	70	KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis]	diamond	432	85.5	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28399141	28399141	PRJNA1215813_P_NODE_12446_length_242_cov_0.923077_g12366_i0	PRJNA1215813	12446	242	0.923077	2.23384634	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	72.8	9.75e-13	NR	KAJ4455439.1	342808	g12366	i0	50.6	0.979338842975207	79	36	97.9	3	240	4	232	307	KAJ4455439.1 putative Thymus-specific serine protease [Paratrimastix pyriformis]	diamond	237	72.8	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28777889	28777889	PRJNA1215813_P_NODE_1627_length_582_cov_6.825147_g1549_i0	PRJNA1215813	1627	582	6.825147	39.72235554	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	80.5	8.17e-14	NR	KAA6394278.1	222440	g1549	i0	34.4	3.57731958762887	128	84	66	0	436	53	195	322	KAA6394278.1 MAG: hypothetical protein EZS28_010197, partial [Streblomastix strix]	diamond	2082	80.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28828234	28828234	PRJNA1215813_P_NODE_11508_length_245_cov_1.802326_g11428_i0	PRJNA1215813	11508	245	1.802326	4.4156987	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	83.6	1.22e-17	NR	KAJ4456542.1	342808	g11428	i0	54.1	1.75102040816327	74	34	90.6	0	23	244	35	108	KAJ4456542.1 putative dCTP deaminase [Paratrimastix pyriformis]	diamond	429	84.3	0.991696322657177	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29775475	29775475	PRJNA1215813_P_NODE_5211_length_338_cov_1.177358_g5131_i0	PRJNA1215813	5211	338	1.177358	3.97947004	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87.4	5.34e-18	NR	KAJ4454355.1	342808	g5131	i0	58.7	2.47633136094675	75	31	66.6	0	260	36	138	212	KAJ4454355.1 putative Signal transducing adapter molecule 2 [Paratrimastix pyriformis]	diamond	837	87.4	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30357568	30357568	PRJNA1215813_P_NODE_11152_length_247_cov_0.896552_g11072_i0	PRJNA1215813	11152	247	0.896552	2.21448344	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	72.8	1.07e-12	NR	KAJ4461259.1	342808	g11072	i0	41.8	0.959514170040486	79	44	96	1	237	1	1264	1340	KAJ4461259.1 putative MFS-type transporter [Paratrimastix pyriformis]	diamond	237	72.8	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);;