metadata: contig_metadata: 6 rows where bioproject = "PRJNA512103" and tax

6 rows where bioproject = "PRJNA512103" 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
15138918	15138918	PRJNA512103_P_NODE_32372_length_166_cov_0.888889_g31960_i0	PRJNA512103	32372	166	0.888889	1.47555574	Metazoa	33208	Cnidaria	other_Eukaryota	52.8	0.014	NTclustered	gi\|2917940735\|emb\|OZ237565.1\|	6108	g31960	i0	100	0.337349397590361	28	0	17	0	126	153	8427652	8427625	Anemonia sulcata genome assembly, chromosome: 11	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
28688018	28688018	PRJNA512103_P_NODE_17007_length_240_cov_1.371728_g16595_i0	PRJNA512103	17007	240	1.371728	3.2921472	Porites lobata	104759	Cnidaria	other_Eukaryota	75.9	7.71e-14	NR	CAH3149612.1	104759	g16595	i0	51.4	1.875	74	33	92.5	1	229	8	203	273	CAH3149612.1 unnamed protein product, partial [Porites lobata]	diamond	450	75.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
29934777	29934777	PRJNA512103_P_NODE_26231_length_183_cov_2.432836_g25819_i0	PRJNA512103	26231	183	2.432836	4.45208988	Metazoa	33208	Cnidaria	other_Eukaryota	42.7	0.00224	NR	CAH3176864.1	104178	g25819	i0	48.9	4.83606557377049	45	23	73.8	0	139	5	9	53	CAH3176864.1 unnamed protein product [Porites evermanni]	diamond	885	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
31246216	31246216	PRJNA512103_P_NODE_22795_length_198_cov_1.221477_g22383_i0	PRJNA512103	22795	198	1.221477	2.41852446	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	45.1	0.00306	NR	CAB4037527.1	317549	g22383	i0	62.5	2.90909090909091	32	12	48.5	0	179	84	299	330	CAB4037527.1 RNA-directed DNA polymerase from mobile element jockey, partial [Paramuricea clavata]	diamond	576	45.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
32068571	32068571	PRJNA512103_P_NODE_31278_length_168_cov_0.873950_g30866_i0	PRJNA512103	31278	168	0.87395	1.468236	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	67.4	2.79e-11	NR	PFX18804.1	50429	g30866	i0	60.8	2.73214285714286	51	20	91.1	0	159	7	1043	1093	PFX18804.1 putative uncharacterized transposon-derived protein F54H12.3 [Stylophora pistillata]	diamond	459	67.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
32416849	32416849	PRJNA512103_P_NODE_21839_length_203_cov_1.318182_g21427_i0	PRJNA512103	21839	203	1.318182	2.67590946	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	66.2	1.14e-10	NR	XP_065658632.1	6087	g21427	i0	43.9	2.92610837438424	66	37	97.5	0	6	203	735	800	XP_065658632.1 uncharacterized protein LOC136083154 [Hydra vulgaris]	diamond	594	66.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris

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