metadata: contig_metadata: 14 rows where bioproject = "PRJNA274362", tax_kingdom = "Metazoa" and tax

14 rows where bioproject = "PRJNA274362", 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
1645724	1645724	PRJNA274362_S_NODE_8122_length_301_cov_0.916667_g8002_i0	PRJNA274362	8122	301	0.916667	2.75916767	Sycon ciliatum	27933	Porifera	other_Eukaryota	87.4	1.52e-17	NR	XP_065192285.1	27933	g8002	i0	45.9	2.90033222591362	98	50	97.7	2	300	7	496	590	XP_065192285.1 uncharacterized protein LOC135823360 [Sycon ciliatum]	diamond	873	87.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
8023957	8023957	PRJNA274362_S_NODE_25287_length_187_cov_1.594203_g25167_i0	PRJNA274362	25287	187	1.594203	2.98115961	root	1	Root_unresolved	Root_unresolved	113	1.47e-30	NR	XP_065837093.1	121494	g25167	i0	83.9	36.8021390374332	62	10	99.5	0	2	187	9	70	XP_065837093.1 small ribosomal subunit protein eS17-like [Oscarella lobularis]	diamond	6882	114	0.991228070175439	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
9298570	9298570	PRJNA274362_S_NODE_21368_length_201_cov_0.986842_g21248_i0	PRJNA274362	21368	201	0.986842	1.98355242	Halichondria panicea	6063	Porifera	other_Eukaryota	91.6	3.7e-14	NTclustered	gi\|1830622841\|gb\|MN339468.1\|	6063	g21248	i0	85.556	0.895522388059702	90	9	44	4	6	93	212	125	Halichondria panicea ferritin heavy chain (FTH1) mRNA, complete cds	blastn	180	91.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
11849326	11849326	PRJNA274362_S_NODE_30390_length_173_cov_0.838710_g30270_i0	PRJNA274362	30390	173	0.83871	1.4509683	Dysidea avara	196820	Porifera	other_Eukaryota	152	1.3899999999999998e-32	NTclustered	gi\|2749550226\|ref\|XM_066042492.1\|	196820	g30270	i0	84.049	69.4566473988439	163	20	92	6	14	173	88	247	PREDICTED: Dysidea avara actin, cytoplasmic (LOC136250303), mRNA	blastn	12016	152	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
16948217	16948217	PRJNA274362_S_NODE_36934_length_163_cov_0.885965_g36814_i0	PRJNA274362	36934	163	0.885965	1.44412295	Metazoa	33208	Porifera	other_Eukaryota	68.9	7.93e-14	NR	CCQ18671.1	27933	g36814	i0	72.3	13.7300613496933	47	13	86.5	0	6	146	23	69	CCQ18671.1 60S ribosomal protein L38 [Sycon ciliatum]	diamond	2238	68.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
19496781	19496781	PRJNA274362_S_NODE_36636_length_163_cov_0.912281_g36516_i0	PRJNA274362	36636	163	0.912281	1.48701803	Metazoa	33208	Porifera	other_Eukaryota	89	6.05e-19	NR	KAI6645686.1	111878	g36516	i0	74.1	9.0920245398773	54	14	99.4	0	2	163	327	380	KAI6645686.1 Serine--tRNA ligase, cytoplasmic [Oopsacas minuta]	diamond	1482	89.7	0.992196209587514	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
26662240	26662240	PRJNA274362_S_NODE_27681_length_180_cov_1.190840_g27561_i0	PRJNA274362	27681	180	1.19084	2.143512	Dysidea avara	196820	Porifera	other_Eukaryota	54.3	1.25e-6	NR	XP_065892974.1	196820	g27561	i0	43.9	0.95	57	32	95	0	179	9	16	72	XP_065892974.1 uncharacterized protein [Dysidea avara]	diamond	171	54.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28418429	28418429	PRJNA274362_S_NODE_4906_length_377_cov_1.176829_g4786_i0	PRJNA274362	4906	377	1.176829	4.43664533	root	1	Root_unresolved	Root_unresolved	191	6.729999999999999e-60	NR	XP_065829718.1	121494	g4786	i0	77.8	7.55172413793103	117	26	93.1	0	27	377	6	122	XP_065829718.1 small ribosomal subunit protein uS9-like [Oscarella lobularis]	diamond	2847	191	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29316134	29316134	PRJNA274362_S_NODE_30389_length_173_cov_0.838710_g30269_i0	PRJNA274362	30389	173	0.83871	1.4509683	Halichondria panicea	6063	Porifera	other_Eukaryota	84.3	8.84e-19	NR	XP_064390491.1	6063	g30269	i0	71.4	1.94219653179191	56	16	97.1	0	2	169	35	90	XP_064390491.1 LOW QUALITY PROTEIN: large ribosomal subunit protein uL22-like [Halichondria panicea]	diamond	336	84.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
29649207	29649207	PRJNA274362_S_NODE_17250_length_219_cov_1.029412_g17130_i0	PRJNA274362	17250	219	1.029412	2.25441228	Demospongiae	6042	Porifera	other_Eukaryota	108	5.02e-28	NR	XP_064384635.1	6063	g17130	i0	80.3	4.9041095890411	71	14	97.3	0	218	6	47	117	XP_064384635.1 large ribosomal subunit protein uL11-like [Halichondria panicea]	diamond	1074	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30011027	30011027	PRJNA274362_S_NODE_24491_length_190_cov_1.106383_g24371_i0	PRJNA274362	24491	190	1.106383	2.1021277	Aplysina fistularis	202113	Porifera	other_Eukaryota	109	1.5200000000000002e-27	NR	AAO12215.1	202113	g24371	i0	84.1	0.994736842105263	63	10	99.5	0	2	190	150	212	AAO12215.1 trypsin, partial [Aplysina fistularis]	diamond	189	109	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Verongiida	Aplysinidae	Aplysina	Aplysina fistularis
31577259	31577259	PRJNA274362_S_NODE_7436_length_313_cov_1.893939_g7316_i0	PRJNA274362	7436	313	1.893939	5.92802907	Metazoa	33208	Porifera	other_Eukaryota	130	1.29e-36	NR	XP_065189697.1	27933	g7316	i0	61.2	10.5239616613419	103	40	98.7	0	1	309	32	134	XP_065189697.1 small ribosomal subunit protein eS17-like [Sycon ciliatum]	diamond	3294	130	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32319014	32319014	PRJNA274362_S_NODE_35079_length_165_cov_0.896552_g34959_i0	PRJNA274362	35079	165	0.896552	1.4793108	Corticium candelabrum	121492	Porifera	other_Eukaryota	74.7	2.53e-14	NR	XP_062510329.1	121492	g34959	i0	77.3	3.29090909090909	44	10	80	0	165	34	214	257	XP_062510329.1 small ribosomal subunit protein eS4-like [Corticium candelabrum]	diamond	543	74.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32336627	32336627	PRJNA274362_S_NODE_17399_length_218_cov_1.230769_g17279_i0	PRJNA274362	17399	218	1.230769	2.68307642	Metazoa	33208	Porifera	other_Eukaryota	118	5.759999999999998e-32	NR	XP_064384635.1	6063	g17279	i0	83.1	20.6284403669725	65	11	89.4	0	23	217	1	65	XP_064384635.1 large ribosomal subunit protein uL11-like [Halichondria panicea]	diamond	4497	119	0.991596638655462	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);;