metadata: contig_metadata: 7 rows where bioproject = "PRJNA1192965", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA1192965", tax_kingdom = "Metazoa" 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
27376177	27376177	PRJNA1192965_P_NODE_2943_length_261_cov_1.638298_g2924_i0	PRJNA1192965	2943	261	1.638298	4.27595778	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	51.6	3.64e-5	NR	XP_057298452.1	13093	g2924	i0	33.7	7.40229885057471	92	54	97.7	3	1	255	146	237	XP_057298452.1 vacuolar protein sorting-associated protein 18 homolog [Hydractinia symbiolongicarpus]	diamond	1932	52	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
28051468	28051468	PRJNA1192965_P_NODE_3525_length_250_cov_0.870056_g3506_i0	PRJNA1192965	3525	250	0.870056	2.17514	Montipora capricornis	246305	Cnidaria	other_Eukaryota	55.5	1.34e-6	NR	XP_068738415.1	246305	g3506	i0	50	0.48	40	20	48	0	1	120	531	570	XP_068738415.1 cathepsin S-like [Montipora capricornis]	diamond	120	55.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
30564985	30564985	PRJNA1192965_P_NODE_3073_length_257_cov_1.445652_g3054_i0	PRJNA1192965	3073	257	1.445652	3.71532564	Montipora	46703	Cnidaria	other_Eukaryota	48.5	4.26e-4	NR	XP_068751454.1	246305	g3054	i0	39	4.9727626459144	77	44	88.7	3	254	27	4712	4786	XP_068751454.1 LOW QUALITY PROTEIN: muscle M-line assembly protein unc-89-like [Montipora capricornis]	diamond	1278	48.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
30894026	30894026	PRJNA1192965_P_NODE_974_length_393_cov_2.575000_g955_i0	PRJNA1192965	974	393	2.575	10.11975	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	68.6	1.39e-10	NR	XP_020609478.1	48498	g955	i0	43	0.709923664122137	93	47	66.4	2	262	2	196	288	XP_020609478.1 uncharacterized protein LOC110048052 isoform X1 [Orbicella faveolata]	diamond	279	68.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
31526242	31526242	PRJNA1192965_P_NODE_596_length_482_cov_2.931540_g577_i0	PRJNA1192965	596	482	2.93154	14.1300228	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	185	7.079999999999999e-54	NR	XP_057312925.1	13093	g577	i0	64.2	1.65560165975104	137	48	85.3	1	69	479	45	180	XP_057312925.1 gastric triacylglycerol lipase-like [Hydractinia symbiolongicarpus]	diamond	798	185	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
31861293	31861293	PRJNA1192965_P_NODE_3397_length_251_cov_0.865169_g3378_i0	PRJNA1192965	3397	251	0.865169	2.17157419	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.2	7.11e-7	NR	XP_065059632.1	499914	g3378	i0	45.3	3.2390438247012	64	34	75.3	1	217	29	44	107	XP_065059632.1 uncharacterized protein LOC135687102 [Rhopilema esculentum]	diamond	813	56.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
32304695	32304695	PRJNA1192965_P_NODE_4279_length_246_cov_0.890173_g4260_i0	PRJNA1192965	4279	246	0.890173	2.18982558	Opisthokonta	33154	Cnidaria	other_Eukaryota	60.5	5.55e-9	NR	XP_057303610.1	13093	g4260	i0	41.5	4.90243902439024	82	35	84.1	3	31	237	11	92	XP_057303610.1 peptidyl-prolyl cis-trans isomerase H-like [Hydractinia symbiolongicarpus]	diamond	1206	60.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus

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