metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA929522" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA929522" 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
905366	905366	PRJNA929522_S_NODE_6021_length_289_cov_0.847222_g5951_i0	PRJNA929522	6021	289	0.847222	2.44847158	Caenorhabditis elegans	6239	Nematoda	Nematoda	534	2.18e-147	NTclustered	gi\|1972225930\|ref\|NM_058275.7\|	6239	g5951	i0	100	8.02076124567474	289	0	100	0	1	289	651	363	Caenorhabditis elegans Large ribosomal subunit protein uL30 (rpl-7), mRNA	blastn	2318	534	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7283393	7283393	PRJNA929522_S_NODE_1446_length_546_cov_2.928118_g1376_i0	PRJNA929522	1446	546	2.928118	15.98752428	Caenorhabditis briggsae	6238	Nematoda	Nematoda	165	6.61e-36	NTclustered	gi\|268553420\|ref\|XM_002634650.1\|	6238	g1376	i0	80.365	1.1978021978022	219	42	40	1	61	279	13	230	Caenorhabditis briggsae Protein CBR-DLC-1 (Cbr-dlc-1), partial mRNA	blastn	654	165	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
7283440	7283440	PRJNA929522_S_NODE_6206_length_285_cov_1.089623_g6136_i0	PRJNA929522	6206	285	1.089623	3.10542555	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	254	6.72e-63	NTclustered	gi\|150982261\|gb\|EF634719.1\|	452809	g6136	i0	83.333	20.719298245614	276	42	96	4	11	284	303	30	Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	5905	254	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
7283451	7283451	PRJNA929522_S_NODE_7586_length_263_cov_1.063158_g7516_i0	PRJNA929522	7586	263	1.063158	2.79610554	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.024	NTclustered	gi\|1752837\|emb\|Z81031.1\|	6239	g7516	i0	100	0.212927756653992	28	0	11	0	61	88	12634	12607	Caenorhabditis elegans Cosmid C02D4, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18756877	18756877	PRJNA929522_S_NODE_3775_length_347_cov_2.656934_g3705_i0	PRJNA929522	3775	347	2.656934	9.21956098	Oigolaimella attenuata	669116	Nematoda	Nematoda	252	3.02e-62	NTclustered	gi\|256709322\|gb\|GQ422336.1\|	669116	g3705	i0	83.835	31.0720461095101	266	41	76	2	1	265	306	42	Oigolaimella attenuata large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	10782	252	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Oigolaimella	Oigolaimella attenuata
21307392	21307392	PRJNA929522_S_NODE_1137_length_604_cov_3.625235_g1071_i0	PRJNA929522	1137	604	3.625235	21.8964194	Pristionchus americanus	376549	Nematoda	Nematoda	224	1.1999999999999998e-53	NTclustered	gi\|150982255\|gb\|EF634716.1\|	376549	g1071	i0	81.522	35.8476821192053	276	47	45	4	62	335	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

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