metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax_phylum = "Brachiopoda"

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
4539306	4539306	PRJNA724011_P_NODE_85744_length_266_cov_1.196891_g84721_i0	PRJNA724011	85744	266	1.196891	3.18373006	Lingula anatina	7574	Brachiopoda	other_Eukaryota	58.4	5.23e-4	NTclustered	gi\|919028235\|ref\|XM_013542508.1\|	7574	g84721	i0	100	0.116541353383459	31	0	12	0	32	62	524	494	PREDICTED: Lingula anatina peflin-like (LOC106164559), mRNA	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
5022249	5022249	PRJNA724011_P_NODE_64064_length_317_cov_1.262295_g63041_i0	PRJNA724011	64064	317	1.262295	4.00147515	Opisthokonta	33154	Brachiopoda	other_Eukaryota	73.1	2.28e-8	NTclustered	gi\|918999843\|ref\|XM_013545706.1\|	7574	g63041	i0	84.722	0.870662460567823	72	11	23	0	102	173	5428	5499	PREDICTED: Lingula anatina DNA-directed RNA polymerase II subunit RPB1 (LOC106167031), mRNA	blastn	276	73.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
7089144	7089144	PRJNA724011_P_NODE_105586_length_243_cov_2.235294_g104563_i0	PRJNA724011	105586	243	2.235294	5.43176442	Lingula anatina	7574	Brachiopoda	other_Eukaryota	158	4.51e-34	NTclustered	gi\|919084308\|ref\|XM_013523983.1\|	7574	g104563	i0	81.538	2.7201646090535	195	32	79	4	15	207	1506	1314	PREDICTED: Lingula anatina unconventional myosin-Ie (LOC106150947), mRNA	blastn	661	158	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
18562578	18562578	PRJNA724011_P_NODE_69815_length_301_cov_1.350877_g68792_i0	PRJNA724011	69815	301	1.350877	4.06613977	Lingula anatina	7574	Brachiopoda	other_Eukaryota	52.8	0.028	NTclustered	gi\|919064377\|ref\|XM_013558363.1\|	7574	g68792	i0	96.875	0.212624584717608	32	0	10	1	6	36	1511	1542	PREDICTED: Lingula anatina mediator of RNA polymerase II transcription subunit 7 (LOC106176123), mRNA	blastn	64	52.8	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina

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