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

5 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
7221769	7221769	PRJNA857143_S_NODE_178286_length_249_cov_0.954545_g177193_i0	PRJNA857143	178286	249	0.954545	2.37681705	Sycon ciliatum	27933	Porifera	other_Eukaryota	52.8	0.023	NTclustered	gi\|2732936170\|ref\|XM_065335211.1\|	27933	g177193	i0	100	0.112449799196787	28	0	11	0	27	54	3427	3400	PREDICTED: Sycon ciliatum integrator complex subunit 5-like (LOC135822443), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
11047748	11047748	PRJNA857143_S_NODE_4629_length_894_cov_2.042631_g3910_i0	PRJNA857143	4629	894	2.042631	18.26112114	Haliclona sp. BKON-2565	3127636	Porifera	other_Eukaryota	207	1.82e-48	NTclustered	gi\|2899163455\|gb\|PP464275.1\|	3127636	g3910	i0	77.808	27.244966442953	365	62	40	12	60	414	2190	1835	Haliclona sp. BKON-2565 isolate H2565 mitochondrion, complete genome	blastn	24357	207	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona sp. BKON-2565
13597364	13597364	PRJNA857143_S_NODE_17871_length_551_cov_22.717573_g16800_i0	PRJNA857143	17871	551	22.717573	125.17382723	Sycon ciliatum	27933	Porifera	other_Eukaryota	316	1.74e-81	NTclustered	gi\|457866940\|emb\|HF570264.1\|	27933	g16800	i0	82.73	35.3266787658802	359	58	65	4	115	471	62	418	Sycon ciliatum mRNA for 40S ribosomal protein S23 (rps23 gene)	blastn	19465	316	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
14872349	14872349	PRJNA857143_S_NODE_75632_length_345_cov_2.580882_g74539_i0	PRJNA857143	75632	345	2.580882	8.9040429	Tethya sp. XMU02001079	1848167	Porifera	other_Eukaryota	147	1.46e-30	NTclustered	gi\|1027889113\|gb\|KU748128.1\|	1848167	g74539	i0	82.022	45.8608695652174	178	27	51	5	44	219	2447	2273	Tethya sp. XMU02001079 mitochondrion, complete genome	blastn	15822	147	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tethyida	Tethyidae	Tethya	Tethya sp. XMU02001079
21246264	21246264	PRJNA857143_S_NODE_51317_length_392_cov_44.495298_g50224_i0	PRJNA857143	51317	392	44.495298	174.42156816	Corticium candelabrum	121492	Porifera	other_Eukaryota	185	3.54e-42	NTclustered	gi\|2664247974\|ref\|XM_062664137.1\|	121492	g50224	i0	89.726	34.9617346938776	146	13	37	2	1	145	1265	1409	PREDICTED: Corticium candelabrum tubulin beta chain-like (LOC134195127), mRNA	blastn	13705	185	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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