metadata: contig_metadata: 5 rows where bioproject = "PRJNA560029" and tax

5 rows where bioproject = "PRJNA560029" 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
8196600	8196600	PRJNA560029_S_NODE_11607_length_354_cov_1.544484_g11383_i0	PRJNA560029	11607	354	1.544484	5.46747336	Acropora muricata	159855	Cnidaria	other_Eukaryota	608	1.579999999999999e-169	NTclustered	gi\|2784647938\|ref\|XM_067181884.1\|	159855	g11383	i0	100	5.73446327683616	329	0	93	0	1	329	1190	862	PREDICTED: Acropora muricata ras-related protein Rap-2a-like (LOC136914924), mRNA	blastn	2030	608	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora muricata
26966382	26966382	PRJNA560029_S_NODE_23522_length_286_cov_2.530516_g23298_i0	PRJNA560029	23522	286	2.530516	7.23727576	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.1	0.038	NR	XP_022796208.1	50429	g23298	i0	49.1	1.73076923076923	55	15	57.7	1	120	284	190	231	XP_022796208.1 LOW QUALITY PROTEIN: uncharacterized protein LOC111334664 [Stylophora pistillata]	diamond	495	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
29604902	29604902	PRJNA560029_S_NODE_9830_length_368_cov_6.762712_g9606_i0	PRJNA560029	9830	368	6.762712	24.88678016	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	83.6	2.73e-16	NR	XP_027046094.1	46731	g9606	i0	54.5	3.22826086956522	66	29	53.8	1	9	206	246	310	XP_027046094.1 cathepsin B-like protease 3 [Pocillopora damicornis]	diamond	1188	83.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
31690795	31690795	PRJNA560029_S_NODE_36537_length_232_cov_2.861635_g36313_i0	PRJNA560029	36537	232	2.861635	6.6389932	Montipora foliosa	591990	Cnidaria	other_Eukaryota	44.7	0.00636	NR	XP_068680545.1	591990	g36313	i0	52.3	2.27586206896552	44	21	56.9	0	7	138	240	283	XP_068680545.1 uncharacterized protein [Montipora foliosa]	diamond	528	45.1	0.991130820399113	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
31943747	31943747	PRJNA560029_S_NODE_18657_length_309_cov_4.203390_g18433_i0	PRJNA560029	18657	309	4.20339	12.9884751	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	58.9	8.36e-8	NR	KAF1743895.1	59785	g18433	i0	80.6	0.349514563106796	36	7	35	0	307	200	154	189	KAF1743895.1 hypothetical protein MXB_2717 [Myxobolus squamalis]	diamond	108	58.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis

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