metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA473201" 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
8096862	8096862	PRJNA473201_P_NODE_37107_length_327_cov_2.173228_g36365_i0	PRJNA473201	37107	327	2.173228	7.10645556	Helobdella robusta	6412	Annelida	Annelida	117	1.7599999999999998e-31	NR	XP_009016708.1	6412	g36365	i0	59.8	0.889908256880734	97	39	89	0	324	34	16	112	XP_009016708.1 hypothetical protein HELRODRAFT_77706, partial [Helobdella robusta]	diamond	291	117	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
12573588	12573588	PRJNA473201_P_NODE_33310_length_343_cov_2.266667_g32568_i0	PRJNA473201	33310	343	2.266667	7.77466781	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	158	6.82e-46	NR	CAD5118891.1	2664684	g32568	i0	71.3	16.3206997084548	108	30	94.5	1	326	3	49	155	CAD5118891.1 DgyrCDS7565 [Dimorphilus gyrociliatus]	diamond	5598	158	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
23395707	23395707	PRJNA473201_P_NODE_24899_length_395_cov_0.956522_g24157_i0	PRJNA473201	24899	395	0.956522	3.7782619	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	188	1.3199999999999998e-55	NR	CAD5125094.1	2664684	g24157	i0	71	5.96962025316456	131	33	99.5	1	2	394	264	389	CAD5125094.1 DgyrCDS13335 [Dimorphilus gyrociliatus]	diamond	2358	188	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
27123653	27123653	PRJNA473201_P_NODE_72962_length_247_cov_1.902299_g72220_i0	PRJNA473201	72962	247	1.902299	4.69867853	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	75.9	2.27e-14	NR	KAK2164473.1	53620	g72220	i0	58.8	7.68825910931174	80	32	96	1	244	8	135	214	KAK2164473.1 hypothetical protein LSH36_63g08036 [Paralvinella palmiformis]	diamond	1899	76.6	0.990861618798956	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31055952	31055952	PRJNA473201_P_NODE_33215_length_344_cov_1.136531_g32473_i0	PRJNA473201	33215	344	1.136531	3.90966664	Capitella teleta	283909	Annelida	Annelida	70.5	2.17e-11	NR	ELT93773.1	283909	g32473	i0	38.1	2.46802325581395	97	59	83.7	1	2	289	452	548	ELT93773.1 hypothetical protein CAPTEDRAFT_152273 [Capitella teleta]	diamond	849	70.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
32542538	32542538	PRJNA473201_P_NODE_56519_length_275_cov_2.054455_g55777_i0	PRJNA473201	56519	275	2.054455	5.64975125	Capitella teleta	283909	Annelida	Annelida	45.8	0.0021	NR	ELU08916.1	283909	g55777	i0	51.2	0.872727272727273	41	18	42.5	1	275	159	116	156	ELU08916.1 hypothetical protein CAPTEDRAFT_159819 [Capitella teleta]	diamond	240	45.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta

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