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

6 rows where bioproject = "PRJNA849172" 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
8488393	8488393	PRJNA849172_P_NODE_18007_length_488_cov_16.855422_g17648_i0	PRJNA849172	18007	488	16.855422	82.25445936	Metazoa	33208	Porifera	other_Eukaryota	199	1.17e-58	NR	XP_064383450.1	6063	g17648	i0	73.9	4.13114754098361	134	34	82.4	1	486	85	330	462	XP_064383450.1 trifunctional enzyme subunit beta, mitochondrial-like [Halichondria panicea]	diamond	2016	199	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
8884961	8884961	PRJNA849172_P_NODE_115647_length_235_cov_6.067901_g115287_i0	PRJNA849172	115647	235	6.067901	14.25956735	Haplosclerida	6049	Porifera	other_Eukaryota	108	4.43e-19	NTclustered	gi\|1284883228\|gb\|KY825184.1\|	178514	g115287	i0	81.159	10.0765957446809	138	22	58	3	63	199	3474	3340	Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence	blastn	2368	108	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon compressa
26706358	26706358	PRJNA849172_P_NODE_125461_length_227_cov_5.837662_g125101_i0	PRJNA849172	125461	227	5.837662	13.25149274	Oscarella lobularis	121494	Porifera	other_Eukaryota	62.8	2.63e-9	NR	XP_065835083.1	121494	g125101	i0	44.7	1.00440528634361	76	27	80.6	2	222	40	802	877	XP_065835083.1 probable ubiquitin-conjugating enzyme protein 17 [Oscarella lobularis]	diamond	228	62.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
26865226	26865226	PRJNA849172_P_NODE_112241_length_238_cov_24.406061_g111881_i0	PRJNA849172	112241	238	24.406061	58.08642518	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	49.7	7.33e-5	NR	XP_003386742.1	400682	g111881	i0	38.2	0.857142857142857	68	38	85.7	2	3	206	137	200	XP_003386742.1 PREDICTED: glutathione S-transferase 1-like [Amphimedon queenslandica]	diamond	204	49.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
29139381	29139381	PRJNA849172_P_NODE_56389_length_285_cov_15.386792_g56029_i0	PRJNA849172	56389	285	15.386792	43.8523572	Sycon ciliatum	27933	Porifera	other_Eukaryota	80.1	8.92e-17	NR	CCQ18628.1	27933	g56029	i0	77.1	1.56842105263158	48	11	50.5	0	20	163	84	131	CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum]	diamond	447	80.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32046413	32046413	PRJNA849172_P_NODE_58678_length_282_cov_17.296651_g58318_i0	PRJNA849172	58678	282	17.296651	48.77655582	Sycon ciliatum	27933	Porifera	other_Eukaryota	117	9.23e-32	NR	XP_065189577.1	27933	g58318	i0	59.3	0.968085106382979	91	37	96.8	0	279	7	24	114	XP_065189577.1 glutaredoxin-like [Sycon ciliatum]	diamond	273	117	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);;