metadata: contig_metadata: 10 rows where bioproject = "PRJNA450343", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA450343", tax_kingdom = "Metazoa" 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
8092224	8092224	PRJNA450343_P_NODE_1407_length_472_cov_3.430260_g1339_i0	PRJNA450343	1407	472	3.43026	16.1908272	Lingula anatina	7574	Brachiopoda	other_Eukaryota	237	4.09e-76	NR	XP_013391198.1	7574	g1339	i0	91.3	1.75423728813559	138	12	87.7	0	415	2	1	138	XP_013391198.1 ribosome biogenesis protein NSA2 homolog [Lingula anatina]	diamond	828	237	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
8092227	8092227	PRJNA450343_P_NODE_1507_length_452_cov_19.429280_g1439_i0	PRJNA450343	1507	452	19.42928	87.8203456	Lingula anatina	7574	Brachiopoda	other_Eukaryota	291	8.53e-74	NTclustered	gi\|1351492704\|ref\|XM_013549543.2\|	7574	g1439	i0	80.357	9.76769911504425	392	69	86	8	54	440	107	495	PREDICTED: Lingula anatina 40S ribosomal protein S20 (LOC106169898), mRNA	blastn	4415	291	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
17016405	17016405	PRJNA450343_P_NODE_914_length_593_cov_10.568015_g850_i0	PRJNA450343	914	593	10.568015	62.66832895	Lingula anatina	7574	Brachiopoda	other_Eukaryota	486	1.3599999999999999e-132	NTclustered	gi\|919031420\|ref\|XM_013543873.1\|	7574	g850	i0	81.913	9.27487352445194	575	104	97	0	8	582	614	40	PREDICTED: Lingula anatina 40S ribosomal protein S7 (LOC106165617), mRNA	blastn	5500	486	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27044486	27044486	PRJNA450343_P_NODE_8282_length_188_cov_1.726619_g8214_i0	PRJNA450343	8282	188	1.726619	3.24604372	Lingula anatina	7574	Brachiopoda	other_Eukaryota	50.1	4.69e-5	NR	XP_013418636.1	7574	g8214	i0	40	1.77127659574468	50	30	79.8	0	173	24	462	511	XP_013418636.1 dynamin-1 isoform X1 [Lingula anatina]	diamond	333	50.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27076068	27076068	PRJNA450343_P_NODE_3542_length_284_cov_1.659574_g3474_i0	PRJNA450343	3542	284	1.659574	4.71319016	Lingula anatina	7574	Brachiopoda	other_Eukaryota	45.1	0.00805	NR	XP_013379010.1	7574	g3474	i0	42	4.05633802816901	69	37	71.8	3	204	1	9	75	XP_013379010.1 uncharacterized protein LOC106150640 [Lingula anatina]	diamond	1152	45.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27107487	27107487	PRJNA450343_P_NODE_2362_length_354_cov_1.888525_g2294_i0	PRJNA450343	2362	354	1.888525	6.6853785	Lingula anatina	7574	Brachiopoda	other_Eukaryota	135	3.699999999999999e-38	NR	XP_013386384.1	7574	g2294	i0	69.3	0.855932203389831	101	31	85.6	0	3	305	30	130	XP_013386384.1 fatty acid-binding protein, heart [Lingula anatina]	diamond	303	135	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
28102879	28102879	PRJNA450343_P_NODE_4865_length_241_cov_1.057292_g4797_i0	PRJNA450343	4865	241	1.057292	2.54807372	Metazoa	33208	Brachiopoda	other_Eukaryota	148	5.23e-44	NR	XP_013386888.1	7574	g4797	i0	88.6	12.6721991701245	79	9	98.3	0	1	237	39	117	XP_013386888.1 NHP2-like protein 1 [Lingula anatina]	diamond	3054	148	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
29081928	29081928	PRJNA450343_P_NODE_4048_length_264_cov_3.320930_g3980_i0	PRJNA450343	4048	264	3.32093	8.7672552	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.5	1.82e-17	NR	XP_013408006.1	7574	g3980	i0	66.7	1.84090909090909	54	18	61.4	0	258	97	45	98	XP_013408006.1 stefin-C [Lingula anatina]	diamond	486	80.5	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32352618	32352618	PRJNA450343_P_NODE_12099_length_164_cov_2.652174_g12031_i0	PRJNA450343	12099	164	2.652174	4.34956536	Lingula anatina	7574	Brachiopoda	other_Eukaryota	40	0.0399	NR	XP_013402883.1	7574	g12031	i0	46.2	0.713414634146341	39	21	71.3	0	117	1	8	46	XP_013402883.1 uncharacterized protein LOC106168394 [Lingula anatina]	diamond	117	40	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32904778	32904778	PRJNA450343_P_NODE_11860_length_165_cov_0.879310_g11792_i0	PRJNA450343	11860	165	0.87931	1.4508615	Metazoa	33208	Brachiopoda	other_Eukaryota	100	5.759999999999999e-23	NR	XP_013421372.1	7574	g11792	i0	87	3.90909090909091	54	7	98.2	0	163	2	309	362	XP_013421372.1 DNA replication licensing factor mcm5-A-like isoform X2 [Lingula anatina]	diamond	645	100	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);;