metadata: contig_metadata: 10 rows where bioproject = "PRJNA395690" and tax

10 rows where bioproject = "PRJNA395690" 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
26980390	26980390	PRJNA395690_P_NODE_6162_length_324_cov_1.029091_g6012_i0	PRJNA395690	6162	324	1.029091	3.33425484	Capitella teleta	283909	Annelida	Annelida	49.3	4.83e-4	NR	ELU16128.1	283909	g6012	i0	28.4	1.00925925925926	109	69	93.5	3	1	303	227	334	ELU16128.1 hypothetical protein CAPTEDRAFT_182417 [Capitella teleta]	diamond	327	49.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
27186757	27186757	PRJNA395690_P_NODE_7782_length_289_cov_2.133333_g7630_i0	PRJNA395690	7782	289	2.133333	6.16533237	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	123	6.460000000000001e-33	NR	XP_009018646.1	6412	g7630	i0	67.1	9.35294117647059	82	27	85.1	0	253	8	12	93	XP_009018646.1 hypothetical protein HELRODRAFT_185659 [Helobdella robusta]	diamond	2703	123	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28292105	28292105	PRJNA395690_P_NODE_16706_length_199_cov_1.020000_g16554_i0	PRJNA395690	16706	199	1.02	2.0298	Metazoa	33208	Annelida	Annelida	88.2	1.43e-18	NR	CAH1790270.1	6347	g16554	i0	61.5	5.87939698492462	65	25	98	0	3	197	262	326	CAH1790270.1 unnamed protein product [Owenia fusiformis]	diamond	1170	88.6	0.99548532731377	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28450302	28450302	PRJNA395690_P_NODE_6646_length_313_cov_0.931818_g6494_i0	PRJNA395690	6646	313	0.931818	2.91659034	Metazoa	33208	Annelida	Annelida	52.8	2.19e-5	NR	XP_009027623.1	6412	g6494	i0	40.5	4.53354632587859	42	25	40.3	0	284	159	240	281	XP_009027623.1 hypothetical protein HELRODRAFT_185121 [Helobdella robusta]	diamond	1419	53.1	0.994350282485876	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28481720	28481720	PRJNA395690_P_NODE_36206_length_161_cov_0.910714_g36054_i0	PRJNA395690	36206	161	0.910714	1.46624954	Metazoa	33208	Annelida	Annelida	85.9	7.62e-18	NR	CAH1799373.1	6347	g36054	i0	69.8	5.92546583850932	53	16	98.8	0	159	1	472	524	CAH1799373.1 unnamed protein product [Owenia fusiformis]	diamond	954	86.3	0.995365005793743	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28608009	28608009	PRJNA395690_P_NODE_8507_length_277_cov_1.885965_g8355_i0	PRJNA395690	8507	277	1.885965	5.22412305	Metazoa	33208	Annelida	Annelida	79	4.38e-15	NR	KAK2147523.1	53620	g8355	i0	64.2	3.60649819494585	53	19	57.4	0	119	277	5	57	KAK2147523.1 hypothetical protein LSH36_548g00001 [Paralvinella palmiformis]	diamond	999	79	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
29822417	29822417	PRJNA395690_P_NODE_36531_length_159_cov_2.427273_g36379_i0	PRJNA395690	36531	159	2.427273	3.85936407	Owenia fusiformis	6347	Annelida	Annelida	64.7	2.08e-10	NR	CAH1797355.1	6347	g36379	i0	51	11.5471698113208	51	25	96.2	0	5	157	410	460	CAH1797355.1 unnamed protein product, partial [Owenia fusiformis]	diamond	1836	64.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30629052	30629052	PRJNA395690_P_NODE_7433_length_296_cov_1.445344_g7281_i0	PRJNA395690	7433	296	1.445344	4.27821824	Metazoa	33208	Annelida	Annelida	86.7	1.08e-17	NR	KAK2185610.1	27915	g7281	i0	41.2	9.70945945945946	97	57	98.3	0	291	1	68	164	KAK2185610.1 hypothetical protein NP493_230g03100 [Ridgeia piscesae]	diamond	2874	86.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
32288704	32288704	PRJNA395690_P_NODE_17759_length_192_cov_2.475524_g17607_i0	PRJNA395690	17759	192	2.475524	4.75300608	Lamellibrachia satsuma	104711	Annelida	Annelida	73.2	5.5e-14	NR	KAI0228575.1	104711	g17607	i0	63.3	4.21875	60	22	93.8	0	13	192	1	60	KAI0228575.1 Peptidyl-prolyl cis-trans isomerase B [Lamellibrachia satsuma]	diamond	810	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32873094	32873094	PRJNA395690_P_NODE_33240_length_163_cov_0.894737_g33088_i0	PRJNA395690	33240	163	0.894737	1.45842131	Metazoa	33208	Annelida	Annelida	80.9	4.47e-16	NR	CAH1786926.1	6347	g33088	i0	61.1	4.96932515337423	54	21	99.4	0	2	163	450	503	CAH1786926.1 unnamed protein product, partial [Owenia fusiformis]	diamond	810	80.9	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);;