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

6 rows where analysis = "diamond", bioproject = "PRJNA690592" and tax_phylum = "Orthonectida"

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_family	tax_genus	tax_species
27662700	27662700	PRJNA690592_S_NODE_28584_length_564_cov_2.682281_g27586_i0	PRJNA690592	28584	564	2.682281	15.12806484	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	241	4.1100000000000005e-70	NR	OAF71957.1	1819745	g27586	i0	63.1	13.8617021276596	187	68	99.5	1	563	3	732	917	OAF71957.1 hypothetical protein A3Q56_00278, partial [Intoshia linei]	diamond	7818	241	1	Eukaryota	Opisthokonta	Metazoa	Orthonectida	Rhopaluridae	Intoshia	Intoshia linei
28124809	28124809	PRJNA690592_S_NODE_220265_length_226_cov_3.019608_g219251_i0	PRJNA690592	220265	226	3.019608	6.82431408	Intoshia linei	1819745	Orthonectida	other_Eukaryota	43.5	0.0168	NR	OAF70754.1	1819745	g219251	i0	51.4	0.464601769911504	35	17	46.5	0	219	115	3000	3034	OAF70754.1 hypothetical protein A3Q56_01458 [Intoshia linei]	diamond	105	43.5	1	Eukaryota	Opisthokonta	Metazoa	Orthonectida	Rhopaluridae	Intoshia	Intoshia linei
28503598	28503598	PRJNA690592_S_NODE_146627_length_280_cov_1.033816_g145613_i0	PRJNA690592	146627	280	1.033816	2.8946848	Intoshia linei	1819745	Orthonectida	other_Eukaryota	54.3	1.35e-6	NR	OAF68972.1	1819745	g145613	i0	60	0.482142857142857	45	17	48.2	1	1	135	107	150	OAF68972.1 hypothetical protein A3Q56_03287 [Intoshia linei]	diamond	135	54.3	1	Eukaryota	Opisthokonta	Metazoa	Orthonectida	Rhopaluridae	Intoshia	Intoshia linei
28787669	28787669	PRJNA690592_S_NODE_69767_length_381_cov_0.902597_g68753_i0	PRJNA690592	69767	381	0.902597	3.43889457	Intoshia linei	1819745	Orthonectida	other_Eukaryota	122	9.479999999999999e-30	NR	OAF69336.1	1819745	g68753	i0	46.5	0.897637795275591	114	61	89.8	0	370	29	122	235	OAF69336.1 hypothetical protein A3Q56_02862 [Intoshia linei]	diamond	342	122	1	Eukaryota	Opisthokonta	Metazoa	Orthonectida	Rhopaluridae	Intoshia	Intoshia linei
31599647	31599647	PRJNA690592_S_NODE_203316_length_245_cov_0.912791_g202302_i0	PRJNA690592	203316	245	0.912791	2.23633795	Intoshia linei	1819745	Orthonectida	other_Eukaryota	107	6.93e-26	NR	OAF65651.1	1819745	g202302	i0	66.3	7.61632653061224	80	27	98	0	241	2	3	82	OAF65651.1 hypothetical protein A3Q56_06635 [Intoshia linei]	diamond	1866	107	1	Eukaryota	Opisthokonta	Metazoa	Orthonectida	Rhopaluridae	Intoshia	Intoshia linei
31820832	31820832	PRJNA690592_S_NODE_90457_length_341_cov_1.473881_g89443_i0	PRJNA690592	90457	341	1.473881	5.02593421	Intoshia linei	1819745	Orthonectida	other_Eukaryota	73.2	2.5e-12	NR	OAF71338.1	1819745	g89443	i0	64.8	1.39882697947214	54	19	47.5	0	261	100	878	931	OAF71338.1 hypothetical protein A3Q56_00917 [Intoshia linei]	diamond	477	73.2	1	Eukaryota	Opisthokonta	Metazoa	Orthonectida	Rhopaluridae	Intoshia	Intoshia linei

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