metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB11748" 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
9912853	9912853	PRJEB11748_P_NODE_370588_length_187_cov_5.126984_g368405_i0	PRJEB11748	370588	187	5.126984	9.58746008	root	1	Root_unresolved	Root_unresolved	79.3	3.91e-16	NR	CAI8010652.1	519541	g368405	i0	80	2.16577540106952	45	9	72.2	0	175	41	103	147	CAI8010652.1 Uncharacterized protein BH2278 [Geodia barretti]	diamond	405	79.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
25210302	25210302	PRJEB11748_P_NODE_300860_length_219_cov_2.348101_g298677_i0	PRJEB11748	300860	219	2.348101	5.14234119	root	1	Root_unresolved	Root_unresolved	87.8	3.59e-18	NR	CAI8038099.1	519541	g298677	i0	61	3.94520547945205	59	20	76.7	1	33	200	16	74	CAI8038099.1 Assimilatory nitrate reductase catalytic subunit [Geodia barretti]	diamond	864	88.6	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
31865855	31865855	PRJEB11748_P_NODE_174277_length_307_cov_19.154472_g172094_i0	PRJEB11748	174277	307	19.154472	58.80422904	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	43.5	0.0404	NR	XP_019855979.1	400682	g172094	i0	31.7	0.801302931596091	82	47	73.3	2	39	263	190	269	XP_019855979.1 PREDICTED: BRCA1-associated protein-like [Amphimedon queenslandica]	diamond	246	43.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
32404028	32404028	PRJEB11748_P_NODE_13379_length_1293_cov_4.896916_g12192_i0	PRJEB11748	13379	1293	4.896916	63.31712388	Dysidea avara	196820	Porifera	other_Eukaryota	55.5	3.67e-4	NR	XP_065905315.1	196820	g12192	i0	32	1.25986078886311	147	63	26.5	3	810	1151	184	326	XP_065905315.1 ATP-dependent DNA helicase PIF1-like [Dysidea avara]	diamond	1629	55.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32688024	32688024	PRJEB11748_P_NODE_217880_length_269_cov_2.951923_g215697_i0	PRJEB11748	217880	269	2.951923	7.94067287	Corticium candelabrum	121492	Porifera	other_Eukaryota	45.4	0.00585	NR	XP_062500681.1	121492	g215697	i0	35.8	0.747211895910781	67	42	73.6	1	43	240	256	322	XP_062500681.1 uncharacterized protein LOC134177920 [Corticium candelabrum]	diamond	201	45.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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