metadata: contig_metadata: 11 rows where bioproject = "PRJEB81327", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJEB81327", tax_clade = "Opisthokonta" 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
15442100	15442100	PRJEB81327_P_NODE_17693_length_321_cov_1.862903_g17085_i0	PRJEB81327	17693	321	1.862903	5.97991863	Metazoa	33208	Porifera	other_Eukaryota	214	4.499999999999999e-67	NR	AZI95717.1	6063	g17085	i0	99.1	57.4579439252336	106	1	99.1	0	2	319	75	180	AZI95717.1 26S proteasome non-ATPase regulatory subunit 14, partial [Halichondria panicea]	diamond	18444	215	0.995348837209302	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
17991538	17991538	PRJEB81327_P_NODE_48255_length_250_cov_0.870056_g47647_i0	PRJEB81327	48255	250	0.870056	2.17514	Opisthokonta	33154	Porifera	other_Eukaryota	111	2.3e-26	NR	XP_065883503.1	196820	g47647	i0	70	17.16	80	22	96	1	248	9	750	827	XP_065883503.1 DNA-directed RNA polymerase II subunit RPB2 [Dysidea avara]	diamond	4290	111	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
20540587	20540587	PRJEB81327_P_NODE_20317_length_308_cov_1.965957_g19709_i0	PRJEB81327	20317	308	1.965957	6.05514756	Sycon ciliatum	27933	Porifera	other_Eukaryota	124	6.49e-34	NR	CCQ18628.1	27933	g19709	i0	56.4	2.89285714285714	101	44	98.4	0	2	304	34	134	CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum]	diamond	891	124	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
21816813	21816813	PRJEB81327_P_NODE_5478_length_619_cov_1.408425_g4899_i0	PRJEB81327	5478	619	1.408425	8.71815075	Metazoa	33208	Porifera	other_Eukaryota	228	1.58e-72	NR	CAI8032315.1	519541	g4899	i0	60.2	16.0177705977383	206	62	99.8	2	619	2	9	194	CAI8032315.1 40S ribosomal protein S8 [Geodia barretti]	diamond	9915	228	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
26868944	26868944	PRJEB81327_P_NODE_47081_length_251_cov_0.865169_g46473_i0	PRJEB81327	47081	251	0.865169	2.17157419	Metazoa	33208	Porifera	other_Eukaryota	91.3	4.33e-20	NR	XP_003382782.1	400682	g46473	i0	70.9	1.99601593625498	55	16	65.7	0	167	3	38	92	XP_003382782.1 PREDICTED: 40S ribosomal protein S2 [Amphimedon queenslandica]	diamond	501	92	0.992391304347826	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
28013618	28013618	PRJEB81327_P_NODE_3365_length_827_cov_2.124668_g2850_i0	PRJEB81327	3365	827	2.124668	17.57100436	Geodia barretti	519541	Porifera	other_Eukaryota	148	1.91e-40	NR	CAI8030757.1	519541	g2850	i0	51.8	0.60217654171705	166	65	57.7	6	291	767	18	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	498	148	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
28297516	28297516	PRJEB81327_P_NODE_25106_length_287_cov_1.799065_g24498_i0	PRJEB81327	25106	287	1.799065	5.16331655	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	138	5.03e-38	NR	XP_003384812.1	400682	g24498	i0	65.6	0.940766550522648	90	30	93	1	1	267	163	252	XP_003384812.1 PREDICTED: S-formylglutathione hydrolase-like [Amphimedon queenslandica]	diamond	270	138	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
28606043	28606043	PRJEB81327_P_NODE_25747_length_286_cov_1.446009_g25139_i0	PRJEB81327	25747	286	1.446009	4.13558574	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.7	0.00849	NR	XP_065174881.1	27933	g25139	i0	35	3.56643356643357	80	51	83.9	1	259	20	82	160	XP_065174881.1 clathrin light chain A-like [Sycon ciliatum]	diamond	1020	44.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29710769	29710769	PRJEB81327_P_NODE_54530_length_247_cov_0.885057_g53922_i0	PRJEB81327	54530	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	59.3	4.86e-8	NR	XP_062506616.1	121492	g53922	i0	46.7	3.03643724696356	60	31	72.9	1	55	234	113	171	XP_062506616.1 hepatic lectin-like [Corticium candelabrum]	diamond	750	59.7	0.993299832495812	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31891841	31891841	PRJEB81327_P_NODE_38337_length_264_cov_1.408377_g37729_i0	PRJEB81327	38337	264	1.408377	3.71811528	Porifera	6040	Porifera	other_Eukaryota	105	2.85e-26	NR	CAI8014519.1	519541	g37729	i0	60.2	3.92045454545455	88	35	100	0	1	264	97	184	CAI8014519.1 60S ribosomal protein L13a [Geodia barretti]	diamond	1035	105	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
31962409	31962409	PRJEB81327_P_NODE_55958_length_246_cov_0.890173_g55350_i0	PRJEB81327	55958	246	0.890173	2.18982558	Halichondria panicea	6063	Porifera	other_Eukaryota	55.5	1.24e-6	NR	XP_064399935.1	6063	g55350	i0	39	3.68292682926829	77	45	92.7	2	242	15	292	367	XP_064399935.1 uncharacterized protein LOC135346290 [Halichondria panicea]	diamond	906	55.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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