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

7 rows where analysis = "diamond", bioproject = "PRJNA763243" 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
5847454	5847454	PRJNA763243_P_NODE_66165_length_234_cov_5.093168_g65819_i0	PRJNA763243	66165	234	5.093168	11.91801312	Corticium candelabrum	121492	Porifera	other_Eukaryota	116	1.76e-30	NR	XP_062515013.1	121492	g65819	i0	74.7	36.5512820512821	75	19	96.2	0	231	7	116	190	XP_062515013.1 uncharacterized protein LOC134190578 [Corticium candelabrum]	diamond	8553	116	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27653609	27653609	PRJNA763243_P_NODE_57024_length_246_cov_1.913295_g56678_i0	PRJNA763243	57024	246	1.913295	4.7067057	Corticium candelabrum	121492	Porifera	other_Eukaryota	56.2	6.14e-7	NR	XP_062506728.1	121492	g56678	i0	41.7	0.731707317073171	60	30	73.2	2	4	183	131	185	XP_062506728.1 hepatic lectin-like [Corticium candelabrum]	diamond	180	56.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28158826	28158826	PRJNA763243_P_NODE_29165_length_310_cov_4.172996_g28819_i0	PRJNA763243	29165	310	4.172996	12.9362876	Oscarella lobularis	121494	Porifera	other_Eukaryota	59.7	9.24e-8	NR	XP_065830295.1	121494	g28819	i0	39.3	0.812903225806452	84	43	75.5	2	295	62	287	368	XP_065830295.1 uncharacterized protein [Oscarella lobularis]	diamond	252	59.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30094255	30094255	PRJNA763243_P_NODE_12392_length_432_cov_2.217270_g12047_i0	PRJNA763243	12392	432	2.21727	9.5786064	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.8	0.00454	NR	XP_062508855.1	121492	g12047	i0	39.2	0.652777777777778	51	31	35.4	0	172	20	136	186	XP_062508855.1 uncharacterized protein LOC134185084 isoform X2 [Corticium candelabrum]	diamond	282	47.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31231690	31231690	PRJNA763243_P_NODE_58935_length_245_cov_0.895349_g58589_i0	PRJNA763243	58935	245	0.895349	2.19360505	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	103	1.13e-23	NR	XP_064407040.1	6063	g58589	i0	58	1.98367346938776	81	33	98	1	4	243	2316	2396	XP_064407040.1 neurobeachin-like protein 1 [Halichondria panicea]	diamond	486	103	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31769535	31769535	PRJNA763243_P_NODE_68337_length_227_cov_5.805195_g67991_i0	PRJNA763243	68337	227	5.805195	13.17779265	Homosclerophorida	81000	Porifera	other_Eukaryota	107	7.07e-25	NR	XP_062503430.1	121492	g67991	i0	65.7	4.66519823788546	70	24	92.5	0	217	8	144	213	XP_062503430.1 uncharacterized protein LOC134180315 [Corticium candelabrum]	diamond	1059	107	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32139657	32139657	PRJNA763243_P_NODE_5758_length_594_cov_10.481766_g5434_i0	PRJNA763243	5758	594	10.481766	62.26169004	Geodia barretti	519541	Porifera	other_Eukaryota	99.8	2.83e-22	NR	CAI8029397.1	519541	g5434	i0	51.4	0.53030303030303	105	43	51	3	278	580	97	197	CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti]	diamond	315	99.8	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);;