metadata: contig_metadata: 8 rows where bioproject = "PRJNA1111146" and tax

8 rows where bioproject = "PRJNA1111146" 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
216256	216256	PRJNA1111146_P_NODE_305521_length_186_cov_1.278195_g304383_i0	PRJNA1111146	305521	186	1.278195	2.3774427	Mermithidae sp. XT-2021	2814110	Nematoda	Nematoda	73.1	1.22e-8	NTclustered	gi\|1993669213\|gb\|MW653323.1\|	2814110	g304383	i0	93.75	25.4408602150538	48	3	26	0	139	186	462	509	Mermithidae sp. XT-2021 voucher Mermithid-eriosoma auratum-2017 large subunit ribosomal RNA gene, partial sequence	blastn	4732	73.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Mermithida	Mermithidae		Mermithidae sp. XT-2021
6594694	6594694	PRJNA1111146_P_NODE_356286_length_182_cov_0.875969_g355148_i0	PRJNA1111146	356286	182	0.875969	1.59426358	Caenorhabditis remanei	31234	Nematoda	Nematoda	222	1.11e-53	NTclustered	gi\|2445347854\|ref\|XM_003109090.2\|	31234	g355148	i0	91.358	13.4395604395604	162	14	89	0	20	181	1137	1298	Caenorhabditis remanei uncharacterized protein (GCK72_000540), partial mRNA	blastn	2446	222	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
27817352	27817352	PRJNA1111146_P_NODE_280244_length_190_cov_2.087591_g279106_i0	PRJNA1111146	280244	190	2.087591	3.9664229	Opisthokonta	33154	Nematoda	Nematoda	92.4	1.35e-20	NR	CDJ95608.1	6289	g279106	i0	66.7	18.0473684210526	60	19	94.7	1	181	2	3	61	CDJ95608.1 Ribosomal protein L37e domain containing protein [Haemonchus contortus]	diamond	3429	92.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus contortus
28457547	28457547	PRJNA1111146_P_NODE_324126_length_184_cov_0.870229_g322988_i0	PRJNA1111146	324126	184	0.870229	1.60122136	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	126	3.96e-32	NR	KAE9549987.1	2598192	g322988	i0	93.3	0.978260869565217	60	4	97.8	0	3	182	75	134	KAE9549987.1 hypothetical protein FO519_006807 [Halicephalobus sp. NKZ332]	diamond	180	126	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
29404675	29404675	PRJNA1111146_P_NODE_434749_length_177_cov_0.911290_g433611_i0	PRJNA1111146	434749	177	0.91129	1.6129833	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	98.2	4.04e-22	NR	KAE9551092.1	2598192	g433611	i0	72.4	0.983050847457627	58	16	98.3	0	175	2	219	276	KAE9551092.1 hypothetical protein FO519_005689 [Halicephalobus sp. NKZ332]	diamond	174	98.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
31996090	31996090	PRJNA1111146_P_NODE_69958_length_265_cov_1.358491_g68820_i0	PRJNA1111146	69958	265	1.358491	3.60000115	Aphelenchoides besseyi	269767	Nematoda	Nematoda	52.4	1.96e-5	NR	KAI6178625.1	269767	g68820	i0	47.8	0.781132075471698	69	35	77	1	264	61	426	494	KAI6178625.1 Cyclin domain protein [Aphelenchoides besseyi]	diamond	207	52.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
32439270	32439270	PRJNA1111146_P_NODE_283379_length_190_cov_1.248175_g282241_i0	PRJNA1111146	283379	190	1.248175	2.3715325	Caenorhabditis brenneri	135651	Nematoda	Nematoda	118	3.66e-29	NR	EGT30756.1	135651	g282241	i0	93.5	0.978947368421053	62	4	97.9	0	3	188	1235	1296	EGT30756.1 hypothetical protein CAEBREN_28118 [Caenorhabditis brenneri]	diamond	186	118	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
32565851	32565851	PRJNA1111146_P_NODE_368919_length_181_cov_0.890625_g367781_i0	PRJNA1111146	368919	181	0.890625	1.61203125	Caenorhabditis brenneri	135651	Nematoda	Nematoda	57.4	1.06e-7	NR	EGT43234.1	135651	g367781	i0	62.8	0.712707182320442	43	16	71.3	0	149	21	394	436	EGT43234.1 CBN-NHR-137 protein [Caenorhabditis brenneri]	diamond	129	57.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri

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