metadata: contig_metadata: 11 rows where bioproject = "PRJNA278119", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJNA278119", 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
1646269	1646269	PRJNA278119_P_NODE_45262_length_163_cov_0.912281_g45013_i0	PRJNA278119	45262	163	0.912281	1.48701803	Corticium candelabrum	121492	Porifera	other_Eukaryota	52.8	0.014	NTclustered	gi\|2664233241\|ref\|XM_062656470.1\|	121492	g45013	i0	96.875	0.196319018404908	32	0	19	1	46	76	1129	1098	PREDICTED: Corticium candelabrum uncharacterized LOC134188274 (LOC134188274), mRNA	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27217950	27217950	PRJNA278119_P_NODE_41182_length_165_cov_1.344828_g40933_i0	PRJNA278119	41182	165	1.344828	2.2189662	Opisthokonta	33154	Porifera	other_Eukaryota	84	2.89e-19	NR	CAK22277.1	289074	g40933	i0	81.6	8.83636363636364	49	9	89.1	0	6	152	61	109	CAK22277.1 citrate synthase, partial [Lubomirskia baikalensis]	diamond	1458	84	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Spongillida	Lubomirskiidae	Lubomirskia	Lubomirskia baikalensis
27674547	27674547	PRJNA278119_P_NODE_41624_length_165_cov_0.896552_g41375_i0	PRJNA278119	41624	165	0.896552	1.4793108	Halichondria panicea	6063	Porifera	other_Eukaryota	45.1	0.00195	NR	XP_064397026.1	6063	g41375	i0	35.2	0.981818181818182	54	33	98.2	1	3	164	253	304	XP_064397026.1 uncharacterized protein LOC135343926 [Halichondria panicea]	diamond	162	45.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
29000786	29000786	PRJNA278119_P_NODE_19548_length_227_cov_1.258427_g19299_i0	PRJNA278119	19548	227	1.258427	2.85662929	Oscarella lobularis	121494	Porifera	other_Eukaryota	86.7	9.01e-18	NR	XP_065846557.1	121494	g19299	i0	54.7	0.991189427312775	75	34	99.1	0	226	2	104	178	XP_065846557.1 neutral ceramidase A-like [Oscarella lobularis]	diamond	225	86.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29126985	29126985	PRJNA278119_P_NODE_28549_length_185_cov_1.529412_g28300_i0	PRJNA278119	28549	185	1.529412	2.8294122	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	45.4	0.00123	NR	XP_011410564.1	400682	g28300	i0	47.4	1.2972972972973	38	20	61.6	0	1	114	67	104	XP_011410564.1 PREDICTED: uncharacterized protein LOC105316943 [Amphimedon queenslandica]	diamond	240	45.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31134125	31134125	PRJNA278119_P_NODE_44075_length_164_cov_0.904348_g43826_i0	PRJNA278119	44075	164	0.904348	1.48313072	Metazoa	33208	Porifera	other_Eukaryota	53.5	1.98e-6	NR	XP_065919256.1	196820	g43826	i0	49.1	2.8719512195122	53	27	97	0	163	5	132	184	XP_065919256.1 uncharacterized protein [Dysidea avara]	diamond	471	53.9	0.992578849721707	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
31591248	31591248	PRJNA278119_P_NODE_12576_length_320_cov_1.151292_g12328_i0	PRJNA278119	12576	320	1.151292	3.6841344	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	161	2.37e-45	NR	NP_001266212.1	400682	g12328	i0	67.6	18.703125	105	34	98.4	0	318	4	227	331	NP_001266212.1 glycogen synthase kinase 3 [Amphimedon queenslandica]	diamond	5985	161	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31780734	31780734	PRJNA278119_P_NODE_6997_length_450_cov_1.773067_g6750_i0	PRJNA278119	6997	450	1.773067	7.9788015	Oscarella lobularis	121494	Porifera	other_Eukaryota	196	1.16e-61	NR	XP_065826293.1	121494	g6750	i0	73.8	7.81333333333333	130	34	86.7	0	440	51	1	130	XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis]	diamond	3516	196	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
32305069	32305069	PRJNA278119_P_NODE_17799_length_244_cov_1.210256_g17550_i0	PRJNA278119	17799	244	1.210256	2.95302464	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.1	1.26e-18	NR	XP_062521421.1	121492	g17550	i0	78	6.1844262295082	50	11	61.5	0	2	151	119	168	XP_062521421.1 actin-related protein 2/3 complex subunit 4 [Corticium candelabrum]	diamond	1509	85.5	0.9953216374269	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32508847	32508847	PRJNA278119_P_NODE_38399_length_167_cov_0.881356_g38150_i0	PRJNA278119	38399	167	0.881356	1.47186452	Geodia barretti	519541	Porifera	other_Eukaryota	61.2	1.17e-9	NR	CAI8043566.1	519541	g38150	i0	62.3	1.90419161676647	53	12	95.2	2	165	7	97	141	CAI8043566.1 Cysteine proteinase 1 [Geodia barretti]	diamond	318	61.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
32823767	32823767	PRJNA278119_P_NODE_9500_length_381_cov_1.210843_g9253_i0	PRJNA278119	9500	381	1.210843	4.61331183	Halichondria panicea	6063	Porifera	other_Eukaryota	44.7	0.032	NR	XP_064395231.1	6063	g9253	i0	36.7	1.00787401574803	128	63	92.1	7	28	378	167	287	XP_064395231.1 uncharacterized protein LOC135342432 [Halichondria panicea]	diamond	384	44.7	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);;