metadata: contig_metadata: 5 rows where bioproject = "PRJNA751877", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA751877", 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
26904610	26904610	PRJNA751877_P_NODE_6201_length_405_cov_2.084337_g6079_i0	PRJNA751877	6201	405	2.084337	8.44156485	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	128	1.42e-34	NR	XP_064407071.1	6063	g6079	i0	55.3	19.2740740740741	132	51	91.9	3	398	27	56	187	XP_064407071.1 large ribosomal subunit protein eL18-like [Halichondria panicea]	diamond	7806	128	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28284306	28284306	PRJNA751877_P_NODE_23586_length_250_cov_0.870056_g23464_i0	PRJNA751877	23586	250	0.870056	2.17514	Oscarella lobularis	121494	Porifera	other_Eukaryota	62.4	4.89e-9	NR	XP_065844534.1	121494	g23464	i0	50.9	0.684	57	22	63.6	3	248	90	1410	1464	XP_065844534.1 uncharacterized protein [Oscarella lobularis]	diamond	171	62.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28515551	28515551	PRJNA751877_P_NODE_23507_length_250_cov_0.870056_g23385_i0	PRJNA751877	23507	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	82	5.91e-16	NR	XP_062507646.1	121492	g23385	i0	60.4	2.772	53	21	63.6	0	230	72	32	84	XP_062507646.1 fibropellin-1-like [Corticium candelabrum]	diamond	693	82.4	0.995145631067961	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31199736	31199736	PRJNA751877_P_NODE_8755_length_363_cov_1.062069_g8633_i0	PRJNA751877	8755	363	1.062069	3.85531047	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	76.3	2.17e-13	NR	XP_065186805.1	27933	g8633	i0	50	1.88429752066116	72	36	59.5	0	117	332	55	126	XP_065186805.1 regulator of chromosome condensation-like [Sycon ciliatum]	diamond	684	76.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32012659	32012659	PRJNA751877_P_NODE_5258_length_428_cov_1.301408_g5136_i0	PRJNA751877	5258	428	1.301408	5.57002624	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	115	6.65e-28	NR	XP_003384600.1	400682	g5136	i0	51.4	1.50700934579439	109	51	76.4	1	343	17	17	123	XP_003384600.1 PREDICTED: protein disulfide isomerase-like 2-1 [Amphimedon queenslandica]	diamond	645	115	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);;