metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Nematoda"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2000319	2000319	PRJNA745553_S_NODE_26162_length_243_cov_3.047059_g25967_i0	PRJNA745553	26162	243	3.047059	7.40435337	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	4.34e-36	NR	XP_024506366.1	34506	g25967	i0	69.4	20.7530864197531	85	21	98.8	1	242	3	244	328	XP_024506366.1 60S ribosomal protein L3 [Strongyloides ratti]	diamond	5043	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
14752975	14752975	PRJNA745553_S_NODE_1472_length_706_cov_10.413902_g1332_i0	PRJNA745553	1472	706	10.413902	73.52214812	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	332	5.08e-113	NR	VDP19351.1	241478	g1332	i0	75.7	13.2025495750708	206	50	87.5	0	677	60	1	206	VDP19351.1 unnamed protein product [Soboliphyme baturini]	diamond	9321	333	0.996996996996997	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
24950672	24950672	PRJNA745553_S_NODE_18920_length_284_cov_2.710900_g18725_i0	PRJNA745553	18920	284	2.7109	7.698956	Diploscapter pachys	2018661	Nematoda	Nematoda	68.9	9.59e-13	NR	PAV56235.1	2018661	g18725	i0	67.4	1.94366197183099	46	15	48.6	0	261	124	55	100	PAV56235.1 hypothetical protein WR25_15683 [Diploscapter pachys]	diamond	552	68.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
26873183	26873183	PRJNA745553_S_NODE_881_length_798_cov_6.798621_g769_i0	PRJNA745553	881	798	6.798621	54.25299558	root	1	Root_unresolved	Root_unresolved	186	2.84e-53	NR	KHN76811.1	6265	g769	i0	52.5	6.14285714285714	181	83	68	2	3	545	169	346	KHN76811.1 Malate dehydrogenase, cytoplasmic [Toxocara canis]	diamond	4902	187	0.994652406417112	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
27621577	27621577	PRJNA745553_S_NODE_29184_length_223_cov_4.060000_g28989_i0	PRJNA745553	29184	223	4.06	9.0538	Aphelenchoides bicaudatus	293665	Nematoda	Nematoda	42.4	0.0406	NR	KAI6190497.1	293665	g28989	i0	73.1	0.349775784753363	26	7	35	0	67	144	49	74	KAI6190497.1 U4/U6.U5 tri-snRNP-associated protein 1 [Aphelenchoides bicaudatus]	diamond	78	42.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus
29484053	29484053	PRJNA745553_S_NODE_5270_length_495_cov_4.867299_g5076_i0	PRJNA745553	5270	495	4.867299	24.09313005	Caenorhabditis angaria	860376	Nematoda	Nematoda	56.6	1.06e-6	NR	CAI5449474.1	860376	g5076	i0	49.1	1.87272727272727	53	24	30.3	2	488	339	50	102	CAI5449474.1 unnamed protein product [Caenorhabditis angaria]	diamond	927	56.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis angaria

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