metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA745553" 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
4552867	4552867	PRJNA745553_S_NODE_3564_length_560_cov_9.665298_g3379_i0	PRJNA745553	3564	560	9.665298	54.1256688	Sycon ciliatum	27933	Porifera	other_Eukaryota	178	4.16e-54	NR	CCQ18628.1	27933	g3379	i0	64.7	1.41964285714286	133	46	71.3	1	86	484	1	132	CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum]	diamond	795	178	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
13477822	13477822	PRJNA745553_S_NODE_10811_length_370_cov_6.225589_g10616_i0	PRJNA745553	10811	370	6.225589	23.0346793	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	150	2.6e-40	NR	XP_065920557.1	196820	g10616	i0	81.5	3.02432432432432	92	17	74.6	0	1	276	434	525	XP_065920557.1 T-complex protein 1 subunit delta-like [Dysidea avara]	diamond	1119	150	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
17302412	17302412	PRJNA745553_S_NODE_29014_length_225_cov_8.203947_g28819_i0	PRJNA745553	29014	225	8.203947	18.45888075	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.7	2.49e-19	NR	XP_062521421.1	121492	g28819	i0	80.4	5.44	51	10	68	0	22	174	118	168	XP_062521421.1 actin-related protein 2/3 complex subunit 4 [Corticium candelabrum]	diamond	1224	86.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
26957654	26957654	PRJNA745553_S_NODE_23602_length_254_cov_4.143646_g23407_i0	PRJNA745553	23602	254	4.143646	10.52486084	Halichondria panicea	6063	Porifera	other_Eukaryota	52.4	7.24e-6	NR	XP_064384657.1	6063	g23407	i0	79.3	1.02755905511811	29	6	34.3	0	232	146	151	179	XP_064384657.1 60S ribosome subunit biogenesis protein NIP7 homolog [Halichondria panicea]	diamond	261	52.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27242328	27242328	PRJNA745553_S_NODE_1603_length_692_cov_4.224556_g1451_i0	PRJNA745553	1603	692	4.224556	29.23392752	Halichondria panicea	6063	Porifera	other_Eukaryota	94.4	2.76e-18	NR	XP_064386088.1	6063	g1451	i0	33.7	0.823699421965318	190	84	82.4	4	3	572	328	475	XP_064386088.1 serine palmitoyltransferase 1-like [Halichondria panicea]	diamond	570	94.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30905992	30905992	PRJNA745553_S_NODE_6494_length_459_cov_4.044041_g6300_i0	PRJNA745553	6494	459	4.044041	18.56214819	Sycon ciliatum	27933	Porifera	other_Eukaryota	182	3.73e-56	NR	XP_065187500.1	27933	g6300	i0	76.3	2.9281045751634	114	26	73.9	1	28	366	14	127	XP_065187500.1 adenosine 5'-monophosphoramidase HINT1-like [Sycon ciliatum]	diamond	1344	182	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31790960	31790960	PRJNA745553_S_NODE_17517_length_295_cov_1.734234_g17322_i0	PRJNA745553	17517	295	1.734234	5.1159903	Sycon ciliatum	27933	Porifera	other_Eukaryota	49.3	3.28e-4	NR	XP_065177666.1	27933	g17322	i0	32.5	0.783050847457627	77	43	72.2	2	284	72	473	546	XP_065177666.1 sialate O-acetylesterase-like [Sycon ciliatum]	diamond	231	49.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);;