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

6 rows where bioproject = "PRJNA879067" 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
3404548	3404548	PRJNA879067_P_NODE_103743_length_250_cov_1.604520_g100257_i0	PRJNA879067	103743	250	1.60452	4.0113	Heterochone sp. SMF 10523	472213	Porifera	other_Eukaryota	58.4	4.87e-4	NTclustered	gi\|190350223\|emb\|AM886378.1\|	472213	g100257	i0	100	0.124	31	0	12	0	191	221	789	759	Heterochone sp. 10523 partial 28S rRNA gene, isolated from Japan	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Sceptrulophora	Aphrocallistidae	Heterochone	Heterochone sp. SMF 10523
27529205	27529205	PRJNA879067_P_NODE_75863_length_358_cov_1.063158_g72377_i0	PRJNA879067	75863	358	1.063158	3.80610564	Oscarella lobularis	121494	Porifera	other_Eukaryota	62	2e-8	NR	XP_065831158.1	121494	g72377	i0	40.8	0.636871508379888	76	44	63.7	1	3	230	264	338	XP_065831158.1 THO complex subunit 6 homolog [Oscarella lobularis]	diamond	228	62	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28539829	28539829	PRJNA879067_P_NODE_74827_length_363_cov_1.327586_g71341_i0	PRJNA879067	74827	363	1.327586	4.81913718	Corticium candelabrum	121492	Porifera	other_Eukaryota	64.3	2.87e-9	NR	XP_062515858.1	121492	g71341	i0	55.8	2.90909090909091	52	22	42.1	1	198	46	253	304	XP_062515858.1 L-proline trans-4-hydroxylase-like [Corticium candelabrum]	diamond	1056	64.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28863254	28863254	PRJNA879067_P_NODE_98608_length_267_cov_2.835052_g95122_i0	PRJNA879067	98608	267	2.835052	7.56958884	Opisthokonta	33154	Porifera	other_Eukaryota	72.4	1.07e-12	NR	XP_003382489.1	400682	g95122	i0	71.1	3.69662921348315	45	11	48.3	1	245	117	266	310	XP_003382489.1 PREDICTED: receptor of activated protein C kinase 1-like [Amphimedon queenslandica]	diamond	987	72.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
32678769	32678769	PRJNA879067_P_NODE_14700_length_1240_cov_4.502999_g12104_i0	PRJNA879067	14700	1240	4.502999	55.8371876	Dysidea avara	196820	Porifera	other_Eukaryota	229	1.78e-67	NR	XP_065903318.1	196820	g12104	i0	44.9	0.965322580645161	399	194	94.6	11	11	1183	17	397	XP_065903318.1 zinc transporter ZupT-like [Dysidea avara]	diamond	1197	229	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32678770	32678770	PRJNA879067_P_NODE_19600_length_1023_cov_2.802105_g16697_i0	PRJNA879067	19600	1023	2.802105	28.66553415	Oscarella lobularis	121494	Porifera	other_Eukaryota	313	1.2199999999999998e-99	NR	XP_065829151.1	121494	g16697	i0	48.3	1.03225806451613	352	156	99.4	9	1017	1	155	493	XP_065829151.1 sialate O-acetylesterase-like [Oscarella lobularis]	diamond	1056	313	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis

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