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

5 rows where analysis = "blastn", bioproject = "PRJNA874604" 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
3402404	3402404	PRJNA874604_P_NODE_32163_length_336_cov_0.878327_g31811_i0	PRJNA874604	32163	336	0.878327	2.95117872	Diplogastrellus gracilis	669117	Nematoda	Nematoda	204	8.269999999999999e-48	NTclustered	gi\|256709130\|gb\|GQ422217.1\|	669117	g31811	i0	79.795	74.0714285714286	292	49	85	8	8	294	713	427	Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	24888	204	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus gracilis
5955337	5955337	PRJNA874604_P_NODE_50965_length_282_cov_1.473684_g50613_i0	PRJNA874604	50965	282	1.473684	4.15578888	Parapristionchus giblindavisi	1187980	Nematoda	Nematoda	126	1.51e-24	NTclustered	gi\|387600374\|gb\|JQ677919.1\|	1187980	g50613	i0	87.963	2.5709219858156	108	11	38	2	8	114	292	398	Diplogastridae gen. sp. EJR-2012 small ribosomal protein 14 mRNA, partial cds	blastn	725	126	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Parapristionchus	Parapristionchus giblindavisi
12330490	12330490	PRJNA874604_P_NODE_15410_length_448_cov_2.784000_g15058_i0	PRJNA874604	15410	448	2.784	12.47232	Koerneria sp. RS1982	358044	Nematoda	Nematoda	348	4.940000000000001e-91	NTclustered	gi\|150984497\|gb\|EF634891.1\|	358044	g15058	i0	83.696	80.1696428571429	368	60	82	0	1	368	414	47	Koerneria sp. RS1982 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	35916	348	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Koerneria	Koerneria sp. RS1982
17430194	17430194	PRJNA874604_P_NODE_49954_length_284_cov_1.459716_g49602_i0	PRJNA874604	49954	284	1.459716	4.14559344	Fictor sp. 2 VS-2014	1538695	Nematoda	Nematoda	228	4.059999999999999e-55	NTclustered	gi\|675119079\|gb\|KJ877419.1\|	1538695	g49602	i0	83.333	43.1197183098592	246	41	87	0	20	265	54	299	Fictor sp. 2 VS-2014 strain RS9002 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	12246	228	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Fictor	Fictor sp. 2 VS-2014
18702884	18702884	PRJNA874604_P_NODE_19935_length_403_cov_3.548485_g19583_i0	PRJNA874604	19935	403	3.548485	14.30039455	Pristionchus pauli	376545	Nematoda	Nematoda	276	2.11e-69	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g19583	i0	81.395	5.43424317617866	344	58	85	6	1	341	377	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2190	276	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli

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