metadata: contig_metadata: 6 rows where bioproject = "PRJNA685060", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA685060", tax_kingdom = "Metazoa" 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
5769786	5769786	PRJNA685060_P_NODE_15085_length_247_cov_0.885057_g14995_i0	PRJNA685060	15085	247	0.885057	2.18609079	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.1	3.6e-23	NR	XP_065839897.1	121494	g14995	i0	59.3	3.94736842105263	81	33	98.4	0	2	244	67	147	XP_065839897.1 ADP-ribosylation factor-like protein 5B [Oscarella lobularis]	diamond	975	97.8	0.992842535787321	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27378523	27378523	PRJNA685060_P_NODE_17523_length_241_cov_0.916667_g17433_i0	PRJNA685060	17523	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.1	2.79e-8	NR	XP_064403734.1	6063	g17433	i0	39.2	2.96265560165975	79	46	98.3	1	237	1	222	298	XP_064403734.1 uncharacterized protein sll0103-like [Halichondria panicea]	diamond	714	60.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28104340	28104340	PRJNA685060_P_NODE_7305_length_352_cov_1.491039_g7215_i0	PRJNA685060	7305	352	1.491039	5.24845728	Metazoa	33208	Porifera	other_Eukaryota	145	9.309999999999998e-42	NR	XP_064384657.1	6063	g7215	i0	60.7	5.77840909090909	112	44	95.5	0	337	2	1	112	XP_064384657.1 60S ribosome subunit biogenesis protein NIP7 homolog [Halichondria panicea]	diamond	2034	146	0.993150684931507	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28535129	28535129	PRJNA685060_P_NODE_15667_length_245_cov_2.575581_g15577_i0	PRJNA685060	15667	245	2.575581	6.31017345	Geodia barretti	519541	Porifera	other_Eukaryota	68.2	1.48e-12	NR	CAI8011404.1	519541	g15577	i0	43.1	1.76326530612245	72	41	88.2	0	25	240	4	75	CAI8011404.1 COP9 signalosome complex subunit 6 [Geodia barretti]	diamond	432	68.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
28830563	28830563	PRJNA685060_P_NODE_17208_length_242_cov_0.911243_g17118_i0	PRJNA685060	17208	242	0.911243	2.20520806	Metazoa	33208	Porifera	other_Eukaryota	72	2.84e-13	NR	KAI6651118.1	111878	g17118	i0	51.8	2.10743801652893	56	27	69.4	0	226	59	120	175	KAI6651118.1 Tigger transposable element-derived protein 4 [Oopsacas minuta]	diamond	510	72	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
32674181	32674181	PRJNA685060_P_NODE_15260_length_247_cov_0.885057_g15170_i0	PRJNA685060	15260	247	0.885057	2.18609079	Corticium candelabrum	121492	Porifera	other_Eukaryota	122	8.809999999999999e-31	NR	XP_062516867.1	121492	g15170	i0	68.4	0.959514170040486	79	25	96	0	237	1	202	280	XP_062516867.1 2-(3-amino-3-carboxypropyl)histidine synthase subunit 1-like [Corticium candelabrum]	diamond	237	122	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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