metadata: contig_metadata: 5 rows where bioproject = "PRJNA897077" and tax

5 rows where bioproject = "PRJNA897077" 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
13627553	13627553	PRJNA897077_P_NODE_8591_length_335_cov_1.660305_g8464_i0	PRJNA897077	8591	335	1.660305	5.56202175	Dysidea avara	196820	Porifera	other_Eukaryota	56.5	0.002	NTclustered	gi\|2749567288\|ref\|XM_066050308.1\|	196820	g8464	i0	89.362	0.140298507462687	47	2	13	2	223	266	1314	1268	PREDICTED: Dysidea avara abl interactor 2-like (LOC136257233), mRNA	blastn	47	56.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
23825783	23825783	PRJNA897077_P_NODE_17979_length_246_cov_1.803468_g17852_i0	PRJNA897077	17979	246	1.803468	4.43653128	Halichondria panicea	6063	Porifera	other_Eukaryota	75	4.74e-9	NTclustered	gi\|2719018567\|ref\|XM_064542976.1\|	6063	g17852	i0	89.655	1.59349593495935	58	6	24	0	1	58	1470	1527	PREDICTED: Halichondria panicea lipid scramblase CLPTM1L-like (LOC135345559), mRNA	blastn	392	75	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27979417	27979417	PRJNA897077_P_NODE_16205_length_251_cov_0.876404_g16078_i0	PRJNA897077	16205	251	0.876404	2.19977404	Metazoa	33208	Porifera	other_Eukaryota	45.4	0.00382	NR	KAI6646006.1	111878	g16078	i0	42.3	3.58565737051793	52	27	58.6	1	248	102	50	101	KAI6646006.1 hypothetical protein LOD99_13259 [Oopsacas minuta]	diamond	900	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
30908921	30908921	PRJNA897077_P_NODE_11514_length_291_cov_1.646789_g11387_i0	PRJNA897077	11514	291	1.646789	4.79215599	Dysidea avara	196820	Porifera	other_Eukaryota	63.9	2.5e-9	NR	XP_065920668.1	196820	g11387	i0	38.7	1.93814432989691	93	50	88.7	4	10	267	1965	2057	XP_065920668.1 protocadherin Fat 4-like [Dysidea avara]	diamond	564	63.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32300708	32300708	PRJNA897077_P_NODE_19259_length_243_cov_1.194118_g19132_i0	PRJNA897077	19259	243	1.194118	2.90170674	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	77.4	1.45e-15	NR	XP_019862067.1	400682	g19132	i0	52.1	2.66666666666667	71	28	80.2	2	220	26	78	148	XP_019862067.1 PREDICTED: phosphomevalonate kinase-like, partial [Amphimedon queenslandica]	diamond	648	77.4	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);;