metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA168635" 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
27217910	27217910	PRJNA168635_P_NODE_27882_length_166_cov_1.213675_g27466_i0	PRJNA168635	27882	166	1.213675	2.0147005	Terebellida	6373	Annelida	Annelida	52	6.99e-6	NR	KAK2164243.1	53620	g27466	i0	51.3	1.48192771084337	39	19	70.5	0	45	161	607	645	KAK2164243.1 hypothetical protein LSH36_67g04000 [Paralvinella palmiformis]	diamond	246	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
27755371	27755371	PRJNA168635_P_NODE_24404_length_170_cov_4.107438_g23988_i0	PRJNA168635	24404	170	4.107438	6.9826446	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.5	0.0074400000000000004	NR	ELT98041.1	283909	g23988	i0	50	1.78235294117647	34	14	60	1	170	69	399	429	ELT98041.1 hypothetical protein CAPTEDRAFT_173297 [Capitella teleta]	diamond	303	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
28007869	28007869	PRJNA168635_P_NODE_31245_length_163_cov_0.912281_g30829_i0	PRJNA168635	31245	163	0.912281	1.48701803	Terebellida	6373	Annelida	Annelida	45.1	0.00188	NR	KAK2166886.1	53620	g30829	i0	51.9	1.91411042944785	54	23	93.9	1	3	155	631	684	KAK2166886.1 hypothetical protein LSH36_34g08004 [Paralvinella palmiformis]	diamond	312	45.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
28810457	28810457	PRJNA168635_P_NODE_32268_length_162_cov_0.920354_g31852_i0	PRJNA168635	32268	162	0.920354	1.49097348	Capitella teleta	283909	Annelida	Annelida	73.2	2.26e-13	NR	ELU15361.1	283909	g31852	i0	70.2	1.72222222222222	47	14	87	0	160	20	1105	1151	ELU15361.1 hypothetical protein CAPTEDRAFT_174329 [Capitella teleta]	diamond	279	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29442026	29442026	PRJNA168635_P_NODE_24850_length_169_cov_3.316667_g24434_i0	PRJNA168635	24850	169	3.316667	5.60516723	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	45.1	0.00208	NR	CAD5117597.1	2664684	g24434	i0	43.8	0.85207100591716	48	27	85.2	0	146	3	7013	7060	CAD5117597.1 DgyrCDS6353, partial [Dimorphilus gyrociliatus]	diamond	144	45.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29947591	29947591	PRJNA168635_P_NODE_17751_length_190_cov_3.595745_g17335_i0	PRJNA168635	17751	190	3.595745	6.8319155	Lamellibrachia satsuma	104711	Annelida	Annelida	72.8	4.81e-13	NR	KAI0208109.1	104711	g17335	i0	53.3	2.82631578947368	60	28	94.7	0	183	4	8310	8369	KAI0208109.1 Muscle M-line assembly protein unc-89 [Lamellibrachia satsuma]	diamond	537	72.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
29947598	29947598	PRJNA168635_P_NODE_29211_length_165_cov_0.896552_g28795_i0	PRJNA168635	29211	165	0.896552	1.4793108	Lamellibrachia satsuma	104711	Annelida	Annelida	74.7	7.1e-14	NR	KAI0208110.1	104711	g28795	i0	56.4	2	55	24	100	0	1	165	4707	4761	KAI0208110.1 Titin [Lamellibrachia satsuma]	diamond	330	74.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32760547	32760547	PRJNA168635_P_NODE_30120_length_164_cov_0.904348_g29704_i0	PRJNA168635	30120	164	0.904348	1.48313072	Ridgeia piscesae	27915	Annelida	Annelida	48.5	7.55e-5	NR	KAK2185936.1	27915	g29704	i0	53.1	0.896341463414634	49	22	89.6	1	16	162	119	166	KAK2185936.1 hypothetical protein NP493_218g02013 [Ridgeia piscesae]	diamond	147	48.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae

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