metadata: contig_metadata: 5 rows where bioproject = "PRJNA900999" and tax

5 rows where bioproject = "PRJNA900999" 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
6350022	6350022	PRJNA900999_S_NODE_4025_length_213_cov_6.266304_g3969_i0	PRJNA900999	4025	213	6.266304	13.34722752	Brachionus	10194	Rotifera	other_Eukaryota	252	1.72e-62	NTclustered	gi\|170016231\|ref\|NC_010472.1\|	10195	g3969	i0	89.163	22.056338028169	203	20	95	2	1	202	10754	10955	Brachionus plicatilis mitochondrion part I, complete genome	blastn	4698	252	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
25104146	25104146	PRJNA900999_S_NODE_7480_length_167_cov_3.623188_g7424_i0	PRJNA900999	7480	167	3.623188	6.05072396	Philodina citrina	468664	Rotifera	other_Eukaryota	237	3.599999999999999e-58	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g7424	i0	95.333	2.22754491017964	150	6	90	1	1	150	9374	9522	Philodina citrina complete mitochondrial genome	blastn	372	237	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
27632198	27632198	PRJNA900999_S_NODE_2164_length_267_cov_4.768908_g2108_i0	PRJNA900999	2164	267	4.768908	12.73298436	Eurotatoria	2816136	Rotifera	other_Eukaryota	151	3.95e-40	NR	CAF0841902.1	433720	g2108	i0	83.1	11.1910112359551	83	14	93.3	0	255	7	2193	2275	CAF0841902.1 unnamed protein product [Adineta steineri]	diamond	2988	152	0.993421052631579	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
28129787	28129787	PRJNA900999_S_NODE_4745_length_200_cov_2.122807_g4689_i0	PRJNA900999	4745	200	2.122807	4.245614	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	63.5	1e-10	NR	CAF0713915.1	104777	g4689	i0	80.6	1.08	36	7	54	0	110	3	1	36	CAF0713915.1 unnamed protein product [Brachionus calyciflorus]	diamond	216	63.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
32332423	32332423	PRJNA900999_S_NODE_2679_length_248_cov_2.283105_g2623_i0	PRJNA900999	2679	248	2.283105	5.6621004	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	59.3	3.86e-9	NR	CAF5089175.1	2762511	g2623	i0	78.1	0.786290322580645	32	7	38.7	0	246	151	72	103	CAF5089175.1 unnamed protein product, partial [Rotaria sp. Silwood1]	diamond	195	59.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1

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