metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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
3551608	3551608	PRJNA1005695_P_NODE_12803_length_429_cov_3.988764_g11951_i0	PRJNA1005695	12803	429	3.988764	17.11179756	Metazoa	33208	Annelida	Annelida	70.1	4.37e-11	NR	KAK2147523.1	53620	g11951	i0	76.9	2.93006993006993	39	9	27.3	0	119	3	14	52	KAK2147523.1 hypothetical protein LSH36_548g00001 [Paralvinella palmiformis]	diamond	1257	70.5	0.994326241134752	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
18005164	18005164	PRJNA1005695_P_NODE_17255_length_364_cov_1.608247_g16403_i0	PRJNA1005695	17255	364	1.608247	5.85401908	Metazoa	33208	Annelida	Annelida	117	4.97e-29	NR	XP_009019938.1	6412	g16403	i0	49.2	10.771978021978	118	59	96.4	1	1	351	191	308	XP_009019938.1 hypothetical protein HELRODRAFT_106700 [Helobdella robusta]	diamond	3921	118	0.991525423728814	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
20554630	20554630	PRJNA1005695_P_NODE_19257_length_344_cov_1.719557_g18405_i0	PRJNA1005695	19257	344	1.719557	5.91527608	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	147	1.54e-39	NR	CAD5116714.1	2664684	g18405	i0	72.7	9.19186046511628	88	24	76.7	0	80	343	163	250	CAD5116714.1 DgyrCDS5572 [Dimorphilus gyrociliatus]	diamond	3162	147	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
26971056	26971056	PRJNA1005695_P_NODE_40862_length_236_cov_2.349693_g40010_i0	PRJNA1005695	40862	236	2.349693	5.54527548	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	125	7.98e-32	NR	CAD5121995.1	2664684	g40010	i0	76.9	9.91525423728813	78	18	99.2	0	235	2	51	128	CAD5121995.1 DgyrCDS10448 [Dimorphilus gyrociliatus]	diamond	2340	125	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
27943164	27943164	PRJNA1005695_P_NODE_39385_length_243_cov_1.688235_g38533_i0	PRJNA1005695	39385	243	1.688235	4.10241105	Metazoa	33208	Annelida	Annelida	135	9.83e-36	NR	CAH1775520.1	6347	g38533	i0	77.8	97.6543209876543	81	18	100	0	243	1	75	155	CAH1775520.1 unnamed protein product [Owenia fusiformis]	diamond	23730	136	0.992647058823529	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28360830	28360830	PRJNA1005695_P_NODE_30606_length_270_cov_1.187817_g29754_i0	PRJNA1005695	30606	270	1.187817	3.2071059	Capitella teleta	283909	Annelida	Annelida	98.6	1.24e-21	NR	ELT88700.1	283909	g29754	i0	49.5	1.03333333333333	93	44	100	1	270	1	362	454	ELT88700.1 hypothetical protein CAPTEDRAFT_175688 [Capitella teleta]	diamond	279	98.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29521716	29521716	PRJNA1005695_P_NODE_34690_length_253_cov_0.866667_g33838_i0	PRJNA1005695	34690	253	0.866667	2.19266751	Metazoa	33208	Annelida	Annelida	94.4	2.89e-20	NR	CAH1778822.1	6347	g33838	i0	56.8	13.2569169960474	74	32	87.7	0	249	28	444	517	CAH1778822.1 unnamed protein product, partial [Owenia fusiformis]	diamond	3354	94.7	0.996832101372756	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30248414	30248414	PRJNA1005695_P_NODE_25772_length_295_cov_2.243243_g24920_i0	PRJNA1005695	25772	295	2.243243	6.61756685	Metazoa	33208	Annelida	Annelida	68.2	7.62e-12	NR	CAH1793915.1	6347	g24920	i0	45.1	1.59661016949153	71	38	71.2	1	85	294	28	98	CAH1793915.1 unnamed protein product, partial [Owenia fusiformis]	diamond	471	68.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31677849	31677849	PRJNA1005695_P_NODE_17037_length_366_cov_2.129693_g16185_i0	PRJNA1005695	17037	366	2.129693	7.79467638	Paralvinella palmiformis	53620	Annelida	Annelida	73.2	7.62e-13	NR	KAK2146732.1	53620	g16185	i0	64.4	0.811475409836066	45	16	36.9	0	366	232	145	189	KAK2146732.1 hypothetical protein LSH36_587g01063 [Paralvinella palmiformis]	diamond	297	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31804365	31804365	PRJNA1005695_P_NODE_38597_length_245_cov_0.906977_g37745_i0	PRJNA1005695	38597	245	0.906977	2.22209365	Lamellibrachia satsuma	104711	Annelida	Annelida	98.2	1.19e-21	NR	KAI0230464.1	104711	g37745	i0	59	1.84897959183673	78	31	95.5	1	234	1	819	895	KAI0230464.1 hypothetical protein LSAT2_019211 [Lamellibrachia satsuma]	diamond	453	98.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31986698	31986698	PRJNA1005695_P_NODE_16978_length_367_cov_1.557823_g16126_i0	PRJNA1005695	16978	367	1.557823	5.71721041	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	144	5.519999999999999e-37	NR	CAH1775312.1	6347	g16126	i0	53.3	10.8719346049046	122	56	99.7	1	1	366	688	808	CAH1775312.1 unnamed protein product [Owenia fusiformis]	diamond	3990	145	0.993103448275862	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);;