metadata: contig_metadata: 3 rows where bioproject = "PRJNA560029", tax_kingdom = "Metazoa" and tax

3 rows where bioproject = "PRJNA560029", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

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
26712903	26712903	PRJNA560029_S_NODE_23061_length_288_cov_2.744186_g22837_i0	PRJNA560029	23061	288	2.744186	7.90325568	Opisthokonta	33154	Porifera	other_Eukaryota	111	4.14e-29	NR	XP_065899758.1	196820	g22837	i0	77	6.35416666666667	61	14	63.5	0	287	105	70	130	XP_065899758.1 small ribosomal subunit protein uS8 [Dysidea avara]	diamond	1830	111	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
31374702	31374702	PRJNA560029_S_NODE_25156_length_279_cov_1.199029_g24932_i0	PRJNA560029	25156	279	1.199029	3.34529091	Sycon ciliatum	27933	Porifera	other_Eukaryota	106	1.5600000000000002e-26	NR	XP_065181097.1	27933	g24932	i0	69.6	1.45161290322581	69	21	74.2	0	61	267	1	69	XP_065181097.1 vacuolar protein sorting-associated protein 29-like [Sycon ciliatum]	diamond	405	106	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32796845	32796845	PRJNA560029_S_NODE_28200_length_266_cov_1.430052_g27976_i0	PRJNA560029	28200	266	1.430052	3.80393832	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	62	7.33e-9	NR	XP_003385580.1	400682	g27976	i0	50	1.46616541353383	58	28	65.4	1	1	174	271	327	XP_003385580.1 PREDICTED: alpha-(1,3)-fucosyltransferase 6-like [Amphimedon queenslandica]	diamond	390	62	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica

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