metadata: contig_metadata: 4 rows where bioproject = "PRJNA597223", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA597223", 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
26890241	26890241	PRJNA597223_P_NODE_64281_length_180_cov_3.124138_g62435_i0	PRJNA597223	64281	180	3.124138	5.6234484	Corticium candelabrum	121492	Porifera	other_Eukaryota	53.9	1.87e-6	NR	XP_062505036.1	121492	g62435	i0	45.8	3.83333333333333	59	32	98.3	0	180	4	215	273	XP_062505036.1 uncharacterized protein LOC134181751 [Corticium candelabrum]	diamond	690	53.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27617041	27617041	PRJNA597223_P_NODE_13484_length_462_cov_1.742389_g11715_i0	PRJNA597223	13484	462	1.742389	8.04983718	Geodia barretti	519541	Porifera	other_Eukaryota	137	8.37e-38	NR	CAI8030757.1	519541	g11715	i0	50.3	2.04545454545455	157	63	97.4	6	459	10	27	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	945	137	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30111371	30111371	PRJNA597223_P_NODE_36792_length_239_cov_1.872549_g34946_i0	PRJNA597223	36792	239	1.872549	4.47539211	Halichondria panicea	6063	Porifera	other_Eukaryota	57.4	2.46e-7	NR	XP_064383376.1	6063	g34946	i0	56.9	1.30543933054393	51	19	64	1	7	159	754	801	XP_064383376.1 uncharacterized protein LOC135332001 [Halichondria panicea]	diamond	312	57.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30553618	30553618	PRJNA597223_P_NODE_29773_length_277_cov_2.140496_g27927_i0	PRJNA597223	29773	277	2.140496	5.92917392	Halisarca dujardinii	2583056	Porifera	other_Eukaryota	44.7	0.0125	NR	WLO57499.1	2583056	g27927	i0	38.9	0.779783393501805	72	41	74.7	2	52	258	2416	2487	WLO57499.1 CRB [Halisarca dujardinii]	diamond	216	44.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Chondrillida	Halisarcidae	Halisarca	Halisarca dujardinii

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