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

5 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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
2820427	2820427	PRJNA1120060_P_NODE_685083_length_335_cov_4.393130_g667270_i0	PRJNA1120060	685083	335	4.39313	14.7169855	Lingula anatina	7574	Brachiopoda	other_Eukaryota	52.8	0.032	NTclustered	gi\|1351491617\|ref\|XM_013564689.2\|	7574	g667270	i0	100	0.0835820895522388	28	0	8	0	304	331	2490	2463	PREDICTED: Lingula anatina nucleolar GTP-binding protein 2 (LOC106180653), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
13009892	13009892	PRJNA1120060_P_NODE_2837111_length_245_cov_1.639535_g2819025_i0	PRJNA1120060	2837111	245	1.639535	4.01686075	Lingula anatina	7574	Brachiopoda	other_Eukaryota	54.7	0.006	NTclustered	gi\|919042547\|ref\|XM_013549074.1\|	7574	g2819025	i0	100	0.118367346938776	29	0	12	0	177	205	966	938	PREDICTED: Lingula anatina histone H1-delta (LOC106169582), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
15537140	15537140	PRJNA1120060_P_NODE_1200073_length_310_cov_3.084388_g1182133_i0	PRJNA1120060	1200073	310	3.084388	9.5616028	Lingula anatina	7574	Brachiopoda	other_Eukaryota	52.8	0.029	NTclustered	gi\|919001440\|ref\|XM_013552637.1\|	7574	g1182133	i0	92.105	0.12258064516129	38	1	12	2	165	202	3862	3827	PREDICTED: Lingula anatina centrobin (LOC106172050), transcript variant X1, mRNA	blastn	38	52.8	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
16825451	16825451	PRJNA1120060_P_NODE_2191274_length_265_cov_2.453125_g2173222_i0	PRJNA1120060	2191274	265	2.453125	6.50078125	Lingula anatina	7574	Brachiopoda	other_Eukaryota	52.8	0.024	NTclustered	gi\|919076405\|ref\|XM_013563835.1\|	7574	g2173222	i0	100	0.316981132075472	28	0	11	0	74	101	634	607	PREDICTED: Lingula anatina uncharacterized LOC106179994 (LOC106179994), transcript variant X2, mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
24482248	24482248	PRJNA1120060_P_NODE_2829680_length_245_cov_2.325581_g2811594_i0	PRJNA1120060	2829680	245	2.325581	5.69767345	Lingula anatina	7574	Brachiopoda	other_Eukaryota	54.7	0.006	NTclustered	gi\|919001440\|ref\|XM_013552637.1\|	7574	g2811594	i0	94.444	0.146938775510204	36	1	15	1	89	124	3835	3869	PREDICTED: Lingula anatina centrobin (LOC106172050), transcript variant X1, mRNA	blastn	36	54.7	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);;