metadata: contig_metadata: 7 rows where bioproject = "PRJNA1041773", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA1041773", 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
5273100	5273100	PRJNA1041773_P_NODE_40805_length_332_cov_1.111969_g40472_i0	PRJNA1041773	40805	332	1.111969	3.69173708	Dysidea avara	196820	Porifera	other_Eukaryota	52.8	0.031	NTclustered	gi\|2749518223\|ref\|XM_066028238.1\|	196820	g40472	i0	100	0.168674698795181	28	0	8	0	27	54	6266	6239	PREDICTED: Dysidea avara arf-GAP with Rho-GAP domain, ANK repeat and PH domain-containing protein 2-like (LOC136237953), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27414743	27414743	PRJNA1041773_P_NODE_89903_length_246_cov_0.890173_g89570_i0	PRJNA1041773	89903	246	0.890173	2.18982558	Oopsacas minuta	111878	Porifera	other_Eukaryota	50.1	1.03e-4	NR	KAI6652584.1	111878	g89570	i0	80	0.365853658536585	30	6	36.6	0	246	157	579	608	KAI6652584.1 hypothetical protein LOD99_4369 [Oopsacas minuta]	diamond	90	50.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
27825078	27825078	PRJNA1041773_P_NODE_95704_length_243_cov_0.905882_g95371_i0	PRJNA1041773	95704	243	0.905882	2.20129326	Oopsacas minuta	111878	Porifera	other_Eukaryota	42	0.0151	NR	KAI6653134.1	111878	g95371	i0	56.7	0.37037037037037	30	13	37	0	203	114	57	86	KAI6653134.1 hypothetical protein LOD99_3970 [Oopsacas minuta]	diamond	90	42	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
27951274	27951274	PRJNA1041773_P_NODE_100625_length_241_cov_0.916667_g100292_i0	PRJNA1041773	100625	241	0.916667	2.20916747	Halichondria panicea	6063	Porifera	other_Eukaryota	60.1	2.59e-8	NR	XP_064382682.1	6063	g100292	i0	46.4	10.4315352697095	84	37	99.6	5	2	241	23	102	XP_064382682.1 scavenger receptor cysteine-rich type 1 protein M130-like [Halichondria panicea]	diamond	2514	60.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28393263	28393263	PRJNA1041773_P_NODE_96026_length_243_cov_0.905882_g95693_i0	PRJNA1041773	96026	243	0.905882	2.20129326	Oopsacas minuta	111878	Porifera	other_Eukaryota	45.8	0.00231	NR	KAI6658155.1	111878	g95693	i0	38.3	0.740740740740741	60	37	74.1	0	180	1	81	140	KAI6658155.1 Histone-lysine N-methyltransferase SETMAR-like [Oopsacas minuta]	diamond	180	45.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
29017061	29017061	PRJNA1041773_P_NODE_100968_length_241_cov_0.916667_g100635_i0	PRJNA1041773	100968	241	0.916667	2.20916747	Metazoa	33208	Porifera	other_Eukaryota	50.1	3.36e-5	NR	KAI6657783.1	111878	g100635	i0	55.9	3.46058091286307	34	15	42.3	0	78	179	120	153	KAI6657783.1 Transposase [Oopsacas minuta]	diamond	834	50.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
30129676	30129676	PRJNA1041773_P_NODE_83012_length_249_cov_0.875000_g82679_i0	PRJNA1041773	83012	249	0.875	2.17875	Oopsacas minuta	111878	Porifera	other_Eukaryota	52.4	1.57e-5	NR	KAI6655315.1	111878	g82679	i0	38.7	2.24096385542169	62	38	74.7	0	62	247	333	394	KAI6655315.1 hypothetical protein LOD99_2150 [Oopsacas minuta]	diamond	558	52.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta

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