metadata: contig_metadata: 6 rows where bioproject = "PRJDB14274", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJDB14274", tax_kingdom = "Metazoa" and tax_phylum = "Tardigrada"

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
27158528	27158528	PRJDB14274_S_NODE_3722_length_318_cov_1.599222_g3644_i0	PRJDB14274	3722	318	1.599222	5.08552596	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	61.2	1.92e-8	NR	XP_055332035.1	2943436	g3644	i0	50	1.26415094339623	66	29	58.5	2	301	116	215	280	XP_055332035.1 toll-interacting protein A-like [Paramacrobiotus metropolitanus]	diamond	402	61.2	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
27853670	27853670	PRJDB14274_S_NODE_3245_length_340_cov_1.695341_g3167_i0	PRJDB14274	3245	340	1.695341	5.7641594	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	83.6	8.46e-18	NR	GAU96400.1	947166	g3167	i0	60	1.27941176470588	80	27	70.6	1	250	11	31	105	GAU96400.1 hypothetical protein RvY_07852 [Ramazzottius varieornatus]	diamond	435	83.6	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
27885266	27885266	PRJDB14274_S_NODE_9905_length_204_cov_2.090909_g9827_i0	PRJDB14274	9905	204	2.090909	4.26545436	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	108	3.07e-26	NR	XP_055351196.1	2943436	g9827	i0	71.6	1.97058823529412	67	19	98.5	0	3	203	186	252	XP_055351196.1 histone deacetylase 11-like [Paramacrobiotus metropolitanus]	diamond	402	108	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
28264009	28264009	PRJDB14274_S_NODE_4986_length_279_cov_1.073394_g4908_i0	PRJDB14274	4986	279	1.073394	2.99476926	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	52.4	1.89e-5	NR	GAU91496.1	947166	g4908	i0	32.1	0.838709677419355	78	51	81.7	2	239	12	88	165	GAU91496.1 hypothetical protein RvY_03735 [Ramazzottius varieornatus]	diamond	234	52.4	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
32023935	32023935	PRJDB14274_S_NODE_10238_length_202_cov_1.028369_g10160_i0	PRJDB14274	10238	202	1.028369	2.07730538	Hypsibius exemplaris	2072580	Tardigrada	other_Eukaryota	77.4	1.33e-14	NR	OQV13864.1	2072580	g10160	i0	56.9	3.87623762376238	65	27	96.5	1	199	5	538	601	OQV13864.1 85/88 kDa calcium-independent phospholipase A2 [Hypsibius exemplaris]	diamond	783	77.4	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
32372094	32372094	PRJDB14274_S_NODE_4879_length_281_cov_1.954545_g4801_i0	PRJDB14274	4879	281	1.954545	5.49227145	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	117	4.639999999999999e-28	NR	XP_055352983.1	2943436	g4801	i0	61.3	2.97864768683274	93	36	99.3	0	281	3	603	695	XP_055352983.1 alanine--tRNA ligase, cytoplasmic-like [Paramacrobiotus metropolitanus]	diamond	837	117	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus

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