metadata: contig_metadata: 6 rows where bioproject = "PRJNA951412", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA951412", tax_kingdom = "Metazoa" 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
8587803	8587803	PRJNA951412_P_NODE_607_length_597_cov_2.843511_g522_i0	PRJNA951412	607	597	2.843511	16.97576067	Pristionchus americanus	376549	Nematoda	Nematoda	224	1.18e-53	NTclustered	gi\|150982255\|gb\|EF634716.1\|	376549	g522	i0	81.522	36.2680067001675	276	47	46	4	51	324	30	303	Pristionchus americanus large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	21652	224	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus americanus
8587833	8587833	PRJNA951412_P_NODE_8107_length_236_cov_2.202454_g8022_i0	PRJNA951412	8107	236	2.202454	5.19779144	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	137	2.23e-35	NR	KRY33283.1	6334	g8022	i0	87	11.7457627118644	77	10	97.9	0	3	233	712	788	KRY33283.1 U3 small nucleolar RNA-associated protein 15 -like protein [Trichinella spiralis]	diamond	2772	138	0.992753623188406	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
11138490	11138490	PRJNA951412_P_NODE_649_length_569_cov_2.715726_g564_i0	PRJNA951412	649	569	2.715726	15.45248094	Pristionchus sp. 14 RS5230	452808	Nematoda	Nematoda	298	6.53e-76	NTclustered	gi\|150981879\|gb\|EF634509.1\|	452808	g564	i0	78.105	75.8892794376098	475	100	83	4	93	565	53	525	Pristionchus sp. 14 RS5230 large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds	blastn	43181	298	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 14 RS5230
27916442	27916442	PRJNA951412_P_NODE_2405_length_305_cov_1.879310_g2320_i0	PRJNA951412	2405	305	1.87931	5.7318955	Rhabditida	6236	Nematoda	Nematoda	113	1.46e-27	NR	NP_001369965.1	6239	g2320	i0	72.3	11.655737704918	65	18	63.9	0	301	107	281	345	NP_001369965.1 Peptidase C1A papain C-terminal domain-containing protein [Caenorhabditis elegans]	diamond	3555	113	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28983842	28983842	PRJNA951412_P_NODE_8088_length_237_cov_2.664634_g8003_i0	PRJNA951412	8088	237	2.664634	6.31518258	Steinernema hermaphroditum	289476	Nematoda	Nematoda	67	3.19e-11	NR	KAK0425702.1	289476	g8003	i0	43.4	2.72151898734177	76	42	96.2	1	235	8	59	133	KAK0425702.1 hypothetical protein QR680_009328 [Steinernema hermaphroditum]	diamond	645	67	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema hermaphroditum
32023664	32023664	PRJNA951412_P_NODE_6658_length_245_cov_0.906977_g6573_i0	PRJNA951412	6658	245	0.906977	2.22209365	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.1	4.68e-4	NR	TKR61705.1	34508	g6573	i0	44.8	1.42040816326531	67	35	79.6	2	211	17	50	116	TKR61705.1 hypothetical protein L596_028785 [Steinernema carpocapsae]	diamond	348	48.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae

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