metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA681822" 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
1930821	1930821	PRJNA681822_P_NODE_361222_length_257_cov_1.673913_g359733_i0	PRJNA681822	361222	257	1.673913	4.30195641	Laimaphelenchus sp. 1 YS-2019	2518478	Nematoda	Nematoda	268	2.1299999999999998e-67	NTclustered	gi\|1572817033\|gb\|MK511998.1\|	2518478	g359733	i0	85.714	72.7587548638132	259	31	100	6	1	257	556	810	Laimaphelenchus sp. 1 YS-2019 isolate SY small subunit ribosomal RNA gene, partial sequence	blastn	18699	268	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Laimaphelenchus	Laimaphelenchus sp. 1 YS-2019
5758523	5758523	PRJNA681822_P_NODE_371245_length_254_cov_1.701657_g369756_i0	PRJNA681822	371245	254	1.701657	4.32220878	Koerneria sp. RS1982	358044	Nematoda	Nematoda	145	3.7e-30	NTclustered	gi\|150982149\|gb\|EF634663.1\|	358044	g369756	i0	77.778	10.0826771653543	261	41	100	12	1	254	353	103	Koerneria sp. RS1982 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds	blastn	2561	145	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Koerneria	Koerneria sp. RS1982
7034521	7034521	PRJNA681822_P_NODE_451846_length_244_cov_0.900585_g450356_i0	PRJNA681822	451846	244	0.900585	2.1974274	Caenorhabditis elegans	6239	Nematoda	Nematoda	451	1.86e-122	NTclustered	gi\|1972266897\|ref\|NM_001028103.4\|	6239	g450356	i0	100	6.01229508196721	244	0	100	0	1	244	4975	4732	Caenorhabditis elegans Vitellogenin-6 (vit-6), mRNA	blastn	1467	451	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
8823724	8823724	PRJNA681822_P_NODE_389307_length_250_cov_2.610169_g387818_i0	PRJNA681822	389307	250	2.610169	6.5254225	Laimaphelenchus	288512	Nematoda	Nematoda	394	3.27e-105	NTclustered	gi\|1572817033\|gb\|MK511998.1\|	2518478	g387818	i0	96.624	95.396	237	8	95	0	1	237	457	221	Laimaphelenchus sp. 1 YS-2019 isolate SY small subunit ribosomal RNA gene, partial sequence	blastn	23849	394	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Laimaphelenchus	Laimaphelenchus sp. 1 YS-2019
18508108	18508108	PRJNA681822_P_NODE_457855_length_243_cov_1.811765_g456365_i0	PRJNA681822	457855	243	1.811765	4.40258895	Pristionchus arcanus	1195655	Nematoda	Nematoda	156	1.6200000000000002e-33	NTclustered	gi\|390135492\|gb\|JQ399943.1\|	1195655	g456365	i0	83.237	32.8312757201646	173	25	70	3	1	171	222	52	Pristionchus arcanus large subunit ribosomal protein 30 (rpl-30) gene, partial cds	blastn	7978	156	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus arcanus

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