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

6 rows where analysis = "diamond", bioproject = "PRJNA565778" 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
3109130	3109130	PRJNA565778_S_NODE_24383_length_223_cov_392.435484_g24087_i0	PRJNA565778	24383	223	392.435484	875.13112932	Polychaeta	6341	Annelida	Annelida	100	3.9799999999999998e-25	NR	AAO43049.1	126650	g24087	i0	97.9	3.16143497757848	47	1	63.2	0	37	177	92	138	AAO43049.1 40S ribosomal protein [Perinereis aibuhitensis]	diamond	705	100	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Perinereis	Perinereis aibuhitensis
27142344	27142344	PRJNA565778_S_NODE_23622_length_227_cov_90.452632_g23326_i0	PRJNA565778	23622	227	90.452632	205.32747464	Owenia fusiformis	6347	Annelida	Annelida	79.7	2.92e-15	NR	CAH1789989.1	6347	g23326	i0	54.7	1.41409691629956	53	24	70	0	180	22	202	254	CAH1789989.1 unnamed protein product [Owenia fusiformis]	diamond	321	79.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29321498	29321498	PRJNA565778_S_NODE_4789_length_471_cov_76.652074_g4559_i0	PRJNA565778	4789	471	76.652074	361.03126854	Lamellibrachia satsuma	104711	Annelida	Annelida	145	1.87e-37	NR	KAI0239688.1	104711	g4559	i0	70.5	1.20382165605096	95	28	60.5	0	180	464	155	249	KAI0239688.1 hypothetical protein LSAT2_009600 [Lamellibrachia satsuma]	diamond	567	145	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31153355	31153355	PRJNA565778_S_NODE_1075_length_823_cov_42.237913_g998_i0	PRJNA565778	1075	823	42.237913	347.61802399	Lamellibrachia satsuma	104711	Annelida	Annelida	50.4	0.00553	NR	KAI0216318.1	104711	g998	i0	29.2	0.987849331713244	271	111	79.1	12	784	134	431	674	KAI0216318.1 NUAK family SNF1-like kinase 1 [Lamellibrachia satsuma]	diamond	813	50.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31280127	31280127	PRJNA565778_S_NODE_5315_length_452_cov_2.775904_g5065_i0	PRJNA565778	5315	452	2.775904	12.54708608	Phragmatopoma lapidosa	341668	Annelida	Annelida	183	1.24e-56	NR	AIU94781.1	341668	g5065	i0	80.2	1.32743362831858	101	20	67	0	452	150	40	140	AIU94781.1 hypothetical protein [Phragmatopoma lapidosa]	diamond	600	183	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
32891954	32891954	PRJNA565778_S_NODE_33080_length_190_cov_2.385621_g32784_i0	PRJNA565778	33080	190	2.385621	4.5326799	Paralvinella palmiformis	53620	Annelida	Annelida	57.8	1.44e-8	NR	KAK2167687.1	53620	g32784	i0	59.6	0.742105263157895	47	19	74.2	0	48	188	1	47	KAK2167687.1 hypothetical protein LSH36_25g04033 [Paralvinella palmiformis]	diamond	141	57.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis

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