metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJDB14274" and tax

9 rows where analysis = "diamond", bioproject = "PRJDB14274" 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
27784903	27784903	PRJDB14274_S_NODE_5764_length_261_cov_1.710000_g5686_i0	PRJDB14274	5764	261	1.71	4.4631	Metazoa	33208	Annelida	Annelida	45.1	0.00382	NR	KAK2150617.1	27915	g5686	i0	52.6	2.97701149425287	57	23	65.5	1	261	91	30	82	KAK2150617.1 hypothetical protein NP493_2757g00000 [Ridgeia piscesae]	diamond	777	45.4	0.993392070484582	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
28832422	28832422	PRJDB14274_S_NODE_9188_length_210_cov_0.872483_g9110_i0	PRJDB14274	9188	210	0.872483	1.8322143	Owenia fusiformis	6347	Annelida	Annelida	71.2	2.2e-12	NR	CAH1780744.1	6347	g9110	i0	48.3	0.857142857142857	60	31	85.7	0	180	1	240	299	CAH1780744.1 unnamed protein product [Owenia fusiformis]	diamond	180	71.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28858116	28858116	PRJDB14274_S_NODE_1108_length_572_cov_1.798434_g1033_i0	PRJDB14274	1108	572	1.798434	10.28704248	Metazoa	33208	Annelida	Annelida	209	1.3e-62	NR	AIZ77505.1	6359	g1033	i0	53.4	10.9090909090909	189	88	99.1	0	2	568	68	256	AIZ77505.1 legumain-protease-precursor [Platynereis dumerilii]	diamond	6240	211	0.990521327014218	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
29205732	29205732	PRJDB14274_S_NODE_9289_length_209_cov_1.020270_g9211_i0	PRJDB14274	9289	209	1.02027	2.1323643	Metazoa	33208	Annelida	Annelida	79.7	1.26e-16	NR	CAH1797791.1	6347	g9211	i0	49.3	5.94258373205742	69	35	99	0	209	3	12	80	CAH1797791.1 unnamed protein product [Owenia fusiformis]	diamond	1242	80.1	0.995006242197254	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29243023	29243023	PRJDB14274_S_NODE_10209_length_202_cov_1.382979_g10131_i0	PRJDB14274	10209	202	1.382979	2.79361758	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	76.3	3.38e-14	NR	CAD5117392.1	2664684	g10131	i0	58.6	0.861386138613861	58	24	86.1	0	4	177	114	171	CAD5117392.1 DgyrCDS6166 [Dimorphilus gyrociliatus]	diamond	174	76.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30152671	30152671	PRJDB14274_S_NODE_2912_length_358_cov_2.026936_g2834_i0	PRJDB14274	2912	358	2.026936	7.25643088	Metazoa	33208	Annelida	Annelida	87.4	1.15e-17	NR	KAK2153756.1	53620	g2834	i0	47.9	7.94413407821229	96	47	77.9	3	34	312	28	123	KAK2153756.1 hypothetical protein LSH36_287g03034 [Paralvinella palmiformis]	diamond	2844	88.2	0.99092970521542	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30632567	30632567	PRJDB14274_S_NODE_6553_length_247_cov_1.032258_g6475_i0	PRJDB14274	6553	247	1.032258	2.54967726	Owenia fusiformis	6347	Annelida	Annelida	56.6	7.57e-8	NR	CAH1788885.1	6347	g6475	i0	50.8	0.740890688259109	61	25	68	2	11	178	4	64	CAH1788885.1 unnamed protein product [Owenia fusiformis]	diamond	183	56.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31897322	31897322	PRJDB14274_S_NODE_7817_length_227_cov_1.457831_g7739_i0	PRJDB14274	7817	227	1.457831	3.30927637	Helobdella robusta	6412	Annelida	Annelida	102	2e-23	NR	XP_009009848.1	6412	g7739	i0	67.6	0.977973568281938	74	24	97.8	0	223	2	358	431	XP_009009848.1 hypothetical protein HELRODRAFT_184872 [Helobdella robusta]	diamond	222	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32713328	32713328	PRJDB14274_S_NODE_6820_length_242_cov_1.563536_g6742_i0	PRJDB14274	6820	242	1.563536	3.78375712	Metazoa	33208	Annelida	Annelida	93.6	4.7e-20	NR	CAH1798950.1	6347	g6742	i0	50.6	7.98347107438016	81	39	99.2	1	240	1	576	656	CAH1798950.1 unnamed protein product [Owenia fusiformis]	diamond	1932	93.6	1	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);;