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

5 rows where analysis = "blastn", bioproject = "PRJNA798511" 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
790710	790710	PRJNA798511_P_NODE_55661_length_333_cov_0.923077_g51395_i0	PRJNA798511	55661	333	0.923077	3.07384641	Parastrongyloides trichosuri	131310	Nematoda	Nematoda	60.2	1.88e-4	NTclustered	gi\|959095881\|ref\|NC_028620.1\|	131310	g51395	i0	81.579	0.228228228228228	76	10	22	4	91	163	8812	8886	Parastrongyloides trichosuri mitochondrial DNA, complete genome, isolate: KNP	blastn	76	60.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Parastrongyloides	Parastrongyloides trichosuri
10994653	10994653	PRJNA798511_P_NODE_52809_length_344_cov_1.354244_g48543_i0	PRJNA798511	52809	344	1.354244	4.65859936	Caenorhabditis briggsae	6238	Nematoda	Nematoda	52.8	0.033	NTclustered	gi\|11094947\|gb\|AC084497.1\|CBRG11J16	6238	g48543	i0	100	0.0813953488372093	28	0	8	0	180	207	14928	14901	Caenorhabditis briggsae cosmid G11J16, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
10994755	10994755	PRJNA798511_P_NODE_59549_length_319_cov_1.321138_g55283_i0	PRJNA798511	59549	319	1.321138	4.21443022	Caenorhabditis elegans	6239	Nematoda	Nematoda	58.4	6.43e-4	NTclustered	gi\|687865720\|emb\|LK927684.1\|	6239	g55283	i0	92.5	0.250783699059561	40	3	13	0	177	216	60412	60373	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000135	blastn	80	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12270400	12270400	PRJNA798511_P_NODE_76330_length_275_cov_0.925743_g72064_i0	PRJNA798511	76330	275	0.925743	2.54579325	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.007	NTclustered	gi\|687865919\|emb\|LK927926.1\|	6239	g72064	i0	96.97	0.24	33	0	12	1	122	153	8194	8162	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000341	blastn	66	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
25016861	25016861	PRJNA798511_P_NODE_38000_length_439_cov_0.795082_g33739_i0	PRJNA798511	38000	439	0.795082	3.49040998	Caenorhabditis elegans	6239	Nematoda	Nematoda	56.5	0.003	NTclustered	gi\|687866076\|emb\|LK928113.1\|	6239	g33739	i0	96.97	0.214123006833713	33	1	8	0	332	364	12378	12346	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000106	blastn	94	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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