metadata: contig_metadata: 8 rows where bioproject = "PRJNA1034995", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA1034995", tax_clade = "Opisthokonta" 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
9935805	9935805	PRJNA1034995_S_NODE_44868_length_183_cov_1.971429_g44712_i0	PRJNA1034995	44868	183	1.971429	3.60771507	Metazoa	33208	Cnidaria	other_Eukaryota	60.2	9.31e-5	NTclustered	gi\|2917940744\|emb\|OZ237568.1\|	6108	g44712	i0	97.143	4.57377049180328	35	1	19	0	149	183	13201173	13201139	Anemonia sulcata genome assembly, chromosome: 14	blastn	837	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
10371606	10371606	PRJNA1034995_S_NODE_22089_length_353_cov_14.558065_g21933_i0	PRJNA1034995	22089	353	14.558065	51.38996945	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	52.8	0.033	NTclustered	gi\|2202666560\|ref\|XR_006951441.1\|	2897299	g21933	i0	100	0.0793201133144476	28	0	8	0	1	28	1	28	PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
11647076	11647076	PRJNA1034995_S_NODE_39350_length_208_cov_5.296970_g39194_i0	PRJNA1034995	39350	208	5.29697	11.0176976	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	78.7	3.01e-10	NTclustered	gi\|1603828867\|ref\|XR_003690265.1\|	151771	g39194	i0	100	20.7980769230769	42	0	20	0	167	208	2567	2526	PREDICTED: Dendronephthya gigantea large subunit ribosomal RNA (LOC114543997), rRNA	blastn	4326	78.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
12922246	12922246	PRJNA1034995_S_NODE_41011_length_200_cov_2.343949_g40855_i0	PRJNA1034995	41011	200	2.343949	4.687898	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	52.8	0.017	NTclustered	gi\|2202666560\|ref\|XR_006951441.1\|	2897299	g40855	i0	100	0.14	28	0	14	0	173	200	28	1	PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
18020212	18020212	PRJNA1034995_S_NODE_19035_length_401_cov_13.932961_g18880_i0	PRJNA1034995	19035	401	13.932961	55.87117361	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	52.8	0.038	NTclustered	gi\|2202666560\|ref\|XR_006951441.1\|	2897299	g18880	i0	92.105	0.094763092269326707	38	2	9	1	365	401	38	1	PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA	blastn	38	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
26741873	26741873	PRJNA1034995_S_NODE_17661_length_428_cov_25.716883_g17506_i0	PRJNA1034995	17661	428	25.716883	110.06825924	Metazoa	33208	Cnidaria	other_Eukaryota	118	1.71e-28	NR	XP_031551892.1	6105	g17506	i0	95.2	10.0163551401869	62	3	43.5	0	300	115	181	242	XP_031551892.1 COP9 signalosome complex subunit 2-like [Actinia tenebrosa]	diamond	4287	119	0.991596638655462	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
31646835	31646835	PRJNA1034995_S_NODE_47057_length_174_cov_3.862595_g46901_i0	PRJNA1034995	47057	174	3.862595	6.7209153	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	44.3	0.00418	NR	CAB4016621.1	317549	g46901	i0	60.7	0.948275862068966	28	11	48.3	0	2	85	543	570	CAB4016621.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	165	44.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
32564796	32564796	PRJNA1034995_S_NODE_12639_length_609_cov_18.489399_g12525_i0	PRJNA1034995	12639	609	18.489399	112.60043991	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	60.8	6.47e-7	NR	XP_020617195.1	48498	g12525	i0	82.4	2.45320197044335	34	6	16.7	0	12	113	62	95	XP_020617195.1 LOW QUALITY PROTEIN: kinesin heavy chain-like [Orbicella faveolata]	diamond	1494	61.2	0.993464052287582	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata

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