metadata: contig_metadata: 4 rows where bioproject = "PRJNA827593", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA827593", 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
9748799	9748799	PRJNA827593_P_NODE_14388_length_572_cov_1.781563_g14093_i0	PRJNA827593	14388	572	1.781563	10.19054036	Suberites ficus	86007	Porifera	other_Eukaryota	152	5.41e-32	NTclustered	gi\|15208494\|gb\|AY026381.1\|	86007	g14093	i0	77.091	24.1031468531469	275	55	47	8	1	270	1415	1686	Suberites ficus 28S large subunit ribosomal RNA gene, partial sequence	blastn	13787	152	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites ficus
26968133	26968133	PRJNA827593_P_NODE_66202_length_243_cov_2.211765_g65903_i0	PRJNA827593	66202	243	2.211765	5.37458895	Metazoa	33208	Porifera	other_Eukaryota	64.7	6.73e-10	NR	XP_065192431.1	27933	g65903	i0	37.3	5.55555555555556	75	47	92.6	0	17	241	663	737	XP_065192431.1 E3 ubiquitin-protein ligase HECTD3-like [Sycon ciliatum]	diamond	1350	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27939040	27939040	PRJNA827593_P_NODE_35425_length_344_cov_1.586716_g35126_i0	PRJNA827593	35425	344	1.586716	5.45830304	Oopsacas minuta	111878	Porifera	other_Eukaryota	62.8	4.15e-9	NR	KAI6648619.1	111878	g35126	i0	34.3	2.66860465116279	102	61	88.1	2	343	41	78	174	KAI6648619.1 hypothetical protein LOD99_7976 [Oopsacas minuta]	diamond	918	62.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
28507319	28507319	PRJNA827593_P_NODE_22367_length_447_cov_1.433155_g22068_i0	PRJNA827593	22367	447	1.433155	6.40620285	Sycon ciliatum	27933	Porifera	other_Eukaryota	47.8	0.00528	NR	XP_065178082.1	27933	g22068	i0	31	3.26174496644295	116	52	71.8	4	125	445	84	180	XP_065178082.1 uncharacterized protein LOC135808782 [Sycon ciliatum]	diamond	1458	47.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum

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