metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
2980599	2980599	PRJNA432257_S_NODE_61083_length_214_cov_54.197740_g60702_i0	PRJNA432257	61083	214	54.19774	115.9831636	Sycon ciliatum	27933	Porifera	other_Eukaryota	62.1	3.13e-5	NTclustered	gi\|2732912601\|ref\|XM_065323090.1\|	27933	g60702	i0	92.857	0.588785046728972	42	3	20	0	119	160	3238	3279	PREDICTED: Sycon ciliatum oxysterol-binding protein-related protein 1-like (LOC135809683), transcript variant X2, mRNA	blastn	126	62.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
9357472	9357472	PRJNA432257_S_NODE_19628_length_324_cov_4.034843_g19247_i0	PRJNA432257	19628	324	4.034843	13.07289132	Sycon ciliatum	27933	Porifera	other_Eukaryota	121	8.229999999999999e-23	NTclustered	gi\|457867034\|emb\|HF570311.1\|	27933	g19247	i0	86.916	2.32407407407407	107	14	33	0	10	116	240	346	Sycon ciliatum mRNA for 40S ribosomal protein S2 (rps12 gene)	blastn	753	121	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
11292011	11292011	PRJNA432257_S_NODE_68449_length_205_cov_4.601190_g68068_i0	PRJNA432257	68449	205	4.60119	9.4324395	Haplosclerida	6049	Porifera	other_Eukaryota	108	3.77e-19	NTclustered	gi\|1284883228\|gb\|KY825184.1\|	178514	g68068	i0	81.159	11.5707317073171	138	22	67	3	42	178	3474	3340	Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence	blastn	2372	108	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon compressa
19555864	19555864	PRJNA432257_S_NODE_64536_length_210_cov_2.231214_g64155_i0	PRJNA432257	64536	210	2.231214	4.6855494	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	56.5	0.001	NTclustered	gi\|1133469280\|ref\|XM_003388166.2\|	400682	g64155	i0	97.059	0.323809523809524	34	0	16	1	138	171	2891	2859	PREDICTED: Amphimedon queenslandica transmembrane and TPR repeat-containing protein 3-like (LOC100638097), mRNA	blastn	68	56.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
24655392	24655392	PRJNA432257_S_NODE_111220_length_165_cov_1.781250_g110839_i0	PRJNA432257	111220	165	1.78125	2.9390625	Oscarella lobularis	121494	Porifera	other_Eukaryota	58.4	2.97e-4	NTclustered	gi\|2746758154\|ref\|XM_065983063.1\|	121494	g110839	i0	97.059	0.412121212121212	34	1	21	0	132	165	561	594	PREDICTED: Oscarella lobularis DAZ-associated protein 2-like (LOC136194043), mRNA	blastn	68	58.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis

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