metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA682078" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA682078" 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
10862867	10862867	PRJNA682078_P_NODE_15309_length_881_cov_1.815594_g13868_i0	PRJNA682078	15309	881	1.815594	15.99538314	Metazoa	33208	Cnidaria	other_Eukaryota	114	2.45e-27	NR	AAB61388.1	6087	g13868	i0	49.5	0.664018161180477	97	48	32.7	1	753	466	28	124	AAB61388.1 transposase, partial [Hydra vulgaris]	diamond	585	114	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
27619247	27619247	PRJNA682078_P_NODE_165884_length_283_cov_1.466667_g164107_i0	PRJNA682078	165884	283	1.466667	4.15066761	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	43.1	0.0428	NR	XP_065662605.1	6087	g164107	i0	44.7	0.402826855123675	38	21	40.3	0	3	116	496	533	XP_065662605.1 uncharacterized protein LOC136085244 [Hydra vulgaris]	diamond	114	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28281978	28281978	PRJNA682078_P_NODE_200026_length_263_cov_1.257895_g198249_i0	PRJNA682078	200026	263	1.257895	3.30826385	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	48.1	5.91e-4	NR	XP_012563354.1	6087	g198249	i0	33.3	0.958174904942966	84	45	83.3	1	37	255	326	409	XP_012563354.1 unnamed protein product [Hydra vulgaris]	diamond	252	48.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28755835	28755835	PRJNA682078_P_NODE_291047_length_241_cov_0.916667_g289270_i0	PRJNA682078	291047	241	0.916667	2.20916747	Acropora cervicornis	6130	Cnidaria	other_Eukaryota	43.1	0.0137	NR	KAK2570620.1	6130	g289270	i0	95	0.24896265560166	20	1	24.9	0	33	92	82	101	KAK2570620.1 hypothetical protein P5673_004304 [Acropora cervicornis]	diamond	60	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
29556723	29556723	PRJNA682078_P_NODE_294270_length_237_cov_2.567073_g292493_i0	PRJNA682078	294270	237	2.567073	6.08396301	Metazoa	33208	Cnidaria	other_Eukaryota	45.4	0.00269	NR	XP_065659023.1	6087	g292493	i0	44	5.81012658227848	50	25	63.3	1	12	161	133	179	XP_065659023.1 histone-lysine N-methyltransferase SETMAR-like [Hydra vulgaris]	diamond	1377	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30429973	30429973	PRJNA682078_P_NODE_169173_length_281_cov_1.480769_g167396_i0	PRJNA682078	169173	281	1.480769	4.16096089	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	60.5	3.5e-8	NR	CAB4003876.1	317549	g167396	i0	50	3.48042704626335	82	36	84.3	2	239	3	1007	1086	CAB4003876.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	978	60.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31630623	31630623	PRJNA682078_P_NODE_135076_length_309_cov_1.288136_g133299_i0	PRJNA682078	135076	309	1.288136	3.98034024	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	50.8	1.16e-4	NR	KXJ06829.1	2652724	g133299	i0	29.5	0.922330097087379	95	61	91.3	2	298	17	738	827	KXJ06829.1 RNA-directed DNA polymerase from mobile element jockey [Exaiptasia diaphana]	diamond	285	50.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
31630647	31630647	PRJNA682078_P_NODE_206076_length_259_cov_2.005376_g204299_i0	PRJNA682078	206076	259	2.005376	5.19392384	Acropora cervicornis	6130	Cnidaria	other_Eukaryota	43.5	0.0248	NR	KAK2572409.1	6130	g204299	i0	46.3	0.474903474903475	41	22	47.5	0	258	136	171	211	KAK2572409.1 hypothetical protein P5673_002650 [Acropora cervicornis]	diamond	123	43.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis

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