metadata: contig_metadata: 4 rows where bioproject = "PRJNA1192965" and tax

4 rows where bioproject = "PRJNA1192965" 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
27103823	27103823	PRJNA1192965_P_NODE_3182_length_253_cov_1.711111_g3163_i0	PRJNA1192965	3182	253	1.711111	4.32911083	Oopsacas minuta	111878	Porifera	other_Eukaryota	155	7.05e-44	NR	KAI6651872.1	111878	g3163	i0	90.5	0.99604743083004	84	8	99.6	0	1	252	127	210	KAI6651872.1 hypothetical protein LOD99_4751 [Oopsacas minuta]	diamond	252	155	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
28323006	28323006	PRJNA1192965_P_NODE_5086_length_241_cov_0.916667_g5067_i0	PRJNA1192965	5086	241	0.916667	2.20916747	Metazoa	33208	Porifera	other_Eukaryota	94.4	8.47e-22	NR	XP_062504440.1	121492	g5067	i0	62.1	6.42323651452282	66	25	82.2	0	1	198	148	213	XP_062504440.1 pleckstrin homology domain-containing family F member 2-like [Corticium candelabrum]	diamond	1548	94.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30735798	30735798	PRJNA1192965_P_NODE_134_length_904_cov_10.239471_g121_i0	PRJNA1192965	134	904	10.239471	92.56481784	Geodia barretti	519541	Porifera	other_Eukaryota	148	4.019999999999999e-40	NR	CAI8030757.1	519541	g121	i0	51.8	0.550884955752212	166	65	52.8	6	615	139	18	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	498	148	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
32158947	32158947	PRJNA1192965_P_NODE_3158_length_254_cov_1.701657_g3139_i0	PRJNA1192965	3158	254	1.701657	4.32220878	Sycon ciliatum	27933	Porifera	other_Eukaryota	84.3	2.46e-18	NR	XP_065175085.1	27933	g3139	i0	63.6	3.93307086614173	66	24	78	0	199	2	20	85	XP_065175085.1 small ribosomal subunit protein uS9-like [Sycon ciliatum]	diamond	999	84.3	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);;