metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
56042	56042	PRJEB3181_P_NODE_5621_length_345_cov_3.000000_g5367_i0	PRJEB3181	5621	345	3	10.35	Geodia barretti	519541	Porifera	other_Eukaryota	147	4.829999999999999e-42	NR	CAI8032315.1	519541	g5367	i0	73.7	0.826086956521739	95	25	82.6	0	1	285	41	135	CAI8032315.1 40S ribosomal protein S8 [Geodia barretti]	diamond	285	147	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
10258723	10258723	PRJEB3181_P_NODE_3269_length_417_cov_8.129534_g3036_i0	PRJEB3181	3269	417	8.129534	33.90015678	Geodia barretti	519541	Porifera	other_Eukaryota	164	9.63e-47	NR	CAI8026159.1	519541	g3036	i0	65.1	1.57553956834532	109	36	77	1	401	81	215	323	CAI8026159.1 Cathepsin B [Geodia barretti]	diamond	657	164	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
12809635	12809635	PRJEB3181_S_NODE_2371_length_350_cov_317.555556_g2078_i0	PRJEB3181	2371	350	317.555556	1111.444446	Opisthokonta	33154	Porifera	other_Eukaryota	64.3	1.74e-10	NR	AAX48897.1	55567	g2078	i0	65.1	3.98571428571429	43	15	36.9	0	2	130	75	117	AAX48897.1 S20 [Suberites domuncula]	diamond	1395	64.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
27791563	27791563	PRJEB3181_P_NODE_4664_length_370_cov_4.386431_g4416_i0	PRJEB3181	4664	370	4.386431	16.2297947	Sycon ciliatum	27933	Porifera	other_Eukaryota	97.1	1.75e-22	NR	XP_065177154.1	27933	g4416	i0	60	1.2972972972973	80	32	64.9	0	370	131	100	179	XP_065177154.1 peroxiredoxin-5, mitochondrial-like [Sycon ciliatum]	diamond	480	97.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32049816	32049816	PRJEB3181_P_NODE_18758_length_191_cov_1.318750_g18494_i0	PRJEB3181	18758	191	1.31875	2.5188125	root	1	Root_unresolved	Root_unresolved	63.2	1.05e-9	NR	XP_019857249.1	400682	g18494	i0	57.8	1.3979057591623	45	15	64.4	1	186	64	296	340	XP_019857249.1 PREDICTED: cathepsin O-like [Amphimedon queenslandica]	diamond	267	63.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
32056371	32056371	PRJEB3181_P_NODE_10278_length_265_cov_1.717949_g10014_i0	PRJEB3181	10278	265	1.717949	4.55256485	Oopsacas minuta	111878	Porifera	other_Eukaryota	95.1	7.969999999999999e-23	NR	KAI6654715.1	111878	g10014	i0	64.7	6.16981132075472	68	24	77	0	257	54	54	121	KAI6654715.1 Ribosomal protein L32 [Oopsacas minuta]	diamond	1635	95.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta

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