metadata: contig_metadata: 12 rows where bioproject = "PRJNA690592" and tax

12 rows where bioproject = "PRJNA690592" and tax_phylum = "Ctenophora"

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
5007463	5007463	PRJNA690592_S_NODE_944_length_2103_cov_4.371429_g756_i0	PRJNA690592	944	2103	4.371429	91.93115187	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	104	5.61e-19	NR	XP_063688692.1	2820187	g756	i0	28.8	0.673323823109843	236	130	29.2	8	129	743	111	339	XP_063688692.1 multiple C2 and transmembrane domain-containing protein 1-like isoform X2 [Bolinopsis microptera]	diamond	1416	104	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
21581183	21581183	PRJNA690592_S_NODE_15897_length_741_cov_3.121257_g14993_i0	PRJNA690592	15897	741	3.121257	23.12851437	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	141	1.04e-35	NR	XP_063680754.1	2820187	g14993	i0	49.3	1.66801619433198	134	68	54.3	0	699	298	5	138	XP_063680754.1 nucleoredoxin-like [Bolinopsis microptera]	diamond	1236	141	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
26987407	26987407	PRJNA690592_S_NODE_170622_length_261_cov_1.627660_g169608_i0	PRJNA690592	170622	261	1.62766	4.2481926	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	118	6.32e-30	NR	XP_063681920.1	2820187	g169608	i0	61.7	0.931034482758621	81	31	93.1	0	261	19	214	294	XP_063681920.1 uncharacterized protein LOC134816850 [Bolinopsis microptera]	diamond	243	118	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
27651349	27651349	PRJNA690592_S_NODE_73944_length_371_cov_2.171141_g72930_i0	PRJNA690592	73944	371	2.171141	8.05493311	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	90.1	2.59e-18	NR	XP_063692050.1	2820187	g72930	i0	41.1	1.78706199460916	112	56	83.3	2	339	31	285	395	XP_063692050.1 cytohesin-2-like [Bolinopsis microptera]	diamond	663	90.1	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
28693307	28693307	PRJNA690592_S_NODE_2447_length_1542_cov_6.893805_g2116_i0	PRJNA690592	2447	1542	6.893805	106.3024731	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	118	5.99e-25	NR	XP_063679678.1	2820187	g2116	i0	30.6	0.546692607003891	281	159	52.3	7	559	1365	119	375	XP_063679678.1 7SK snRNA methylphosphate capping enzyme-like [Bolinopsis microptera]	diamond	843	118	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
30272435	30272435	PRJNA690592_S_NODE_94932_length_334_cov_2.563218_g93918_i0	PRJNA690592	94932	334	2.563218	8.56114812	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	96.3	3.5e-21	NR	XP_063681920.1	2820187	g93918	i0	47.8	0.826347305389222	92	46	82.6	1	311	36	96	185	XP_063681920.1 uncharacterized protein LOC134816850 [Bolinopsis microptera]	diamond	276	96.3	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
30745970	30745970	PRJNA690592_S_NODE_173174_length_259_cov_2.069892_g172160_i0	PRJNA690592	173174	259	2.069892	5.36102028	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	56.6	5.82e-7	NR	XP_063678356.1	2820187	g172160	i0	36.6	3.4980694980695	82	50	95	1	246	1	145	224	XP_063678356.1 tyrosine-protein phosphatase non-receptor type 2-like [Bolinopsis microptera]	diamond	906	56.6	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
31884025	31884025	PRJNA690592_S_NODE_140237_length_285_cov_1.448113_g139223_i0	PRJNA690592	140237	285	1.448113	4.12712205	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	47	0.00119	NR	XP_063679576.1	2820187	g139223	i0	34.1	0.894736842105263	85	54	88.4	2	255	4	67	150	XP_063679576.1 calcium and integrin-binding family member 3-like isoform X1 [Bolinopsis microptera]	diamond	255	47	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
32010783	32010783	PRJNA690592_S_NODE_28478_length_565_cov_2.558943_g27480_i0	PRJNA690592	28478	565	2.558943	14.45802795	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	154	5.31e-40	NR	XP_063678953.1	2820187	g27480	i0	63.4	1.91681415929204	123	38	61.6	1	490	143	34	156	XP_063678953.1 dynamin-1-like protein [Bolinopsis microptera]	diamond	1083	154	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
32485491	32485491	PRJNA690592_S_NODE_176419_length_257_cov_1.554348_g175405_i0	PRJNA690592	176419	257	1.554348	3.99467436	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	127	2.28e-33	NR	XP_063681920.1	2820187	g175405	i0	64.7	0.992217898832685	85	30	99.2	0	257	3	72	156	XP_063681920.1 uncharacterized protein LOC134816850 [Bolinopsis microptera]	diamond	255	127	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
32674398	32674398	PRJNA690592_S_NODE_114420_length_310_cov_1.624473_g113406_i0	PRJNA690592	114420	310	1.624473	5.0358663	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	61.2	2.56e-8	NR	XP_063686869.1	2820187	g113406	i0	32.1	1.0258064516129	106	55	86.1	1	21	287	545	650	XP_063686869.1 two pore channel protein 2-like [Bolinopsis microptera]	diamond	318	61.2	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
32863633	32863633	PRJNA690592_S_NODE_98560_length_329_cov_2.554688_g97546_i0	PRJNA690592	98560	329	2.554688	8.40492352	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	55.1	3.83e-6	NR	XP_063684752.1	2820187	g97546	i0	67.6	0.693009118541033	34	11	31	0	162	263	12	45	XP_063684752.1 CCR4-NOT transcription complex subunit 7-like [Bolinopsis microptera]	diamond	228	55.1	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera

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