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

5 rows where analysis = "blastn", bioproject = "PRJNA811237" 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
7187101	7187101	PRJNA811237_S_NODE_5786_length_304_cov_4.615686_g5546_i0	PRJNA811237	5786	304	4.615686	14.03168544	Caenorhabditis briggsae	6238	Nematoda	Nematoda	97.1	1.29e-15	NTclustered	gi\|268531145\|ref\|XM_002630653.1\|	6238	g5546	i0	87.805	2.11513157894737	82	10	27	0	176	257	86	167	Caenorhabditis briggsae Protein CBR-PRDX-2 (Cbr-prdx-2), partial mRNA	blastn	643	97.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
9736842	9736842	PRJNA811237_S_NODE_18088_length_196_cov_2.850340_g17848_i0	PRJNA811237	18088	196	2.85034	5.5866664	Strongyloides ratti	34506	Nematoda	Nematoda	56.5	0.001	NTclustered	gi\|1376142617\|ref\|XM_024651632.1\|	34506	g17848	i0	100	0.530612244897959	30	0	15	0	56	85	1491	1462	Strongyloides ratti MIP20649p (SRAE_2000076000), partial mRNA	blastn	104	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
11012755	11012755	PRJNA811237_S_NODE_6249_length_295_cov_1.593496_g6009_i0	PRJNA811237	6249	295	1.593496	4.7008132	Caenorhabditis briggsae	6238	Nematoda	Nematoda	52.8	0.027	NTclustered	gi\|11094894\|gb\|AC084444.1\|AC084444	6238	g6009	i0	100	0.189830508474576	28	0	9	0	49	76	65589	65616	Caenorhabditis briggsae cosmid CB014E04, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
15251629	15251629	PRJNA811237_S_NODE_2352_length_472_cov_4.009456_g2113_i0	PRJNA811237	2352	472	4.009456	18.92463232	Pristionchus	54125	Nematoda	Nematoda	270	1.16e-67	NTclustered	gi\|390135472\|gb\|JQ399933.1\|	1195655	g2113	i0	80.938	69.8050847457627	341	63	72	2	93	432	53	392	Pristionchus arcanus large subunit ribosomal protein 1 (rpl-1) gene, partial cds	blastn	32948	270	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus arcanus
22901189	22901189	PRJNA811237_S_NODE_9458_length_248_cov_3.723618_g9218_i0	PRJNA811237	9458	248	3.723618	9.23457264	Opisthokonta	33154	Nematoda	Nematoda	171	5.94e-38	NTclustered	gi\|150982255\|gb\|EF634716.1\|	376549	g9218	i0	83.422	64.1653225806452	187	27	75	4	55	239	30	214	Pristionchus americanus large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	15913	172	0.994186046511628	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus americanus

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