metadata: contig_metadata: 6 rows where bioproject = "PRJEB9859", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJEB9859", tax_clade = "Opisthokonta" 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
11202261	11202261	PRJEB9859_P_NODE_1209_length_371_cov_145.798246_g1175_i0	PRJEB9859	1209	371	145.798246	540.91149266	Metazoa	33208	Rotifera	other_Eukaryota	198	4.279999999999999e-46	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g1175	i0	92.701	37.8867924528302	137	10	37	0	66	202	2414	2550	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	14056	198	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
23951484	23951484	PRJEB9859_P_NODE_6599_length_219_cov_156.000000_g6564_i0	PRJEB9859	6599	219	156	341.64	Metazoa	33208	Rotifera	other_Eukaryota	180	8.52e-41	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g6564	i0	92.188	57.5251141552511	128	9	58	1	66	193	2414	2540	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	12598	180	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
26741690	26741690	PRJEB9859_P_NODE_2081_length_316_cov_1.519164_g2046_i0	PRJEB9859	2081	316	1.519164	4.80055824	Metazoa	33208	Rotifera	other_Eukaryota	66.6	3.71e-10	NR	CAF0946957.1	249248	g2046	i0	39.5	7.13924050632911	76	44	72.2	1	315	88	890	963	CAF0946957.1 unnamed protein product [Adineta ricciae]	diamond	2256	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28582015	28582015	PRJEB9859_P_NODE_4487_length_249_cov_1.009091_g4452_i0	PRJEB9859	4487	249	1.009091	2.51263659	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	68.9	9.92e-13	NR	RMZ92811.1	10195	g4452	i0	64	0.602409638554217	50	18	60.2	0	249	100	73	122	RMZ92811.1 COMM domain-containing 3 [Brachionus plicatilis]	diamond	150	68.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
31139813	31139813	PRJEB9859_P_NODE_5015_length_245_cov_1.120370_g4980_i0	PRJEB9859	5015	245	1.12037	2.7449065	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	57.8	9.64e-8	NR	CAF1423921.1	1234261	g4980	i0	52.9	1.2	51	23	61.2	1	42	191	108	158	CAF1423921.1 unnamed protein product [Didymodactylos carnosus]	diamond	294	57.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
31354224	31354224	PRJEB9859_P_NODE_2816_length_288_cov_1.648649_g2781_i0	PRJEB9859	2816	288	1.648649	4.74810912	Brachionus	10194	Rotifera	other_Eukaryota	101	6.52e-25	NR	RMZ96144.1	10195	g2781	i0	75.8	1.375	66	16	68.8	0	3	200	86	151	RMZ96144.1 40S ribosomal S19a-like [Brachionus plicatilis]	diamond	396	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis

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