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

14 rows where bioproject = "PRJNA312615", 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
11856945	11856945	PRJNA312615_P_NODE_37630_length_200_cov_1.350993_g37479_i0	PRJNA312615	37630	200	1.350993	2.701986	Sycon ciliatum	27933	Porifera	other_Eukaryota	78.7	2.87e-10	NTclustered	gi\|2732935980\|ref\|XM_065335116.1\|	27933	g37479	i0	86.957	4.68	69	9	35	0	5	73	511	579	PREDICTED: Sycon ciliatum actin-related protein 2/3 complex subunit 4-like (LOC135822367), mRNA	blastn	936	78.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
26725675	26725675	PRJNA312615_P_NODE_40741_length_192_cov_1.195804_g40590_i0	PRJNA312615	40741	192	1.195804	2.29594368	Oscarella lobularis	121494	Porifera	other_Eukaryota	54.3	8.64e-7	NR	XP_065846705.1	121494	g40590	i0	51	2.46875	51	25	79.7	0	189	37	1	51	XP_065846705.1 ras-related protein Rab-7L1-like [Oscarella lobularis]	diamond	474	54.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27074238	27074238	PRJNA312615_P_NODE_40422_length_193_cov_1.062500_g40271_i0	PRJNA312615	40422	193	1.0625	2.050625	Dysidea avara	196820	Porifera	other_Eukaryota	55.8	4.11e-7	NR	XP_065886883.1	196820	g40271	i0	49	0.792746113989637	51	26	79.3	0	156	4	6	56	XP_065886883.1 ribosome production factor 2 homolog [Dysidea avara]	diamond	153	55.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27376613	27376613	PRJNA312615_P_NODE_19103_length_279_cov_1.304348_g18952_i0	PRJNA312615	19103	279	1.304348	3.63913092	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	4.65e-5	NR	XP_064401183.1	6063	g18952	i0	39.8	1.80645161290323	83	47	87.1	2	264	22	4	85	XP_064401183.1 uncharacterized protein LOC135347230 [Halichondria panicea]	diamond	504	51.2	0.9921875	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27737978	27737978	PRJNA312615_P_NODE_13704_length_332_cov_2.614841_g13553_i0	PRJNA312615	13704	332	2.614841	8.68127212	Halichondria panicea	6063	Porifera	other_Eukaryota	44.3	0.0256	NR	XP_064387443.1	6063	g13553	i0	47.7	0.397590361445783	44	22	38.9	1	16	144	1	44	XP_064387443.1 voltage-dependent anion-selective channel protein 2-like [Halichondria panicea]	diamond	132	44.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27737979	27737979	PRJNA312615_P_NODE_17584_length_292_cov_1.045267_g17433_i0	PRJNA312615	17584	292	1.045267	3.05217964	Halichondria panicea	6063	Porifera	other_Eukaryota	121	7.349999999999999e-31	NR	XP_064392077.1	6063	g17433	i0	55.7	1.99315068493151	97	42	99.7	1	2	292	67	162	XP_064392077.1 serine dehydratase-like [Halichondria panicea]	diamond	582	121	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28021974	28021974	PRJNA312615_P_NODE_11805_length_360_cov_1.035370_g11655_i0	PRJNA312615	11805	360	1.03537	3.727332	Geodia barretti	519541	Porifera	other_Eukaryota	95.5	1.0100000000000002e-21	NR	CAI8029397.1	519541	g11655	i0	50	0.85	102	42	80.8	4	46	336	95	192	CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti]	diamond	306	95.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
28544776	28544776	PRJNA312615_P_NODE_37987_length_199_cov_1.360000_g37836_i0	PRJNA312615	37987	199	1.36	2.7064	Metazoa	33208	Porifera	other_Eukaryota	70.1	2.98e-12	NR	XP_065908787.1	196820	g37836	i0	64	4.68844221105528	50	18	75.4	0	18	167	205	254	XP_065908787.1 protein adenylyltransferase FICD-like [Dysidea avara]	diamond	933	70.5	0.994326241134752	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28937568	28937568	PRJNA312615_P_NODE_1588_length_836_cov_66.712834_g1474_i0	PRJNA312615	1588	836	66.712834	557.71929224	Geodia barretti	519541	Porifera	other_Eukaryota	148	2.08e-40	NR	CAI8030757.1	519541	g1474	i0	51.8	0.595693779904306	166	65	57.1	6	293	769	18	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	498	148	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
29081385	29081385	PRJNA312615_P_NODE_27268_length_234_cov_1.410811_g27117_i0	PRJNA312615	27268	234	1.410811	3.30129774	Opisthokonta	33154	Porifera	other_Eukaryota	108	9.3e-26	NR	XP_065827415.1	121494	g27117	i0	70.1	3.87179487179487	77	23	98.7	0	3	233	248	324	XP_065827415.1 cysteine desulfurase-like [Oscarella lobularis]	diamond	906	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30295861	30295861	PRJNA312615_P_NODE_35232_length_207_cov_0.829114_g35081_i0	PRJNA312615	35232	207	0.829114	1.71626598	Sycon ciliatum	27933	Porifera	other_Eukaryota	61.2	7e-9	NR	XP_065176077.1	27933	g35081	i0	44.6	0.942028985507246	65	36	94.2	0	3	197	1904	1968	XP_065176077.1 uncharacterized protein LOC135805886 [Sycon ciliatum]	diamond	195	61.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
30895899	30895899	PRJNA312615_P_NODE_24554_length_247_cov_0.828283_g24403_i0	PRJNA312615	24554	247	0.828283	2.04585901	Halisarca dujardinii	2583056	Porifera	other_Eukaryota	60.1	3.06e-8	NR	WAW84834.1	2583056	g24403	i0	53.4	1.4331983805668	58	24	70.4	1	185	12	4555	4609	WAW84834.1 axonemal dynein heavy chain A [Halisarca dujardinii]	diamond	354	60.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Chondrillida	Halisarcidae	Halisarca	Halisarca dujardinii
31591441	31591441	PRJNA312615_P_NODE_24936_length_245_cov_1.040816_g24785_i0	PRJNA312615	24936	245	1.040816	2.5499992	Halichondria panicea	6063	Porifera	other_Eukaryota	75.5	1.5e-14	NR	XP_064406312.1	6063	g24785	i0	47.6	2.02040816326531	82	40	98	2	4	243	98	178	XP_064406312.1 ERI1 exoribonuclease 3-like [Halichondria panicea]	diamond	495	75.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32034189	32034189	PRJNA312615_P_NODE_9038_length_410_cov_3.177285_g8888_i0	PRJNA312615	9038	410	3.177285	13.0268685	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	74.3	1.25e-12	NR	XP_003389037.1	400682	g8888	i0	36.8	3.21219512195122	106	63	75.4	2	102	410	18	122	XP_003389037.1 PREDICTED: cathepsin L1-like [Amphimedon queenslandica]	diamond	1317	74.3	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);;