metadata: contig_metadata: 5 rows where bioproject = "PRJNA565584", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA565584", tax_kingdom = "Metazoa" and tax_phylum = "Chaetognatha"

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
11338727	11338727	PRJNA565584_P_NODE_83829_length_325_cov_0.912698_g82677_i0	PRJNA565584	83829	325	0.912698	2.9662685	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	164	1.93e-49	NR	CAL69100.1	52888	g82677	i0	78.2	89.4830769230769	101	22	93.2	0	1	303	51	151	CAL69100.1 TPA: putative 40S ribosomal protein S14 [Spadella cephaloptera]	diamond	29082	165	0.993939393939394	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera
27364257	27364257	PRJNA565584_P_NODE_81303_length_330_cov_1.023346_g80151_i0	PRJNA565584	81303	330	1.023346	3.3770418	Parasagitta elegans	1562708	Chaetognatha	other_Eukaryota	161	1.34e-47	NR	ACU80593.1	1562708	g80151	i0	69.4	0.981818181818182	108	33	98.2	0	2	325	79	186	ACU80593.1 methionine adenosyltransferase, partial [Parasagitta elegans]	diamond	324	161	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Aphragmophora	Sagittidae	Parasagitta	Parasagitta elegans
29398301	29398301	PRJNA565584_P_NODE_72369_length_349_cov_1.673913_g71218_i0	PRJNA565584	72369	349	1.673913	5.84195637	Opisthokonta	33154	Chaetognatha	other_Eukaryota	118	7.54e-32	NR	CAL69114.1	52888	g71218	i0	57.8	10.7965616045845	109	45	93.7	1	344	18	1	108	CAL69114.1 TPA: putative 40S ribosomal protein S25 isoform 1 [Spadella cephaloptera]	diamond	3768	118	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera
32102460	32102460	PRJNA565584_P_NODE_103298_length_294_cov_1.040724_g102146_i0	PRJNA565584	103298	294	1.040724	3.05972856	Parasagitta elegans	1562708	Chaetognatha	other_Eukaryota	145	1.88e-41	NR	ACU80593.1	1562708	g102146	i0	66.3	0.969387755102041	95	32	96.9	0	292	8	50	144	ACU80593.1 methionine adenosyltransferase, partial [Parasagitta elegans]	diamond	285	145	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Aphragmophora	Sagittidae	Parasagitta	Parasagitta elegans
32356017	32356017	PRJNA565584_P_NODE_73979_length_345_cov_2.455882_g72828_i0	PRJNA565584	73979	345	2.455882	8.4727929	Spadella cephaloptera	52888	Chaetognatha	other_Eukaryota	150	2.32e-44	NR	CAL69110.1	52888	g72828	i0	70.4	3.73913043478261	108	32	93.9	0	21	344	7	114	CAL69110.1 TPA: putative 40S ribosomal protein S20 [Spadella cephaloptera]	diamond	1290	150	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera

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