metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA682370" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA682370" 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
17242303	17242303	PRJNA682370_S_NODE_23734_length_152_cov_1.017094_g23122_i0	PRJNA682370	23734	152	1.017094	1.54598288	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	93.6	6.71e-21	NR	KAE9418232.1	6313	g23122	i0	83.7	13.5592105263158	49	8	96.7	0	147	1	198	246	KAE9418232.1 hypothetical protein Angca_003480, partial [Angiostrongylus cantonensis]	diamond	2061	94.4	0.991525423728813	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
30536074	30536074	PRJNA682370_S_NODE_14453_length_188_cov_2.986928_g13841_i0	PRJNA682370	14453	188	2.986928	5.61542464	Rhabditida	6236	Nematoda	Nematoda	84.3	3.26e-18	NR	NP_491061.1	6239	g13841	i0	62.9	11.8723404255319	62	23	98.9	0	2	187	133	194	NP_491061.1 Large ribosomal subunit protein uL1 [Caenorhabditis elegans]	diamond	2232	84.7	0.995277449822904	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
30745629	30745629	PRJNA682370_S_NODE_4274_length_390_cov_2.760563_g3663_i0	PRJNA682370	4274	390	2.760563	10.7661957	Loa loa	7209	Nematoda	Nematoda	84.7	2.89e-17	NR	XP_003139952.1	7209	g3663	i0	60	0.576923076923077	75	30	57.7	0	4	228	134	208	XP_003139952.1 50S ribosomal protein L16 [Loa loa]	diamond	225	84.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Loa	Loa loa
31642252	31642252	PRJNA682370_S_NODE_16876_length_174_cov_1.992806_g16264_i0	PRJNA682370	16876	174	1.992806	3.46748244	Rhabditida	6236	Nematoda	Nematoda	46.2	5.26e-4	NR	ETN72628.1	51031	g16264	i0	54.5	1.8448275862069	33	15	56.9	0	15	113	119	151	ETN72628.1 glutathione S-transferase protein, partial [Necator americanus]	diamond	321	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
32180367	32180367	PRJNA682370_S_NODE_6738_length_298_cov_2.228137_g6126_i0	PRJNA682370	6738	298	2.228137	6.63984826	Caenorhabditis	6237	Nematoda	Nematoda	97.1	4.789999999999999e-23	NR	NP_741102.1	6239	g6126	i0	63	1.46979865771812	73	27	73.5	0	288	70	73	145	NP_741102.1 Ubiquitin-like protein 1 [Caenorhabditis elegans]	diamond	438	97.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32275343	32275343	PRJNA682370_S_NODE_9478_length_239_cov_4.014706_g8866_i0	PRJNA682370	9478	239	4.014706	9.59514734	root	1	Root_unresolved	Root_unresolved	49.7	4.06e-5	NR	KAI6184729.1	293665	g8866	i0	57.9	1.53138075313808	38	16	47.7	0	235	122	109	146	KAI6184729.1 Antioxidant, AhpC/TSA family [Aphelenchoides bicaudatus]	diamond	366	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus
32307112	32307112	PRJNA682370_S_NODE_13279_length_197_cov_1.228395_g12667_i0	PRJNA682370	13279	197	1.228395	2.41993815	Metazoa	33208	Nematoda	Nematoda	52	6.95e-6	NR	ULT87711.1	6238	g12667	i0	40.4	9.57868020304569	57	31	86.8	1	1	171	148	201	ULT87711.1 hypothetical protein L3Y34_007112 [Caenorhabditis briggsae]	diamond	1887	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae

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