metadata: contig_metadata: 4 rows where bioproject = "PRJNA1263632", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1263632", tax_clade = "Opisthokonta" 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
29252589	29252589	PRJNA1263632_P_NODE_7469_length_246_cov_0.890173_g7451_i0	PRJNA1263632	7469	246	0.890173	2.18982558	Lubomirskia baikalensis	289074	Porifera	other_Eukaryota	97.8	3.03e-22	NR	CAI91575.1	289074	g7451	i0	58.2	0.963414634146341	79	32	96.3	1	238	2	65	142	CAI91575.1 cathepsin L2 [Lubomirskia baikalensis]	diamond	237	97.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Spongillida	Lubomirskiidae	Lubomirskia	Lubomirskia baikalensis
32160496	32160496	PRJNA1263632_P_NODE_2378_length_394_cov_1.239875_g2360_i0	PRJNA1263632	2378	394	1.239875	4.8851075	Geodia barretti	519541	Porifera	other_Eukaryota	190	1.33e-58	NR	CAI8032315.1	519541	g2360	i0	72.5	1.93401015228426	131	34	99.7	1	393	1	5	133	CAI8032315.1 40S ribosomal protein S8 [Geodia barretti]	diamond	762	190	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
32540247	32540247	PRJNA1263632_P_NODE_6519_length_251_cov_0.865169_g6501_i0	PRJNA1263632	6519	251	0.865169	2.17157419	Sycon ciliatum	27933	Porifera	other_Eukaryota	93.2	7.21e-20	NR	XP_065176571.1	27933	g6501	i0	52.3	1.05179282868526	88	37	99.2	1	3	251	266	353	XP_065176571.1 uncharacterized protein LOC135806328 [Sycon ciliatum]	diamond	264	93.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32634329	32634329	PRJNA1263632_P_NODE_2480_length_385_cov_0.971154_g2462_i0	PRJNA1263632	2480	385	0.971154	3.7389429	Geodia barretti	519541	Porifera	other_Eukaryota	105	1.09e-25	NR	CAI8030757.1	519541	g2462	i0	55.3	0.802597402597403	103	37	76.4	3	2	295	77	175	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	309	105	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti

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