metadata: contig_metadata: 5 rows where bioproject = "PRJNA613025", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA613025", 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
7526574	7526574	PRJNA613025_S_NODE_24286_length_192_cov_1.650350_g24132_i0	PRJNA613025	24286	192	1.65035	3.168672	Demospongiae	6042	Porifera	other_Eukaryota	56.5	0.001	NTclustered	gi\|1239988039\|gb\|KX688750.1\|	72715	g24132	i0	100	2.640625	30	0	16	0	162	191	68	39	Agelas oroides voucher Po.25569 28S ribosomal RNA gene, partial sequence	blastn	507	56.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Agelasida	Agelasidae	Agelas	Agelas oroides
15177070	15177070	PRJNA613025_S_NODE_17832_length_241_cov_1.036458_g17678_i0	PRJNA613025	17832	241	1.036458	2.49786378	Borojevia	1406145	Porifera	other_Eukaryota	171	5.74e-38	NTclustered	gi\|970976389\|gb\|KP740011.1\|	1406157	g17678	i0	85.802	67.045643153527	162	22	67	1	52	213	992	832	Borojevia cerebrum voucher IRB-CLB33 28S ribosomal RNA gene, partial sequence	blastn	16158	171	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Clathrinida	Clathrinidae	Borojevia	Borojevia cerebrum
15894482	15894482	PRJNA613025_S_NODE_13173_length_312_cov_6.505703_g13019_i0	PRJNA613025	13173	312	6.505703	20.29779336	Ascaltis sp. OV-2012	1169944	Porifera	other_Eukaryota	113	1.32e-20	NTclustered	gi\|385158749\|gb\|JQ272287.1\|	1169944	g13019	i0	82.014	43.625	139	19	44	6	175	311	2679	2545	Ascaltis sp. OV-2012 voucher QM G313824 28S ribosomal RNA gene, partial sequence	blastn	13611	113	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Clathrinida	Leucascidae	Ascaltis	Ascaltis sp. OV-2012
16451485	16451485	PRJNA613025_S_NODE_11273_length_356_cov_4.762215_g11119_i0	PRJNA613025	11273	356	4.762215	16.9534854	Demospongiae	6042	Porifera	other_Eukaryota	134	1.17e-26	NTclustered	gi\|50083161\|gb\|AY561956.1\|	283602	g11119	i0	74.566	8.68820224719101	346	68	94	12	1	335	396	60	Cf. Pseudoceratina sp. UCMPWC1076 28S large subunit ribosomal RNA gene, partial sequence	blastn	3093	134	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Verongiida	Pseudoceratinidae		cf. Pseudoceratina sp. UCMPWC1076
20994061	20994061	PRJNA613025_S_NODE_23037_length_199_cov_1.686667_g22883_i0	PRJNA613025	23037	199	1.686667	3.35646733	Oscarella sp. MNRJ 20359	2816212	Porifera	other_Eukaryota	89.8	1.32e-13	NTclustered	gi\|1996428275\|gb\|MW692043.1\|	2816212	g22883	i0	87.342	29.9949748743719	79	8	39	2	122	199	492	415	Oscarella sp. MNRJ 20359 isolate F large subunit ribosomal RNA gene, partial sequence	blastn	5969	89.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella sp. MNRJ 20359

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