metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax_phylum = "Chordata"

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
28122392	28122392	PRJNA609258_P_NODE_31545_length_332_cov_1.204633_g31160_i0	PRJNA609258	31545	332	1.204633	3.99938156	Oikopleura dioica	34765	Chordata	Chordata	76.6	1.28e-13	NR	CAG5080888.1	34765	g31160	i0	50	1.9066265060241	106	51	94.9	2	11	325	372	476	CAG5080888.1 Oidioi.mRNA.OKI2018_I69.PAR.g9729.t1.cds [Oikopleura dioica]	diamond	633	76.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
28501394	28501394	PRJNA609258_P_NODE_55007_length_247_cov_0.896552_g54622_i0	PRJNA609258	55007	247	0.896552	2.21448344	Eudromia elegans	8805	Chordata	Chordata	65.5	3.82e-10	NR	NXA35578.1	8805	g54622	i0	51.8	1.37246963562753	56	27	68	0	53	220	115	170	NXA35578.1 AGM1 mutase [Eudromia elegans]	diamond	339	65.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Tinamiformes	Tinamidae	Eudromia	Eudromia elegans
29587638	29587638	PRJNA609258_P_NODE_11350_length_578_cov_3.342574_g10975_i0	PRJNA609258	11350	578	3.342574	19.32007772	Metazoa	33208	Chordata	Chordata	50.8	0.00121	NR	BAB61733.1	7729	g10975	i0	50.9	1.28719723183391	55	24	28.5	1	475	311	426	477	BAB61733.1 transcription factor ems/emx [Halocynthia roretzi]	diamond	744	51.2	0.9921875	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Pyuridae	Halocynthia	Halocynthia roretzi
32116552	32116552	PRJNA609258_P_NODE_49378_length_253_cov_0.866667_g48993_i0	PRJNA609258	49378	253	0.866667	2.19266751	Aves	8782	Chordata	Chordata	61.6	8.84e-9	NR	XP_048673203.1	8467	g48993	i0	44	34.7786561264822	84	31	99.6	3	2	253	236	303	XP_048673203.1 nuclear prelamin A recognition factor isoform X2 [Caretta caretta]	diamond	8799	62	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Caretta	Caretta caretta

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