metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA971593" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
13698139	13698139	PRJNA971593_P_NODE_8991_length_405_cov_1.313253_g8842_i0	PRJNA971593	8991	405	1.313253	5.31867465	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	193	2.19e-44	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g8842	i0	77.848	22.9086419753086	316	66	78	3	64	377	329	16	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	9278	193	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
16247079	16247079	PRJNA971593_P_NODE_20993_length_257_cov_1.657609_g20844_i0	PRJNA971593	20993	257	1.657609	4.26005513	Necator americanus	51031	Nematoda	Nematoda	58.4	5.02e-4	NTclustered	gi\|2707571125\|ref\|XM_013453164.2\|	51031	g20844	i0	100	0.404669260700389	31	0	12	0	160	190	2673	2703	Necator americanus uncharacterized protein (RB195_009825), partial mRNA	blastn	104	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
16247180	16247180	PRJNA971593_P_NODE_28073_length_242_cov_1.751479_g27924_i0	PRJNA971593	28073	242	1.751479	4.23857918	Caenorhabditis remanei	31234	Nematoda	Nematoda	58.4	4.69e-4	NTclustered	gi\|2445351206\|ref\|XM_003111984.2\|	31234	g27924	i0	85	0.247933884297521	60	6	25	2	74	133	886	830	Caenorhabditis remanei uncharacterized protein (GCK72_002409), partial mRNA	blastn	60	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
22621361	22621361	PRJNA971593_P_NODE_21218_length_256_cov_1.032787_g21069_i0	PRJNA971593	21218	256	1.032787	2.64393472	Rotylenchulus reniformis	239373	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|264665091\|gb\|FJ906378.1\|	239373	g21069	i0	100	0.1171875	30	0	12	0	149	178	277	306	Rotylenchulus reniformis clone 246 microsatellite sequence	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Hoplolaimidae	Rotylenchulus	Rotylenchulus reniformis

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