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

10 rows where bioproject = "PRJNA345071", 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
11871904	11871904	PRJNA345071_P_NODE_1350_length_471_cov_2.610553_g1310_i0	PRJNA345071	1350	471	2.610553	12.29570463	root	1	Root_unresolved	Root_unresolved	229	3.28e-71	NR	XP_013389397.1	7574	g1310	i0	78.8	94.2356687898089	137	29	87.3	0	413	3	4	140	XP_013389397.1 60S ribosomal protein L4 [Lingula anatina]	diamond	44385	230	0.995652173913044	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
18244886	18244886	PRJNA345071_P_NODE_295_length_853_cov_3.365385_g260_i0	PRJNA345071	295	853	3.365385	28.70673405	Lingula anatina	7574	Brachiopoda	other_Eukaryota	254	8.25e-81	NR	XP_013399917.1	7574	g260	i0	54.3	2.63423212192263	245	110	85.8	2	119	850	6	249	XP_013399917.1 60S ribosomal protein L6 [Lingula anatina]	diamond	2247	254	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27912993	27912993	PRJNA345071_P_NODE_9425_length_246_cov_2.063584_g9385_i0	PRJNA345071	9425	246	2.063584	5.07641664	Metazoa	33208	Brachiopoda	other_Eukaryota	129	1.17e-35	NR	XP_013394546.1	7574	g9385	i0	75.3	24.7560975609756	81	20	98.8	0	1	243	68	148	XP_013394546.1 60S ribosomal protein L10a-2 isoform X2 [Lingula anatina]	diamond	6090	130	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
28544891	28544891	PRJNA345071_P_NODE_8387_length_250_cov_0.881356_g8347_i0	PRJNA345071	8387	250	0.881356	2.20339	Metazoa	33208	Brachiopoda	other_Eukaryota	118	2.6199999999999996e-31	NR	XP_013390070.1	7574	g8347	i0	63.9	8.964	83	30	99.6	0	250	2	21	103	XP_013390070.1 inosine triphosphate pyrophosphatase-like [Lingula anatina]	diamond	2241	119	0.991596638655462	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
28622353	28622353	PRJNA345071_P_NODE_347_length_796_cov_3.125864_g310_i0	PRJNA345071	347	796	3.125864	24.88187744	Lingula anatina	7574	Brachiopoda	other_Eukaryota	293	1.5699999999999993e-96	NR	XP_013380988.2	7574	g310	i0	62.4	6.81407035175879	234	88	88.2	0	702	1	2	235	XP_013380988.2 60S ribosomal protein L7 [Lingula anatina]	diamond	5424	293	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
29285111	29285111	PRJNA345071_P_NODE_5569_length_281_cov_1.500000_g5529_i0	PRJNA345071	5569	281	1.5	4.215	Lingula anatina	7574	Brachiopoda	other_Eukaryota	157	1.5499999999999996e-43	NR	XP_013389396.1	7574	g5529	i0	80.6	2.97864768683274	93	16	99.3	1	281	3	348	438	XP_013389396.1 LOW QUALITY PROTEIN: protein disulfide-isomerase A3-like [Lingula anatina]	diamond	837	157	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
29600725	29600725	PRJNA345071_P_NODE_6190_length_271_cov_1.575758_g6150_i0	PRJNA345071	6190	271	1.575758	4.27030418	Lingula anatina	7574	Brachiopoda	other_Eukaryota	43.5	0.0163	NR	XP_013386814.2	7574	g6150	i0	50	0.33210332103321	30	15	33.2	0	180	269	30	59	XP_013386814.2 probable cation-transporting ATPase 13A3 [Lingula anatina]	diamond	90	43.5	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
30232710	30232710	PRJNA345071_P_NODE_212_length_978_cov_1.701657_g185_i0	PRJNA345071	212	978	1.701657	16.64220546	Lingula anatina	7574	Brachiopoda	other_Eukaryota	90.1	1.1e-15	NR	XP_013409581.1	7574	g185	i0	28.2	1.2239263803681	202	115	53.7	4	780	256	121	319	XP_013409581.1 vitellogenin-6 [Lingula anatina]	diamond	1197	90.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
31324226	31324226	PRJNA345071_P_NODE_4415_length_302_cov_1.524017_g4375_i0	PRJNA345071	4415	302	1.524017	4.60253134	Metazoa	33208	Brachiopoda	other_Eukaryota	85.1	9.35e-17	NR	XP_013414077.1	7574	g4375	i0	47.9	3.87417218543046	94	45	93.4	2	302	21	65	154	XP_013414077.1 radial spoke head protein 6 homolog A-like [Lingula anatina]	diamond	1170	85.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32336808	32336808	PRJNA345071_P_NODE_3679_length_322_cov_1.975904_g3639_i0	PRJNA345071	3679	322	1.975904	6.36241088	Metazoa	33208	Brachiopoda	other_Eukaryota	57.8	4.77e-7	NR	XP_013406777.1	7574	g3639	i0	33.3	3.54968944099379	87	52	79.2	2	68	322	307	389	XP_013406777.1 CD209 antigen-like [Lingula anatina]	diamond	1143	57.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);;