metadata: contig_metadata: 4 rows where bioproject = "PRJNA1111077", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA1111077", tax_kingdom = "Metazoa" 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
5317566	5317566	PRJNA1111077_P_NODE_23645_length_274_cov_4.124378_g23424_i0	PRJNA1111077	23645	274	4.124378	11.30079572	Metazoa	33208	Nematoda	Nematoda	154	2.16e-43	NR	NP_492108.1	6239	g23424	i0	76.7	104.463503649635	90	21	98.5	0	2	271	202	291	NP_492108.1 Guanine nucleotide-binding protein G(o) subunit alpha [Caenorhabditis elegans]	diamond	28623	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6592928	6592928	PRJNA1111077_P_NODE_29966_length_251_cov_1.719101_g29745_i0	PRJNA1111077	29966	251	1.719101	4.31494351	Opisthokonta	33154	Nematoda	Nematoda	139	1.8e-40	NR	XP_024505625.1	34506	g29745	i0	88	54.5498007968127	83	10	99.2	0	249	1	23	105	XP_024505625.1 Histone H2A.v [Strongyloides ratti]	diamond	13692	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
23166883	23166883	PRJNA1111077_P_NODE_18659_length_291_cov_3.000000_g18438_i0	PRJNA1111077	18659	291	3	8.73	Opisthokonta	33154	Nematoda	Nematoda	144	6.43e-38	NR	KRY35830.1	6334	g18438	i0	75	115.773195876289	96	22	99	1	3	290	63	156	KRY35830.1 60S ribosomal protein L5 [Trichinella spiralis]	diamond	33690	145	0.993103448275862	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
27257419	27257419	PRJNA1111077_P_NODE_29183_length_254_cov_1.701657_g28962_i0	PRJNA1111077	29183	254	1.701657	4.32220878	Meloidogyne graminicola	189291	Nematoda	Nematoda	74.7	1.03e-13	NR	AVZ46778.1	189291	g28962	i0	55.7	0.933070866141732	79	34	92.1	1	245	12	168	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	237	74.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola

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