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

8 rows where analysis = "diamond", bioproject = "PRJNA704949" 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
7076641	7076641	PRJNA704949_P_NODE_468706_length_398_cov_1.489971_g453486_i0	PRJNA704949	468706	398	1.489971	5.93008458	Metazoa	33208	Annelida	Annelida	76.3	2.69e-13	NR	CAH1791720.1	6347	g453486	i0	83.7	11.8040201005025	49	8	36.9	0	250	104	313	361	CAH1791720.1 unnamed protein product [Owenia fusiformis]	diamond	4698	76.6	0.996083550913838	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
26829993	26829993	PRJNA704949_P_NODE_1553361_length_196_cov_1.768707_g1538022_i0	PRJNA704949	1553361	196	1.768707	3.46666572	Helobdella robusta	6412	Annelida	Annelida	96.7	1.19e-23	NR	XP_009011035.1	6412	g1538022	i0	60.9	0.979591836734694	64	25	98	0	194	3	7	70	XP_009011035.1 hypothetical protein HELRODRAFT_72348 [Helobdella robusta]	diamond	192	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27114368	27114368	PRJNA704949_P_NODE_123722_length_717_cov_1.520958_g110726_i0	PRJNA704949	123722	717	1.520958	10.90526886	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	49.3	0.00977	NR	CAD5116603.1	2664684	g110726	i0	39	0.644351464435146	77	44	31	1	513	292	466	542	CAD5116603.1 DgyrCDS5478 [Dimorphilus gyrociliatus]	diamond	462	49.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
27220248	27220248	PRJNA704949_P_NODE_723742_length_316_cov_1.363296_g708413_i0	PRJNA704949	723742	316	1.363296	4.30801536	Metazoa	33208	Annelida	Annelida	116	1.44e-27	NR	CAH1802155.1	6347	g708413	i0	60.4	14.0316455696203	96	38	91.1	0	8	295	1863	1958	CAH1802155.1 unnamed protein product [Owenia fusiformis]	diamond	4434	116	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27556594	27556594	PRJNA704949_P_NODE_1054084_length_252_cov_1.384236_g1038748_i0	PRJNA704949	1054084	252	1.384236	3.48827472	Ridgeia piscesae	27915	Annelida	Annelida	55.5	3.48e-8	NR	KAK2182116.1	27915	g1038748	i0	62.8	0.511904761904762	43	15	51.2	1	130	2	5	46	KAK2182116.1 hypothetical protein NP493_366g02051 [Ridgeia piscesae]	diamond	129	55.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31884757	31884757	PRJNA704949_P_NODE_2064357_length_165_cov_0.896552_g2049018_i0	PRJNA704949	2064357	165	0.896552	1.4793108	Lamellibrachia satsuma	104711	Annelida	Annelida	70.9	1.53e-12	NR	KAI0239865.1	104711	g2049018	i0	59.3	1.94545454545455	54	22	98.2	0	163	2	675	728	KAI0239865.1 hypothetical protein LSAT2_009416 [Lamellibrachia satsuma]	diamond	321	70.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32106101	32106101	PRJNA704949_P_NODE_1341298_length_216_cov_1.556886_g1325960_i0	PRJNA704949	1341298	216	1.556886	3.36287376	Lamellibrachia satsuma	104711	Annelida	Annelida	55.8	6.27e-7	NR	KAI0213741.1	104711	g1325960	i0	45.8	1.33333333333333	48	25	65.3	1	27	167	4	51	KAI0213741.1 WD repeat-containing protein 7 [Lamellibrachia satsuma]	diamond	288	55.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32433777	32433777	PRJNA704949_P_NODE_1061019_length_251_cov_1.297030_g1045683_i0	PRJNA704949	1061019	251	1.29703	3.2555453	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.5	1.14e-6	NR	CAH1789248.1	6347	g1045683	i0	34.8	17.6175298804781	66	43	78.9	0	200	3	201	266	CAH1789248.1 unnamed protein product [Owenia fusiformis]	diamond	4422	55.8	0.99462365591397806	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);;