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

8 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Discosea"

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
20994160	20994160	PRJNA613025_S_NODE_28117_length_174_cov_1.816000_g27963_i0	PRJNA613025	28117	174	1.816	3.15984	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	107	6.03e-26	NR	XP_004334335.1	1257118	g27963	i0	78.9	7.94827586206897	57	12	98.3	0	2	172	111	167	XP_004334335.1 actin related protein 2/3 complex, 41 kDa subunit [Acanthamoeba castellanii str. Neff]	diamond	1383	107	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
22268800	22268800	PRJNA613025_S_NODE_17098_length_249_cov_2.040000_g16944_i0	PRJNA613025	17098	249	2.04	5.0796	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	122	3.49e-33	NR	XP_004368153.1	1257118	g16944	i0	75	2.62650602409639	72	18	86.7	0	1	216	90	161	XP_004368153.1 ribosomal protein S17, putative [Acanthamoeba castellanii str. Neff]	diamond	654	122	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
24817730	24817730	PRJNA613025_S_NODE_10340_length_383_cov_4.182635_g10187_i0	PRJNA613025	10340	383	4.182635	16.01949205	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	132	5.42e-37	NR	1PRQ_A	5755	g10187	i0	62.6	1.67624020887728	107	39	83.8	1	376	56	20	125	1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii]	diamond	642	132	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
24817865	24817865	PRJNA613025_S_NODE_15600_length_270_cov_1.375566_g15446_i0	PRJNA613025	15600	270	1.375566	3.7140282	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	78.2	6.39e-16	NR	XP_004338635.1	1257118	g15446	i0	58.9	3.01111111111111	73	29	81.1	1	264	46	82	153	XP_004338635.1 60S ribosomal protein L36, putative [Acanthamoeba castellanii str. Neff]	diamond	813	78.2	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27016941	27016941	PRJNA613025_S_NODE_10202_length_388_cov_2.407080_g10049_i0	PRJNA613025	10202	388	2.40708	9.3394704	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	164	2.69e-49	NR	7SOG_A	5755	g10049	i0	63.9	0.920103092783505	119	43	92	0	8	364	17	135	7SOG_A Chain A, Actophorin [Acanthamoeba castellanii]	diamond	357	164	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27143100	27143100	PRJNA613025_S_NODE_26262_length_182_cov_1.533835_g26108_i0	PRJNA613025	26262	182	1.533835	2.7915797	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	84.3	4.55e-19	NR	XP_004333102.1	1257118	g26108	i0	80.8	1.71428571428571	52	10	85.7	0	178	23	81	132	XP_004333102.1 ribosomal protein L32, putative [Acanthamoeba castellanii str. Neff]	diamond	312	84.3	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27649045	27649045	PRJNA613025_S_NODE_24884_length_189_cov_1.092857_g24730_i0	PRJNA613025	24884	189	1.092857	2.06549973	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	87.4	1.54e-19	NR	XP_004356664.1	1257118	g24730	i0	72.9	1.52380952380952	48	13	76.2	0	1	144	151	198	XP_004356664.1 rho guanine dissociation factor isoform 2, putative [Acanthamoeba castellanii str. Neff]	diamond	288	87.4	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31976823	31976823	PRJNA613025_S_NODE_20078_length_219_cov_1.647059_g19924_i0	PRJNA613025	20078	219	1.647059	3.60705921	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	111	6.270000000000001e-27	NR	XP_004333651.1	1257118	g19924	i0	64.4	1	73	26	100	0	219	1	50	122	XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff]	diamond	219	111	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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