metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB81171" 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
28202657	28202657	PRJEB81171_P_NODE_3526_length_352_cov_2.505376_g3399_i0	PRJEB81171	3526	352	2.505376	8.81892352	Adineta steineri	433720	Rotifera	other_Eukaryota	44.3	0.0351	NR	CAF1524545.1	433720	g3399	i0	46.3	1.01420454545455	41	22	34.9	0	293	171	177	217	CAF1524545.1 unnamed protein product [Adineta steineri]	diamond	357	44.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
28550378	28550378	PRJEB81171_P_NODE_707_length_772_cov_2.842632_g594_i0	PRJEB81171	707	772	2.842632	21.94511904	Adineta vaga	104782	Rotifera	other_Eukaryota	55.8	2.26e-6	NR	UJR19098.1	104782	g594	i0	51.1	0.349740932642487	47	23	18.3	0	490	630	22	68	UJR19098.1 hypothetical protein I4U23_022229 [Adineta vaga]	diamond	270	55.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29371211	29371211	PRJEB81171_P_NODE_1269_length_583_cov_3.496078_g1147_i0	PRJEB81171	1269	583	3.496078	20.38213474	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	52.4	4e-4	NR	CAF0991407.1	1234261	g1147	i0	29.7	1.14236706689537	118	73	58.1	4	575	237	473	585	CAF0991407.1 unnamed protein product, partial [Didymodactylos carnosus]	diamond	666	52.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
31013688	31013688	PRJEB81171_P_NODE_2855_length_390_cov_5.063091_g2728_i0	PRJEB81171	2855	390	5.063091	19.7460549	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	86.3	1.34e-18	NR	RNA30453.1	10195	g2728	i0	71.2	1.01538461538462	66	18	50	1	15	209	75	140	RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis]	diamond	396	86.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
31828396	31828396	PRJEB81171_P_NODE_8877_length_247_cov_0.896552_g8750_i0	PRJEB81171	8877	247	0.896552	2.21448344	Opisthokonta	33154	Rotifera	other_Eukaryota	44.3	0.00885	NR	CAF1520717.1	392033	g8750	i0	32.1	6.66801619433198	78	48	93.5	2	233	3	37	110	CAF1520717.1 unnamed protein product [Rotaria sordida]	diamond	1647	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
32398238	32398238	PRJEB81171_P_NODE_8219_length_250_cov_1.762712_g8092_i0	PRJEB81171	8219	250	1.762712	4.40678	Eurotatoria	2816136	Rotifera	other_Eukaryota	68.2	3.18e-11	NR	CAF1212725.1	249248	g8092	i0	36.9	7.056	84	52	99.6	1	1	249	61	144	CAF1212725.1 unnamed protein product [Adineta ricciae]	diamond	1764	68.6	0.994169096209913	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae

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