metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA473201" 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
27265904	27265904	PRJNA473201_P_NODE_68463_length_250_cov_0.870056_g67721_i0	PRJNA473201	68463	250	0.870056	2.17514	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	79.7	3.6e-17	NR	CAF1135364.1	1234261	g67721	i0	73.1	1.248	52	14	62.4	0	248	93	53	104	CAF1135364.1 unnamed protein product [Didymodactylos carnosus]	diamond	312	79.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
28181348	28181348	PRJNA473201_P_NODE_36086_length_331_cov_4.472868_g35344_i0	PRJNA473201	36086	331	4.472868	14.80519308	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	84.7	2.65e-18	NR	RNA30453.1	10195	g35344	i0	70.8	1.17824773413897	65	18	58	1	329	138	76	140	RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis]	diamond	390	84.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
28497462	28497462	PRJNA473201_P_NODE_77447_length_245_cov_0.895349_g76705_i0	PRJNA473201	77447	245	0.895349	2.19360505	Adineta ricciae	249248	Rotifera	other_Eukaryota	79	7.79e-16	NR	CAF0897181.1	249248	g76705	i0	45.7	2.95102040816327	81	41	99.2	1	3	245	56	133	CAF0897181.1 unnamed protein product [Adineta ricciae]	diamond	723	79	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28907532	28907532	PRJNA473201_P_NODE_30908_length_356_cov_0.985866_g30166_i0	PRJNA473201	30908	356	0.985866	3.50968296	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	42.4	0.0339	NR	CAF5074021.1	2762511	g30166	i0	58.7	0.387640449438202	46	19	38.8	0	258	121	10	55	CAF5074021.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	138	42.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
29129055	29129055	PRJNA473201_P_NODE_70169_length_249_cov_0.875000_g69427_i0	PRJNA473201	70169	249	0.875	2.17875	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	52.8	5.37e-6	NR	CAF0960475.1	1234261	g69427	i0	61.5	0.469879518072289	39	15	47	0	244	128	142	180	CAF0960475.1 unnamed protein product [Didymodactylos carnosus]	diamond	117	52.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
29807952	29807952	PRJNA473201_P_NODE_73651_length_247_cov_0.885057_g72909_i0	PRJNA473201	73651	247	0.885057	2.18609079	Metazoa	33208	Rotifera	other_Eukaryota	62.4	3.8e-9	NR	CAF1020936.1	433720	g72909	i0	35.4	1.97975708502024	82	50	98.4	2	245	3	193	272	CAF1020936.1 unnamed protein product [Adineta steineri]	diamond	489	62.8	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
31008639	31008639	PRJNA473201_P_NODE_39954_length_316_cov_2.950617_g39212_i0	PRJNA473201	39954	316	2.950617	9.32394972	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87.8	1.37e-19	NR	RNA30453.1	10195	g39212	i0	73.4	1.80379746835443	64	14	60.8	1	305	114	73	133	RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis]	diamond	570	87.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
31371944	31371944	PRJNA473201_P_NODE_36436_length_330_cov_1.291829_g35694_i0	PRJNA473201	36436	330	1.291829	4.2630357	Adineta steineri	433720	Rotifera	other_Eukaryota	44.7	0.0208	NR	CAF1524545.1	433720	g35694	i0	46.3	1.43636363636364	41	22	37.3	0	133	11	177	217	CAF1524545.1 unnamed protein product [Adineta steineri]	diamond	474	44.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri

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