metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA564810" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA564810" 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
27819765	27819765	PRJNA564810_S_NODE_4744_length_258_cov_2.466321_g4722_i0	PRJNA564810	4744	258	2.466321	6.36310818	Metazoa	33208	Cnidaria	other_Eukaryota	75.9	9.3e-14	NR	KAK2567556.1	6130	g4722	i0	51.4	3.04651162790698	70	34	81.4	0	257	48	428	497	KAK2567556.1 Thymus-specific serine protease [Acropora cervicornis]	diamond	786	76.6	0.990861618798956	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
28040690	28040690	PRJNA564810_S_NODE_7165_length_221_cov_2.615385_g7143_i0	PRJNA564810	7165	221	2.615385	5.78000085	root	1	Root_unresolved	Root_unresolved	57.4	1.88e-7	NR	XP_028399362.1	151771	g7143	i0	54.9	5.00904977375566	51	22	69.2	1	30	182	439	488	XP_028399362.1 LOW QUALITY PROTEIN: uncharacterized protein LOC114522812 [Dendronephthya gigantea]	diamond	1107	57.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
28419642	28419642	PRJNA564810_S_NODE_1026_length_402_cov_1.771513_g1004_i0	PRJNA564810	1026	402	1.771513	7.12148226	Anthozoa	6101	Cnidaria	other_Eukaryota	52	1.14e-4	NR	XP_028400048.1	151771	g1004	i0	46.4	1.11194029850746	56	25	39.6	2	130	288	314	367	XP_028400048.1 zinc metalloproteinase nas-15-like [Dendronephthya gigantea]	diamond	447	52	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
29177449	29177449	PRJNA564810_S_NODE_3449_length_286_cov_1.800905_g3427_i0	PRJNA564810	3449	286	1.800905	5.1505883	Metazoa	33208	Cnidaria	other_Eukaryota	43.5	0.0326	NR	XP_031557408.1	6105	g3427	i0	47.3	2.08741258741259	55	26	57.7	2	3	167	662	713	XP_031557408.1 RING finger protein nhl-1-like [Actinia tenebrosa]	diamond	597	43.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
29573772	29573772	PRJNA564810_S_NODE_3070_length_296_cov_2.060606_g3048_i0	PRJNA564810	3070	296	2.060606	6.09939376	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	52	6.87e-6	NR	XP_065672877.1	6087	g3048	i0	37.3	1.40878378378378	75	38	66.9	1	246	49	49	123	XP_065672877.1 chromosome transmission fidelity protein 8 homolog isoform X2 [Hydra vulgaris]	diamond	417	52	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30364102	30364102	PRJNA564810_S_NODE_2412_length_318_cov_4.541502_g2390_i0	PRJNA564810	2412	318	4.541502	14.44197636	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	48.5	8.5e-4	NR	XP_028395858.1	151771	g2390	i0	35.3	1.55660377358491	51	33	48.1	0	3	155	310	360	XP_028395858.1 uncharacterized protein LOC114519877 [Dendronephthya gigantea]	diamond	495	48.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
30851303	30851303	PRJNA564810_S_NODE_3074_length_296_cov_1.636364_g3052_i0	PRJNA564810	3074	296	1.636364	4.84363744	Metazoa	33208	Cnidaria	other_Eukaryota	73.9	7.61e-13	NR	CAH3165815.1	104178	g3052	i0	40.4	1.76351351351351	89	48	88.2	3	6	266	733	818	CAH3165815.1 unnamed protein product, partial [Porites evermanni]	diamond	522	73.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
31009291	31009291	PRJNA564810_S_NODE_1374_length_371_cov_3.683007_g1352_i0	PRJNA564810	1374	371	3.683007	13.66395597	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.9	9.59e-17	NR	XP_002160212.1	6087	g1352	i0	39.8	6.76010781671159	98	59	79.2	0	366	73	339	436	XP_002160212.1 retinoid-inducible serine carboxypeptidase [Hydra vulgaris]	diamond	2508	86.3	0.995365005793743	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
31059101	31059101	PRJNA564810_S_NODE_4695_length_259_cov_1.690722_g4673_i0	PRJNA564810	4695	259	1.690722	4.37896998	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	42.7	0.0471	NR	XP_046850772.1	2897299	g4673	i0	52.9	0.393822393822394	34	15	38.2	1	70	168	1238	1271	XP_046850772.1 phosphoinositide 3-kinase regulatory subunit 4-like isoform X2 [Xenia sp. Carnegie-2017]	diamond	102	42.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
31072585	31072585	PRJNA564810_S_NODE_5035_length_253_cov_1.941489_g5013_i0	PRJNA564810	5035	253	1.941489	4.91196717	Opisthokonta	33154	Cnidaria	other_Eukaryota	86.3	1.33e-17	NR	XP_057310115.1	13093	g5013	i0	67.9	8.66798418972332	56	18	66.4	0	4	171	324	379	XP_057310115.1 methionine aminopeptidase 1-like [Hydractinia symbiolongicarpus]	diamond	2193	86.7	0.995386389850058	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
31230331	31230331	PRJNA564810_S_NODE_4475_length_263_cov_1.843434_g4453_i0	PRJNA564810	4475	263	1.843434	4.84823142	Metazoa	33208	Cnidaria	other_Eukaryota	44.3	0.0136	NR	CAH3127234.1	104759	g4453	i0	52.4	1.52851711026616	42	20	47.9	0	259	134	599	640	CAH3127234.1 unnamed protein product [Porites lobata]	diamond	402	44.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata

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