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

7 rows where analysis = "diamond", bioproject = "PRJNA473201" 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
20844950	20844950	PRJNA473201_P_NODE_11797_length_587_cov_0.832685_g11060_i0	PRJNA473201	11797	587	0.832685	4.88786095	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	236	1.03e-72	NR	VDN92629.1	6280	g11060	i0	69.1	12.2810902896082	162	50	82.8	0	101	586	289	450	VDN92629.1 unnamed protein product [Brugia pahangi]	diamond	7209	237	0.9957805907173	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia pahangi
28718446	28718446	PRJNA473201_P_NODE_62967_length_258_cov_1.664865_g62225_i0	PRJNA473201	62967	258	1.664865	4.2953517	Aphelenchoides bicaudatus	293665	Nematoda	Nematoda	109	2.2e-27	NR	KAI6182696.1	293665	g62225	i0	65.4	2.80232558139535	81	28	94.2	0	245	3	15	95	KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus]	diamond	723	109	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus
28860716	28860716	PRJNA473201_P_NODE_63428_length_257_cov_1.331522_g62686_i0	PRJNA473201	63428	257	1.331522	3.42201154	Aphelenchoides	90723	Nematoda	Nematoda	62	2.36e-9	NR	KAI6211714.1	269767	g62686	i0	65.1	4.59922178988327	43	15	50.2	0	252	124	151	193	KAI6211714.1 50S ribosomal protein L5 [Aphelenchoides besseyi]	diamond	1182	62	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
28923824	28923824	PRJNA473201_P_NODE_82048_length_243_cov_0.905882_g81306_i0	PRJNA473201	82048	243	0.905882	2.20129326	Nematoda	6231	Nematoda	Nematoda	97.8	6.13e-25	NR	NP_001379573.1	6239	g81306	i0	71.4	13.0864197530864	56	16	69.1	0	239	72	1	56	NP_001379573.1 Small ribosomal subunit protein uS14 [Caenorhabditis elegans]	diamond	3180	97.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
30282293	30282293	PRJNA473201_P_NODE_74392_length_247_cov_0.885057_g73650_i0	PRJNA473201	74392	247	0.885057	2.18609079	Metazoa	33208	Nematoda	Nematoda	99.8	2.63e-22	NR	CAD5222489.1	6326	g73650	i0	64	17.3562753036437	75	27	91.1	0	1	225	54	128	CAD5222489.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	4287	100	0.998	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
30314059	30314059	PRJNA473201_P_NODE_79552_length_244_cov_0.900585_g78810_i0	PRJNA473201	79552	244	0.900585	2.1974274	Trichostrongylidae	6315	Nematoda	Nematoda	62.8	1.16e-10	NR	KAK6009138.1	6317	g78810	i0	50	2.4344262295082	66	31	81.1	1	198	1	2	65	KAK6009138.1 acyl CoA binding protein, partial [Ostertagia ostertagi]	diamond	594	62.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi
31656224	31656224	PRJNA473201_P_NODE_32037_length_350_cov_1.050542_g31295_i0	PRJNA473201	32037	350	1.050542	3.676897	Meloidogyne graminicola	189291	Nematoda	Nematoda	53.5	1.66e-5	NR	AVZ46778.1	189291	g31295	i0	48.4	0.548571428571429	64	33	54.9	0	193	2	117	180	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	192	53.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola

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