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

5 rows where bioproject = "PRJNA682370" 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
2449919	2449919	PRJNA682370_S_NODE_17962_length_169_cov_2.186567_g17350_i0	PRJNA682370	17962	169	2.186567	3.69529823	Mycale	86015	Porifera	other_Eukaryota	147	6.289999999999999e-31	NTclustered	gi\|514227091\|gb\|KC961671.1\|	458504	g17350	i0	93	30.7633136094675	100	7	59	0	1	100	196	97	Mycale laxissima voucher UERJ4 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	5199	147	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Poecilosclerida	Mycalidae	Mycale	Mycale laxissima
19791338	19791338	PRJNA682370_S_NODE_2956_length_480_cov_2.184270_g2358_i0	PRJNA682370	2956	480	2.18427	10.484496	Oscarella lobularis	121494	Porifera	other_Eukaryota	154	7.079999999999999e-45	NR	XP_065829718.1	121494	g2358	i0	73.2	9.7125	97	26	60.6	0	475	185	48	144	XP_065829718.1 small ribosomal subunit protein uS9-like [Oscarella lobularis]	diamond	4662	154	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29324123	29324123	PRJNA682370_S_NODE_23289_length_153_cov_1.000000_g22677_i0	PRJNA682370	23289	153	1	1.53	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	92.4	1.8000000000000001e-22	NR	XP_003385490.1	400682	g22677	i0	78	1.96078431372549	50	11	98	0	3	152	66	115	XP_003385490.1 PREDICTED: 40S ribosomal protein S15a [Amphimedon queenslandica]	diamond	300	92.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
30315428	30315428	PRJNA682370_S_NODE_11712_length_212_cov_1.112994_g11100_i0	PRJNA682370	11712	212	1.112994	2.35954728	Metazoa	33208	Porifera	other_Eukaryota	56.2	4.01e-7	NR	XP_003387827.2	400682	g11100	i0	80.6	2.19339622641509	31	6	43.9	0	111	19	105	135	XP_003387827.2 PREDICTED: radical S-adenosyl methionine domain-containing protein 2-like [Amphimedon queenslandica]	diamond	465	56.6	0.992932862190813	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
30492923	30492923	PRJNA682370_S_NODE_10513_length_225_cov_1.621053_g9901_i0	PRJNA682370	10513	225	1.621053	3.64736925	Oscarella lobularis	121494	Porifera	other_Eukaryota	97.8	2.86e-23	NR	XP_065844408.1	121494	g9901	i0	72.2	3.81333333333333	72	19	94.7	1	5	217	31	102	XP_065844408.1 large ribosomal subunit protein eL13-like [Oscarella lobularis]	diamond	858	97.8	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);;