metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB14175" 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
25918544	25918544	PRJEB14175_P_NODE_55524_length_499_cov_10.383562_g53278_i0	PRJEB14175	55524	499	10.383562	51.81397438	Corticium candelabrum	121492	Porifera	other_Eukaryota	60.2	2.91e-4	NTclustered	gi\|2665855738\|ref\|XM_062652469.1\|	121492	g53278	i0	94.737	3.81563126252505	38	2	8	0	413	450	398	435	PREDICTED: Corticium candelabrum piggyBac transposable element-derived protein 3-like (LOC134184724), mRNA	blastn	1904	60.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
26317165	26317165	PRJEB14175_P_NODE_101927_length_353_cov_9.832192_g99661_i0	PRJEB14175	101927	353	9.832192	34.70763776	Sycon ciliatum	27933	Porifera	other_Eukaryota	58.4	7.17e-4	NTclustered	gi\|2732905565\|ref\|XM_065340786.1\|	27933	g99661	i0	100	0.0878186968838527	31	0	9	0	270	300	1059	1029	PREDICTED: Sycon ciliatum nuclear cap-binding protein subunit 3-like (LOC135828341), mRNA	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
26317707	26317707	PRJEB14175_P_NODE_112511_length_333_cov_1.047794_g110245_i0	PRJEB14175	112511	333	1.047794	3.48915402	Oscarella lobularis	121494	Porifera	other_Eukaryota	65.8	4.03e-6	NTclustered	gi\|2746780687\|ref\|XM_065974316.1\|	121494	g110245	i0	91.489	0.141141141141141	47	4	14	0	200	246	1624	1578	PREDICTED: Oscarella lobularis putative serine/threonine-protein kinase F31E3.2 (LOC136186845), mRNA	blastn	47	65.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
26424480	26424480	PRJEB14175_P_NODE_165247_length_259_cov_4.898990_g162980_i0	PRJEB14175	165247	259	4.89899	12.6883841	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	169	2.24e-37	NTclustered	gi\|2719038895\|ref\|XR_010393624.1\|	6063	g162980	i0	94.495	42.2509652509653	109	6	42	0	131	239	2160	2052	PREDICTED: Halichondria panicea large subunit ribosomal RNA (LOC135332780), rRNA	blastn	10943	169	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
26427096	26427096	PRJEB14175_P_NODE_52255_length_515_cov_15.409692_g50012_i0	PRJEB14175	52255	515	15.409692	79.3599138	Leucettidae	81544	Porifera	other_Eukaryota	237	1.3e-57	NTclustered	gi\|385158759\|gb\|JQ272297.1\|	197028	g50012	i0	84.553	42.3533980582524	246	31	47	7	1	243	2482	2723	Leucetta microraphis voucher QM G313659 28S ribosomal RNA gene, partial sequence	blastn	21812	237	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Clathrinida	Leucettidae	Leucetta	Leucetta microraphis

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