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

6 rows where bioproject = "PRJNA672101", tax_kingdom = "Metazoa" and tax_phylum = "Rotifera"

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
27113186	27113186	PRJNA672101_S_NODE_3862_length_432_cov_2.821727_g3831_i0	PRJNA672101	3862	432	2.821727	12.18986064	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	54.3	2.34e-5	NR	CAF1119092.1	1234261	g3831	i0	44.9	1.61111111111111	69	36	46.5	1	431	231	39	107	CAF1119092.1 unnamed protein product [Didymodactylos carnosus]	diamond	696	54.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
27536125	27536125	PRJNA672101_S_NODE_15883_length_306_cov_5.515021_g15852_i0	PRJNA672101	15883	306	5.515021	16.87596426	Rotaria	231623	Rotifera	other_Eukaryota	55.5	2.78e-6	NR	CAF1284759.1	392030	g15852	i0	44.8	16	58	32	56.9	0	4	177	612	669	CAF1284759.1 unnamed protein product [Rotaria magnacalcarata]	diamond	4896	55.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
30251830	30251830	PRJNA672101_S_NODE_25492_length_262_cov_2.444444_g25461_i0	PRJNA672101	25492	262	2.444444	6.40444328	Brachionus	10194	Rotifera	other_Eukaryota	43.1	0.0329	NR	AWV66641.1	96890	g25461	i0	43.1	1.16793893129771	51	22	58.4	1	221	69	445	488	AWV66641.1 beclin1 [Brachionus rotundiformis]	diamond	306	43.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
30492542	30492542	PRJNA672101_S_NODE_23113_length_271_cov_5.494949_g23082_i0	PRJNA672101	23113	271	5.494949	14.89131179	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	53.1	7.26e-7	NR	CAF4229329.1	392030	g23082	i0	37	1.47232472324723	73	46	80.8	0	270	52	3	75	CAF4229329.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	399	53.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
30650235	30650235	PRJNA672101_S_NODE_17493_length_297_cov_6.196429_g17462_i0	PRJNA672101	17493	297	6.196429	18.40339413	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	90.9	5.45e-19	NR	CAF2069050.1	392030	g17462	i0	46.9	5.83838383838384	98	49	98	3	6	296	142	237	CAF2069050.1 unnamed protein product [Rotaria magnacalcarata]	diamond	1734	90.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
31092805	31092805	PRJNA672101_S_NODE_7375_length_374_cov_2.046512_g7344_i0	PRJNA672101	7375	374	2.046512	7.65395488	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	52.8	5.06e-5	NR	CAF1532865.1	392030	g7344	i0	49.1	2.55882352941176	53	27	42.5	0	367	209	384	436	CAF1532865.1 unnamed protein product [Rotaria magnacalcarata]	diamond	957	52.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata

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