metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax

19 rows where analysis = "diamond", bioproject = "PRJEB43370" 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
9918125	9918125	PRJEB43370_P_NODE_9188_length_165_cov_1.793103_g9145_i0	PRJEB43370	9188	165	1.793103	2.95861995	root	1	Root_unresolved	Root_unresolved	104	2.5e-27	NR	XP_064389397.1	6063	g9145	i0	92.5	19.3090909090909	53	4	96.4	0	160	2	43	95	XP_064389397.1 small ribosomal subunit protein eS27 [Halichondria panicea]	diamond	3186	105	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
23942256	23942256	PRJEB43370_P_NODE_7319_length_169_cov_2.141667_g7276_i0	PRJEB43370	7319	169	2.141667	3.61941723	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	95.9	5.38e-23	NR	XP_003386009.1	400682	g7276	i0	82.1	2.98224852071006	56	10	99.4	0	1	168	42	97	XP_003386009.1 PREDICTED: 60S ribosomal protein L19-like [Amphimedon queenslandica]	diamond	504	95.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
26780387	26780387	PRJEB43370_P_NODE_6301_length_183_cov_1.164179_g6258_i0	PRJEB43370	6301	183	1.164179	2.13044757	Dysidea avara	196820	Porifera	other_Eukaryota	55.8	2.38e-7	NR	XP_065897222.1	196820	g6258	i0	63.8	2.86885245901639	58	19	93.4	2	11	181	100	156	XP_065897222.1 elongation factor 1-beta-like isoform X2 [Dysidea avara]	diamond	525	55.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
26843789	26843789	PRJEB43370_P_NODE_9661_length_164_cov_1.739130_g9618_i0	PRJEB43370	9661	164	1.73913	2.8521732	Sycon ciliatum	27933	Porifera	other_Eukaryota	62	8.46e-10	NR	XP_065189662.1	27933	g9618	i0	71.4	2.43292682926829	49	9	89.6	1	18	164	59	102	XP_065189662.1 LOW QUALITY PROTEIN: large ribosomal subunit protein eL8-like [Sycon ciliatum]	diamond	399	62	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27437893	27437893	PRJEB43370_P_NODE_6923_length_174_cov_1.664000_g6880_i0	PRJEB43370	6923	174	1.664	2.89536	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.8	2.09e-9	NR	XP_064401183.1	6063	g6880	i0	53.4	5.55172413793103	58	25	96.6	1	170	3	4	61	XP_064401183.1 uncharacterized protein LOC135347230 [Halichondria panicea]	diamond	966	60.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27633863	27633863	PRJEB43370_P_NODE_6924_length_174_cov_1.664000_g6881_i0	PRJEB43370	6924	174	1.664	2.89536	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	68.6	4.04e-13	NR	XP_003387445.1	400682	g6881	i0	56.1	3.93103448275862	57	25	98.3	0	173	3	7	63	XP_003387445.1 PREDICTED: 60S acidic ribosomal protein P1-like [Amphimedon queenslandica]	diamond	684	68.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
28801773	28801773	PRJEB43370_P_NODE_1688_length_338_cov_1.297578_g1645_i0	PRJEB43370	1688	338	1.297578	4.38581364	Geodia barretti	519541	Porifera	other_Eukaryota	78.2	2.64e-15	NR	CAI8030757.1	519541	g1645	i0	53.8	0.692307692307692	78	30	67.5	2	338	111	102	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	234	78.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
29496607	29496607	PRJEB43370_P_NODE_10230_length_163_cov_0.912281_g10187_i0	PRJEB43370	10230	163	0.912281	1.48701803	Dysidea avara	196820	Porifera	other_Eukaryota	72.4	2.26e-13	NR	XP_065891405.1	196820	g10187	i0	71.2	0.957055214723926	52	15	95.7	0	156	1	17	68	XP_065891405.1 large ribosomal subunit protein uL15-like [Dysidea avara]	diamond	156	72.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
29900568	29900568	PRJEB43370_P_NODE_4211_length_217_cov_1.148810_g4168_i0	PRJEB43370	4211	217	1.14881	2.4929177	Metazoa	33208	Porifera	other_Eukaryota	51.6	2.03e-5	NR	XP_065912710.1	196820	g4168	i0	42	2.23963133640553	50	29	69.1	0	165	16	423	472	XP_065912710.1 uncharacterized protein [Dysidea avara]	diamond	486	51.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
30785069	30785069	PRJEB43370_P_NODE_6894_length_175_cov_0.833333_g6851_i0	PRJEB43370	6894	175	0.833333	1.45833275	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.5	1.27e-17	NR	XP_062508220.1	121492	g6851	i0	87.8	2.81142857142857	41	5	70.3	0	174	52	90	130	XP_062508220.1 small ribosomal subunit protein uS8 [Corticium candelabrum]	diamond	492	81.3	0.990159901599016	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31645166	31645166	PRJEB43370_P_NODE_6537_length_179_cov_2.000000_g6494_i0	PRJEB43370	6537	179	2	3.58	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	49.3	7.67e-5	NR	XP_003383128.1	400682	g6494	i0	44.1	3.95530726256983	59	30	93.9	1	178	11	244	302	XP_003383128.1 PREDICTED: ATP-binding cassette sub-family F member 2 [Amphimedon queenslandica]	diamond	708	49.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31708553	31708553	PRJEB43370_P_NODE_5097_length_200_cov_1.377483_g5054_i0	PRJEB43370	5097	200	1.377483	2.754966	Sycon ciliatum	27933	Porifera	other_Eukaryota	93.6	1.85e-22	NR	XP_065193366.1	27933	g5054	i0	74.2	0.93	62	16	93	0	198	13	49	110	XP_065193366.1 small ribosomal subunit protein eS19-like [Sycon ciliatum]	diamond	186	93.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31765104	31765104	PRJEB43370_P_NODE_6377_length_182_cov_1.172932_g6334_i0	PRJEB43370	6377	182	1.172932	2.13473624	Metazoa	33208	Porifera	other_Eukaryota	49.7	5.82e-5	NR	XP_064389784.1	6063	g6334	i0	52.3	2.85164835164835	44	21	72.5	0	134	3	1	44	XP_064389784.1 calcium/calmodulin-dependent protein kinase type II-like [Halichondria panicea]	diamond	519	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31859908	31859908	PRJEB43370_P_NODE_9457_length_165_cov_0.896552_g9414_i0	PRJEB43370	9457	165	0.896552	1.4793108	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	83.2	5.35e-18	NR	XP_019853295.1	400682	g9414	i0	75.9	18.6545454545455	54	13	98.2	0	164	3	86	139	XP_019853295.1 PREDICTED: 40S ribosomal protein S5 [Amphimedon queenslandica]	diamond	3078	84	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
32214883	32214883	PRJEB43370_P_NODE_9578_length_165_cov_0.896552_g9535_i0	PRJEB43370	9578	165	0.896552	1.4793108	Sycon ciliatum	27933	Porifera	other_Eukaryota	64.7	2.27e-10	NR	XP_065176847.1	27933	g9535	i0	60.4	0.963636363636364	53	20	96.4	1	164	6	438	489	XP_065176847.1 major vault protein-like [Sycon ciliatum]	diamond	159	64.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32366500	32366500	PRJEB43370_P_NODE_2279_length_286_cov_1.755274_g2236_i0	PRJEB43370	2279	286	1.755274	5.02008364	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	106	3.01e-24	NR	XP_065830064.1	121494	g2236	i0	68.1	2.4020979020979	72	21	75.5	1	219	4	399	468	XP_065830064.1 protein DD3-3-like [Oscarella lobularis]	diamond	687	107	0.990654205607477	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
32524860	32524860	PRJEB43370_P_NODE_5539_length_193_cov_1.340278_g5496_i0	PRJEB43370	5539	193	1.340278	2.58673654	Demospongiae	6042	Porifera	other_Eukaryota	85.9	5.72e-19	NR	AFJ64431.1	178514	g5496	i0	66.1	3.83937823834197	62	21	96.4	0	3	188	46	107	AFJ64431.1 aldolase, partial [Amphimedon compressa]	diamond	741	85.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon compressa
32531362	32531362	PRJEB43370_P_NODE_4279_length_215_cov_3.114458_g4236_i0	PRJEB43370	4279	215	3.114458	6.6960847	Oscarella lobularis	121494	Porifera	other_Eukaryota	81.6	5e-16	NR	XP_065845201.1	121494	g4236	i0	57.7	1.98139534883721	71	30	99.1	0	2	214	419	489	XP_065845201.1 annexin-B12-like [Oscarella lobularis]	diamond	426	81.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
32556481	32556481	PRJEB43370_P_NODE_10639_length_162_cov_0.920354_g10596_i0	PRJEB43370	10639	162	0.920354	1.49097348	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.9	2.65e-13	NR	XP_065187238.1	27933	g10596	i0	75	16.462962962963	48	12	88.9	0	151	8	50	97	XP_065187238.1 nascent polypeptide-associated complex subunit alpha-like [Sycon ciliatum]	diamond	2667	70.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum

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