metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax

10 rows where analysis = "diamond", bioproject = "PRJDB12578" 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
1279364	1279364	PRJDB12578_S_NODE_30022_length_1695_cov_11.962940_g7957_i1	PRJDB12578	30022	1695	11.96294	202.771833	Caenorhabditis elegans	6239	Nematoda	Nematoda	1000	0	NR	pir\|C88628\|	6239	g7957	i1	96.3	0.946902654867257	535	13	94.5	3	2	1603	31	559	pir\|C88628\| protein W03G1.4 [imported] - Caenorhabditis elegans [Caenorhabditis elegans]	diamond	1605	1000	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
1279848	1279848	PRJDB12578_S_NODE_39182_length_1274_cov_9.118367_g21885_i0	PRJDB12578	39182	1274	9.118367	116.16799558	Caenorhabditis elegans	6239	Nematoda	Nematoda	796	5.449999999999998e-290	NR	pir\|T34000\|	6239	g21885	i0	99.8	0.974882260596546	414	1	97.5	0	1256	15	1	414	pir\|T34000\| hypothetical protein W03G1.3 - Caenorhabditis elegans [Caenorhabditis elegans]	diamond	1242	796	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
8931699	8931699	PRJDB12578_S_NODE_22088_length_2192_cov_9.886608_g11345_i0	PRJDB12578	22088	2192	9.886608	216.71444736	Caenorhabditis brenneri	135651	Nematoda	Nematoda	1052	0	NR	CAL2029929.1	135651	g11345	i0	89.7	0.85264598540146	623	49	85.3	5	48	1916	20	627	CAL2029929.1 unnamed protein product [Caenorhabditis brenneri]	diamond	1869	1052	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
27121025	27121025	PRJDB12578_S_NODE_114762_length_253_cov_2.093137_g91704_i0	PRJDB12578	114762	253	2.093137	5.29563661	Trichinella	6333	Nematoda	Nematoda	97.4	1.54e-21	NR	KRX14696.1	6336	g91704	i0	54.9	11.6679841897233	82	32	91.3	1	232	2	44	125	KRX14696.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Trichinella nelsoni]	diamond	2952	97.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nelsoni
28074638	28074638	PRJDB12578_S_NODE_75705_length_432_cov_1.323760_g52655_i0	PRJDB12578	75705	432	1.32376	5.7186432	Trichuris suis	68888	Nematoda	Nematoda	77.8	1.5e-13	NR	KFD60897.1	68888	g52655	i0	31.8	1.75694444444444	129	83	86.1	1	376	5	136	264	KFD60897.1 hypothetical protein M514_26958 [Trichuris suis]	diamond	759	77.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
30348881	30348881	PRJDB12578_S_NODE_126112_length_233_cov_0.804348_g103054_i0	PRJDB12578	126112	233	0.804348	1.87413084	Caenorhabditis elegans	6239	Nematoda	Nematoda	50.1	8.47e-5	NR	NP_001369855.1	6239	g103054	i0	45.8	0.927038626609442	72	20	92.7	1	219	4	87	139	NP_001369855.1 Protein tyrosine phosphatase-like protein egg-3 [Caenorhabditis elegans]	diamond	216	50.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
30727415	30727415	PRJDB12578_S_NODE_117674_length_248_cov_0.758794_g94616_i0	PRJDB12578	117674	248	0.758794	1.88180912	Caenorhabditis elegans	6239	Nematoda	Nematoda	60.5	1.48e-8	NR	NP_001022086.1	6239	g94616	i0	78	0.495967741935484	41	9	49.6	0	246	124	226	266	NP_001022086.1 BTB domain-containing protein [Caenorhabditis elegans]	diamond	123	60.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32049570	32049570	PRJDB12578_S_NODE_204358_length_165_cov_1.284483_g181300_i0	PRJDB12578	204358	165	1.284483	2.11939695	Haemonchus	6288	Nematoda	Nematoda	66.2	5.57e-11	NR	AAD34306.1	6289	g181300	i0	60.8	8.38181818181818	51	20	92.7	0	164	12	104	154	AAD34306.1 transposase homolog [Haemonchus contortus]	diamond	1383	66.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus contortus
32308924	32308924	PRJDB12578_S_NODE_129239_length_228_cov_0.865922_g106181_i0	PRJDB12578	129239	228	0.865922	1.97430216	Caenorhabditis elegans	6239	Nematoda	Nematoda	77	2.13e-14	NR	NP_494505.4	6239	g106181	i0	83.3	0.552631578947368	42	7	55.3	0	1	126	326	367	NP_494505.4 CUB_2 domain-containing protein [Caenorhabditis elegans]	diamond	126	77	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32624611	32624611	PRJDB12578_S_NODE_114140_length_255_cov_0.839806_g91082_i0	PRJDB12578	114140	255	0.839806	2.1415053	Caenorhabditis elegans	6239	Nematoda	Nematoda	57.4	2.29e-7	NR	NP_496441.1	6239	g91082	i0	71.1	1.37647058823529	38	11	44.7	0	175	62	1	38	NP_496441.1 putative splicing factor, arginine/serine-rich 2 [Caenorhabditis elegans]	diamond	351	57.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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