metadata: contig_metadata: 10 rows where bioproject = "PRJNA1120771", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA1120771", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"

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
276747	276747	PRJNA1120771_S_NODE_3921_length_470_cov_26.716628_g3527_i0	PRJNA1120771	3921	470	26.716628	125.5681516	Paralvinella palmiformis	53620	Annelida	Annelida	183	8.439999999999999e-55	NR	KAK2140055.1	53620	g3527	i0	64.9	45.868085106383	131	46	83.6	0	469	77	139	269	KAK2140055.1 hypothetical protein LSH36_1498g00014 [Paralvinella palmiformis]	diamond	21558	184	0.994565217391304	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
10480355	10480355	PRJNA1120771_S_NODE_7909_length_364_cov_26.105919_g7509_i0	PRJNA1120771	7909	364	26.105919	95.02554516	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	154	4.17e-45	NR	CAH1787333.1	6347	g7509	i0	75.8	32.6373626373626	99	24	81.6	0	363	67	76	174	CAH1787333.1 unnamed protein product, partial [Owenia fusiformis]	diamond	11880	155	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
15056261	15056261	PRJNA1120771_S_NODE_39772_length_187_cov_65.659722_g39372_i0	PRJNA1120771	39772	187	65.659722	122.78368014	Metazoa	33208	Annelida	Annelida	54.7	0.004	NTclustered	gi\|146189520\|emb\|AM697674.1\|	6359	g39372	i0	100	4.51336898395722	29	0	16	0	1	29	173	201	Platynereis dumerilii mRNA for hypothetical protein (ORF1), isolate 2	blastn	844	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
17606284	17606284	PRJNA1120771_S_NODE_7994_length_363_cov_7.250000_g7594_i0	PRJNA1120771	7994	363	7.25	26.3175	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	154	2.26e-42	NR	KAK2186668.1	27915	g7594	i0	77.8	9.96694214876033	99	21	81.8	1	3	299	311	408	KAK2186668.1 hypothetical protein NP493_192g03019 [Ridgeia piscesae]	diamond	3618	155	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
20678005	20678005	PRJNA1120771_S_NODE_16517_length_281_cov_1.827731_g16117_i0	PRJNA1120771	16517	281	1.827731	5.13592411	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.026	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g16117	i0	100	0.099644128113879	28	0	10	0	27	54	35074056	35074083	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
21953533	21953533	PRJNA1120771_S_NODE_9218_length_345_cov_9.639073_g8818_i0	PRJNA1120771	9218	345	9.639073	33.25480185	Opisthokonta	33154	Annelida	Annelida	110	1.13e-28	NR	XP_009025143.1	6412	g8818	i0	58.9	2.4695652173913	95	39	82.6	0	329	45	7	101	XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta]	diamond	852	110	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
26647626	26647626	PRJNA1120771_S_NODE_11621_length_319_cov_1.829710_g11221_i0	PRJNA1120771	11621	319	1.82971	5.8367749	Metazoa	33208	Annelida	Annelida	102	1.7099999999999998e-23	NR	XP_009019961.1	6412	g11221	i0	52.9	2.8307210031348	102	44	95.9	2	311	6	183	280	XP_009019961.1 hypothetical protein HELRODRAFT_106717 [Helobdella robusta]	diamond	903	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27702235	27702235	PRJNA1120771_S_NODE_5904_length_404_cov_16.418283_g5504_i0	PRJNA1120771	5904	404	16.418283	66.32986332	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	54.3	9.29e-6	NR	CAD5126615.1	2664684	g5504	i0	37.8	1.14356435643564	74	45	55	1	30	251	132	204	CAD5126615.1 DgyrCDS14701 [Dimorphilus gyrociliatus]	diamond	462	54.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30470273	30470273	PRJNA1120771_S_NODE_4793_length_437_cov_4.878173_g4393_i0	PRJNA1120771	4793	437	4.878173	21.31761601	Metazoa	33208	Annelida	Annelida	65.9	2.59e-9	NR	XP_009013732.1	6412	g4393	i0	49.1	1.51029748283753	57	29	39.1	0	435	265	668	724	XP_009013732.1 hypothetical protein HELRODRAFT_110232 [Helobdella robusta]	diamond	660	65.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32209089	32209089	PRJNA1120771_S_NODE_29998_length_222_cov_0.972067_g29598_i0	PRJNA1120771	29998	222	0.972067	2.15798874	Metazoa	33208	Annelida	Annelida	103	1.0499999999999999e-23	NR	CAH1798860.1	6347	g29598	i0	54.8	3.94594594594595	73	33	98.6	0	2	220	546	618	CAH1798860.1 unnamed protein product, partial [Owenia fusiformis]	diamond	876	103	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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