metadata: contig_metadata: 5 rows where bioproject = "PRJEB12366", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJEB12366", 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
7672996	7672996	PRJEB12366_P_NODE_5587_length_347_cov_2.560897_g5397_i0	PRJEB12366	5587	347	2.560897	8.88631259	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	239	2.35e-58	NTclustered	gi\|2782926566\|ref\|XM_067073072.1\|	252671	g5397	i0	80.308	35.6484149855908	325	56	93	8	12	332	1755	1435	PREDICTED: Clytia hemisphaerica endoplasmic reticulum chaperone BiP-like (LOC136816755), mRNA	blastn	12370	239	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
14048854	14048854	PRJEB12366_P_NODE_1292_length_754_cov_8.089013_g1152_i0	PRJEB12366	1292	754	8.089013	60.99115802	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	381	8.489999999999998e-101	NTclustered	gi\|2518998737\|ref\|XM_057450856.1\|	13093	g1152	i0	83.831	116.144562334218	402	63	53	2	120	520	759	359	PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA	blastn	87573	381	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
14048876	14048876	PRJEB12366_P_NODE_1992_length_611_cov_11.090278_g1828_i0	PRJEB12366	1992	611	11.090278	67.76159858	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	305	4.21e-78	NTclustered	gi\|2744794010\|ref\|XM_012698561.3\|	6087	g1828	i0	81.432	21.2716857610475	377	66	61	4	128	502	217	591	PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA	blastn	12997	305	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
19146305	19146305	PRJEB12366_P_NODE_7876_length_279_cov_2.290984_g7686_i0	PRJEB12366	7876	279	2.290984	6.39184536	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	219	2.3899999999999993e-52	NTclustered	gi\|1603821435\|ref\|XM_028559402.1\|	151771	g7686	i0	83.475	13.6989247311828	236	38	84	1	3	237	398	633	PREDICTED: Dendronephthya gigantea thioredoxin-like protein 4A (LOC114538252), mRNA	blastn	3822	219	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
27001160	27001160	PRJEB12366_P_NODE_13982_length_192_cov_1.707006_g13792_i0	PRJEB12366	13982	192	1.707006	3.27745152	Montipora capricornis	246305	Cnidaria	other_Eukaryota	64.3	5.69e-11	NR	XP_068723979.1	246305	g13792	i0	52.4	0.984375	63	30	98.4	0	191	3	7	69	XP_068723979.1 uncharacterized protein [Montipora capricornis]	diamond	189	64.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis

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