metadata: contig_metadata: 6 rows where bioproject = "PRJNA1164198" and tax

6 rows where bioproject = "PRJNA1164198" 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
9239932	9239932	PRJNA1164198_P_NODE_5548_length_535_cov_2.660173_g5293_i0	PRJNA1164198	5548	535	2.660173	14.23192555	Opisthokonta	33154	Porifera	other_Eukaryota	207	9.67e-65	NR	Q4KTG9.1	55567	g5293	i0	62.9	5.59626168224299	167	62	93.6	0	24	524	3	169	Q4KTG9.1 RecName: Full=Large ribosomal subunit protein uL22; AltName: Full=60S ribosomal protein L17 [Suberites domuncula]	diamond	2994	209	0.990430622009569	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
11790620	11790620	PRJNA1164198_P_NODE_4750_length_576_cov_1.805169_g4502_i0	PRJNA1164198	4750	576	1.805169	10.39777344	Opisthokonta	33154	Porifera	other_Eukaryota	261	1.23e-85	NR	XP_064404868.1	6063	g4502	i0	65.7	31.9479166666667	181	62	94.3	0	2	544	6	186	XP_064404868.1 large ribosomal subunit protein uL13-like [Halichondria panicea]	diamond	18402	263	0.992395437262357	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
15067201	15067201	PRJNA1164198_P_NODE_5232_length_550_cov_1.498952_g4979_i0	PRJNA1164198	5232	550	1.498952	8.244236	Amphidiscosida	269027	Porifera	other_Eukaryota	139	4.04e-28	NTclustered	gi\|1336429313\|gb\|MF684000.1\|	2079124	g4979	i0	81.657	23.1581818181818	169	30	31	1	75	242	504	672	Hyalonema agassizi voucher SMF12069 28S ribosomal RNA gene, partial sequence	blastn	12737	139	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Amphidiscosida	Hyalonematidae	Hyalonema	Hyalonema agassizi
26882383	26882383	PRJNA1164198_P_NODE_7581_length_454_cov_2.695538_g7320_i0	PRJNA1164198	7581	454	2.695538	12.23774252	Geodia barretti	519541	Porifera	other_Eukaryota	102	5.4499999999999996e-24	NR	CAI8030757.1	519541	g7320	i0	53.4	1.36123348017621	103	39	64.8	3	34	327	77	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	618	102	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
29219568	29219568	PRJNA1164198_P_NODE_25269_length_251_cov_0.876404_g25000_i0	PRJNA1164198	25269	251	0.876404	2.19977404	Halichondria panicea	6063	Porifera	other_Eukaryota	87.8	4.47e-18	NR	XP_064395289.1	6063	g25000	i0	59.4	2.31872509960159	64	25	75.3	1	191	3	32	95	XP_064395289.1 serine carboxypeptidase S10 family member 1-like [Halichondria panicea]	diamond	582	87.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32253724	32253724	PRJNA1164198_P_NODE_30338_length_243_cov_0.917647_g30069_i0	PRJNA1164198	30338	243	0.917647	2.22988221	Sycon ciliatum	27933	Porifera	other_Eukaryota	66.6	3.28e-11	NR	XP_065187238.1	27933	g30069	i0	73.9	10.6172839506173	46	12	56.8	0	140	3	50	95	XP_065187238.1 nascent polypeptide-associated complex subunit alpha-like [Sycon ciliatum]	diamond	2580	66.6	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);;