metadata: contig_metadata: 5 rows where bioproject = "PRJNA564810", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA564810", 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
17131872	17131872	PRJNA564810_S_NODE_3434_length_286_cov_10.402715_g3412_i0	PRJNA564810	3434	286	10.402715	29.7517649	Pristionchus sp. 14 RS5230	452808	Nematoda	Nematoda	110	1.55e-19	NTclustered	gi\|150984645\|gb\|EF634984.1\|	452808	g3412	i0	80.851	0.881118881118881	141	25	49	2	4	143	100	239	Pristionchus sp. 14 RS5230 small subunit ribosomal protein 27 (rps-27) mRNA, complete cds	blastn	252	110	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 14 RS5230
22231287	22231287	PRJNA564810_S_NODE_7958_length_213_cov_2.304054_g7936_i0	PRJNA564810	7958	213	2.304054	4.90763502	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	147	8.359999999999999e-31	NTclustered	gi\|150982251\|gb\|EF634714.1\|	452805	g7936	i0	85.612	23.9014084507042	139	20	65	0	75	213	303	165	Pristionchus sp. 10 RS5133 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	5091	147	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
26952583	26952583	PRJNA564810_S_NODE_4942_length_255_cov_1.278947_g4920_i0	PRJNA564810	4942	255	1.278947	3.26131485	Caenorhabditis angaria	860376	Nematoda	Nematoda	74.3	1.53e-13	NR	CAI5442046.1	860376	g4920	i0	74.4	1.51764705882353	43	11	50.6	0	2	130	240	282	CAI5442046.1 unnamed protein product [Caenorhabditis angaria]	diamond	387	74.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis angaria
27725232	27725232	PRJNA564810_S_NODE_7764_length_215_cov_1.813333_g7742_i0	PRJNA564810	7764	215	1.813333	3.89866595	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.5	0.00251	NR	VDM46313.1	6265	g7742	i0	46.3	5.3302325581395396	41	18	57.2	1	1	123	25	61	VDM46313.1 unnamed protein product [Toxocara canis]	diamond	1146	43.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
32324304	32324304	PRJNA564810_S_NODE_7019_length_223_cov_0.860759_g6997_i0	PRJNA564810	7019	223	0.860759	1.91949257	Caenorhabditis remanei	31234	Nematoda	Nematoda	47	9.31e-4	NR	XP_053584999.1	31234	g6997	i0	50	1.46636771300448	54	24	72.6	1	168	7	540	590	XP_053584999.1 hypothetical protein GCK72_014290 [Caenorhabditis remanei]	diamond	327	47	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei

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