metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA846110" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA846110" 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
5936232	5936232	PRJNA846110_P_NODE_23745_length_249_cov_3.102273_g23500_i0	PRJNA846110	23745	249	3.102273	7.72465977	Lingula anatina	7574	Brachiopoda	other_Eukaryota	73.1	1.73e-8	NTclustered	gi\|1351404362\|ref\|XM_013542719.2\|	7574	g23500	i0	95.556	0.36144578313253	45	2	18	0	93	137	294	250	PREDICTED: Lingula anatina syntenin-1 (LOC106164717), transcript variant X2, mRNA	blastn	90	73.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
8485939	8485939	PRJNA846110_P_NODE_26827_length_245_cov_1.598837_g26582_i0	PRJNA846110	26827	245	1.598837	3.91715065	Lingula anatina	7574	Brachiopoda	other_Eukaryota	159	1.27e-34	NTclustered	gi\|1351347990\|ref\|XM_013556812.2\|	7574	g26582	i0	79.06	2.84897959183673	234	47	95	2	10	242	355	587	PREDICTED: Lingula anatina elongation of very long chain fatty acids protein 7 (LOC106175006), mRNA	blastn	698	159	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
9761152	9761152	PRJNA846110_P_NODE_27648_length_244_cov_1.350877_g27403_i0	PRJNA846110	27648	244	1.350877	3.29613988	Lingula anatina	7574	Brachiopoda	other_Eukaryota	113	9.95e-21	NTclustered	gi\|919074349\|ref\|XM_013562902.1\|	7574	g27403	i0	89.011	4.88524590163934	91	10	37	0	44	134	94	184	PREDICTED: Lingula anatina protein tyrosine phosphatase type IVA 2 (LOC106179325), transcript variant X1, mRNA	blastn	1192	113	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
11036763	11036763	PRJNA846110_P_NODE_23789_length_249_cov_2.107955_g23544_i0	PRJNA846110	23789	249	2.107955	5.24880795	Lingula anatina	7574	Brachiopoda	other_Eukaryota	139	1.68e-28	NTclustered	gi\|1351421646\|ref\|XM_013532380.2\|	7574	g23544	i0	80.663	5.15261044176707	181	34	72	1	1	180	277	97	PREDICTED: Lingula anatina POC1 centriolar protein homolog A-like (LOC106156934), transcript variant X1, mRNA	blastn	1283	139	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
12312081	12312081	PRJNA846110_P_NODE_12670_length_307_cov_2.512821_g12425_i0	PRJNA846110	12670	307	2.512821	7.71436047	Lingula anatina	7574	Brachiopoda	other_Eukaryota	86.1	2.82e-12	NTclustered	gi\|919016746\|ref\|XM_013537297.1\|	7574	g12425	i0	91.803	2.32899022801303	61	5	20	0	221	281	1764	1824	PREDICTED: Lingula anatina S-adenosylmethionine synthase (LOC106160641), transcript variant X1, mRNA	blastn	715	86.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
13586736	13586736	PRJNA846110_P_NODE_26131_length_246_cov_1.283237_g25886_i0	PRJNA846110	26131	246	1.283237	3.15676302	Lingula anatina	7574	Brachiopoda	other_Eukaryota	87.9	6.09e-13	NTclustered	gi\|919016746\|ref\|XM_013537297.1\|	7574	g25886	i0	94.643	2.80081300813008	56	3	23	0	3	58	1819	1764	PREDICTED: Lingula anatina S-adenosylmethionine synthase (LOC106160641), transcript variant X1, mRNA	blastn	689	87.9	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
13586788	13586788	PRJNA846110_P_NODE_3211_length_578_cov_19.914851_g2972_i0	PRJNA846110	3211	578	19.914851	115.10783878	Lingula anatina	7574	Brachiopoda	other_Eukaryota	460	8e-125	NTclustered	gi\|919031420\|ref\|XM_013543873.1\|	7574	g2972	i0	81.952	36.5519031141868	543	98	94	0	32	574	40	582	PREDICTED: Lingula anatina 40S ribosomal protein S7 (LOC106165617), mRNA	blastn	21127	460	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
18684455	18684455	PRJNA846110_P_NODE_5415_length_447_cov_19.334225_g5171_i0	PRJNA846110	5415	447	19.334225	86.42398575	Lingula anatina	7574	Brachiopoda	other_Eukaryota	309	2.33e-79	NTclustered	gi\|919057681\|ref\|XM_013555240.1\|	7574	g5171	i0	80.048	7.40715883668904	416	83	93	0	20	435	64	479	PREDICTED: Lingula anatina 60S ribosomal protein L26 (LOC106173908), mRNA	blastn	3311	309	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
22509770	22509770	PRJNA846110_P_NODE_11038_length_326_cov_1.905138_g10793_i0	PRJNA846110	11038	326	1.905138	6.21074988	Lingula anatina	7574	Brachiopoda	other_Eukaryota	156	2.27e-33	NTclustered	gi\|1351486682\|ref\|XM_013565156.2\|	7574	g10793	i0	81.726	12.3466257668712	197	26	59	9	127	318	1222	1031	PREDICTED: Lingula anatina uncharacterized LOC106180967 (LOC106180967), mRNA	blastn	4025	156	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
22510021	22510021	PRJNA846110_P_NODE_8338_length_366_cov_1.313993_g8094_i0	PRJNA846110	8338	366	1.313993	4.80921438	Lingula anatina	7574	Brachiopoda	other_Eukaryota	276	1.89e-69	NTclustered	gi\|919013608\|ref\|XM_013535856.1\|	7574	g8094	i0	85.13	27.6366120218579	269	40	73	0	6	274	1603	1871	PREDICTED: Lingula anatina protein Red (LOC106159548), mRNA	blastn	10115	276	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);;