metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA484127" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA484127" and tax_clade = "Metamonada"

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
26855015	26855015	PRJNA484127_P_NODE_15121_length_327_cov_1.669291_g14972_i0	PRJNA484127	15121	327	1.669291	5.45858157	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	115	2.9800000000000003e-27	NR	KAJ5066874.1	1746090	g14972	i0	53.3	2.94495412844037	107	50	98.2	0	3	323	1160	1266	KAJ5066874.1 alpha-actinin [Anaeramoeba ignava]	diamond	963	115	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27756024	27756024	PRJNA484127_P_NODE_31984_length_250_cov_0.881356_g31835_i0	PRJNA484127	31984	250	0.881356	2.20339	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	105	1.29e-26	NR	KAA6388004.1	222440	g31835	i0	55.6	2.916	81	36	97.2	0	248	6	87	167	KAA6388004.1 MAG: putative Translationally-controlled tumor protein [Streblomastix strix]	diamond	729	105	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28718555	28718555	PRJNA484127_P_NODE_25267_length_269_cov_2.091837_g25118_i0	PRJNA484127	25267	269	2.091837	5.62704153	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	51.6	1.7e-5	NR	KAK2956265.1	2049346	g25118	i0	66.7	0.401486988847584	36	12	40.1	0	268	161	130	165	KAK2956265.1 putative 60S ribosomal protein L18-3 [Blattamonas nauphoetae]	diamond	108	51.6	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
28781428	28781428	PRJNA484127_P_NODE_35067_length_246_cov_1.410405_g34918_i0	PRJNA484127	35067	246	1.410405	3.4695963	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	52.8	1.13e-5	NR	KAJ4463103.1	342808	g34918	i0	45.8	2.96341463414634	59	28	72	1	178	2	182	236	KAJ4463103.1 putative Hydroxylamine reductase [Paratrimastix pyriformis]	diamond	729	52.8	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29728568	29728568	PRJNA484127_P_NODE_16770_length_315_cov_0.946281_g16621_i0	PRJNA484127	16770	315	0.946281	2.98078515	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	66.6	3.76e-10	NR	KAJ3442778.1	1746091	g16621	i0	34.6	4.8952380952381	104	68	99	0	1	312	491	594	KAJ3442778.1 alpha-actinin sarcomeric-like protein [Anaeramoeba flamelloides]	diamond	1542	66.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31024200	31024200	PRJNA484127_P_NODE_14475_length_332_cov_2.123552_g14326_i0	PRJNA484127	14475	332	2.123552	7.05019264	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	87.8	1.72e-17	NR	KAJ4461259.1	342808	g14326	i0	42.4	1.8433734939759	99	56	88.6	1	310	17	1106	1204	KAJ4461259.1 putative MFS-type transporter [Paratrimastix pyriformis]	diamond	612	87.8	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31688116	31688116	PRJNA484127_P_NODE_25797_length_267_cov_1.556701_g25648_i0	PRJNA484127	25797	267	1.556701	4.15639167	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	77.8	2.32e-14	NR	KAJ5066873.1	1746090	g25648	i0	48.3	1.95505617977528	87	45	97.8	0	265	5	857	943	KAJ5066873.1 alpha-actinin [Anaeramoeba ignava]	diamond	522	77.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
31688120	31688120	PRJNA484127_P_NODE_5937_length_473_cov_1.675000_g5789_i0	PRJNA484127	5937	473	1.675	7.92275	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	161	1.77e-42	NR	KAJ5076917.1	1746090	g5789	i0	57.4	6.74207188160677	155	65	98.3	1	1	465	283	436	KAJ5076917.1 alpha-actinin-2 [Anaeramoeba ignava]	diamond	3189	161	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava

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