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

6 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_phylum = "Cnidaria"

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
3320769	3320769	PRJNA788929_P_NODE_4023_length_1020_cov_45.826822_g3542_i0	PRJNA788929	4023	1020	45.826822	467.4335844	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	184	6.34e-48	NR	XP_065669112.1	6087	g3542	i0	43.3	8.03529411764706	238	120	68.5	5	224	922	683	910	XP_065669112.1 uncharacterized protein LOC100212061 isoform X3 [Hydra vulgaris]	diamond	8196	184	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
24995868	24995868	PRJNA788929_P_NODE_29760_length_289_cov_19.851852_g29099_i0	PRJNA788929	29760	289	19.851852	57.37185228	Metazoa	33208	Cnidaria	other_Eukaryota	80.9	2.35e-15	NR	XP_031570540.1	6105	g29099	i0	47.6	2.58477508650519	84	38	86.2	2	30	278	319	397	XP_031570540.1 E3 ubiquitin-protein ligase CHFR-like [Actinia tenebrosa]	diamond	747	81.3	0.995079950799508	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
27947403	27947403	PRJNA788929_P_NODE_5505_length_838_cov_48.393464_g4912_i0	PRJNA788929	5505	838	48.393464	405.53722832	Metazoa	33208	Cnidaria	other_Eukaryota	141	6.669999999999999e-37	NR	EDO26941.1	45351	g4912	i0	67	11.4164677804296	109	34	39	1	515	189	129	235	EDO26941.1 predicted protein [Nematostella vectensis]	diamond	9567	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
28411844	28411844	PRJNA788929_P_NODE_21466_length_351_cov_13.258993_g20805_i0	PRJNA788929	21466	351	13.258993	46.53906543	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	87	4.02e-17	NR	XP_057310772.1	13093	g20805	i0	50.7	1.97435897435897	73	36	62.4	0	44	262	2464	2536	XP_057310772.1 lipoxygenase homology domain-containing protein 1-like [Hydractinia symbiolongicarpus]	diamond	693	87	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29715172	29715172	PRJNA788929_P_NODE_21790_length_348_cov_14.461818_g21129_i0	PRJNA788929	21790	348	14.461818	50.32712664	Metazoa	33208	Cnidaria	other_Eukaryota	139	2.13e-35	NR	XP_001628323.2	45351	g21129	i0	56.6	6.81034482758621	113	42	92.2	2	324	4	51	162	XP_001628323.2 protein DD3-3 [Nematostella vectensis]	diamond	2370	139	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30433219	30433219	PRJNA788929_P_NODE_13473_length_466_cov_55.541985_g12816_i0	PRJNA788929	13473	466	55.541985	258.8256501	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	199	1.7e-60	NR	KAK3744473.1	3060491	g12816	i0	64.4	0.959227467811159	149	50	95.9	1	463	17	150	295	KAK3744473.1 hypothetical protein QZH41_012875 [Actinostola sp. cb2023]	diamond	447	199	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023

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