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

5 rows where analysis = "blastn", bioproject = "PRJNA971676" 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
944672	944672	PRJNA971676_P_NODE_21541_length_243_cov_0.905882_g21452_i0	PRJNA971676	21541	243	0.905882	2.20129326	Meloidogyne incognita	6306	Nematoda	Nematoda	440	4e-119	NTclustered	gi\|185534914\|gb\|EU475875.1\|	6306	g21452	i0	99.585	2.98765432098765	241	1	99	0	3	243	1465	1225	Meloidogyne incognita xylanase 2 (xyl2) gene, partial cds	blastn	726	440	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne incognita
2219836	2219836	PRJNA971676_P_NODE_11222_length_275_cov_0.905941_g11133_i0	PRJNA971676	11222	275	0.905941	2.49133775	Meloidogyne enterolobii	390850	Nematoda	Nematoda	446	9.92e-121	NTclustered	gi\|574960920\|gb\|KF739434.1\|	390850	g11133	i0	96.364	1	275	2	99	5	4	275	2115	1846	Meloidogyne enterolobii heat shock protein 70 (Hsp70) mRNA, complete cds	blastn	275	446	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
4773129	4773129	PRJNA971676_P_NODE_6564_length_335_cov_1.763359_g6475_i0	PRJNA971676	6564	335	1.763359	5.90725265	Pristionchus pauli	376545	Nematoda	Nematoda	189	2.31e-43	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g6475	i0	79.348	3.7134328358209	276	51	81	6	1	273	309	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	1244	189	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
7644520	7644520	PRJNA971676_P_NODE_3126_length_444_cov_2.628032_g3037_i0	PRJNA971676	3126	444	2.628032	11.66846208	Metazoa	33208	Nematoda	Nematoda	324	8.25e-84	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g3037	i0	82.692	80.1171171171171	364	63	82	0	74	437	55	418	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	35572	327	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
17522777	17522777	PRJNA971676_P_NODE_3154_length_442_cov_1.252033_g3065_i0	PRJNA971676	3154	442	1.252033	5.53398586	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	167	1.46e-36	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g3065	i0	81.166	30.1764705882353	223	28	49	11	171	386	264	49	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	13338	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus

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