metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA383995" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA383995" and tax_phylum = "Chordata"

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
405285	405285	PRJNA383995_P_NODE_18581_length_162_cov_0.876106_g18482_i0	PRJNA383995	18581	162	0.876106	1.41929172	Crocodylus palustris	184238	Chordata	Chordata	228	2.0899999999999995e-55	NTclustered	gi\|312233507\|ref\|NC_014706.1\|	184238	g18482	i0	92.453	47.5740740740741	159	12	98	0	1	159	9962	10120	Crocodylus palustris mitochondrion, complete genome	blastn	7707	228	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Crocodylidae	Crocodylus	Crocodylus palustris
4232404	4232404	PRJNA383995_P_NODE_8304_length_224_cov_1.165714_g8205_i0	PRJNA383995	8304	224	1.165714	2.61119936	Mus musculus	10090	Chordata	Chordata	60.2	1.19e-4	NTclustered	gi\|21536188\|gb\|AC112146.3\|	10090	g8205	i0	100	16.2321428571429	32	0	14	0	166	197	88757	88726	Mus musculus BAC clone RP23-101G11 from 12, complete sequence	blastn	3636	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9333358	9333358	PRJNA383995_P_NODE_5188_length_276_cov_1.418502_g5089_i0	PRJNA383995	5188	276	1.418502	3.91506552	Meleagris gallopavo	9103	Chordata	Chordata	63.9	1.17e-5	NTclustered	gi\|2721460880\|emb\|HG999685.4\|	9103	g5089	i0	91.304	1.9963768115942	46	4	17	0	76	121	5486429	5486384	Meleagris gallopavo genome assembly, chromosome: 5	blastn	551	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
11279018	11279018	PRJNA383995_P_NODE_5449_length_269_cov_4.090909_g5350_i0	PRJNA383995	5449	269	4.090909	11.00454521	Mammalia	40674	Chordata	Chordata	52.8	0.025	NTclustered	gi\|1191904021\|ref\|XR_002346681.1\|	9823	g5350	i0	100	0.20817843866171	28	0	10	0	61	88	249	276	PREDICTED: Sus scrofa uncharacterized LOC102161749 (LOC102161749), ncRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
12554435	12554435	PRJNA383995_P_NODE_16510_length_165_cov_0.879310_g16411_i0	PRJNA383995	16510	165	0.87931	1.4508615	Canis	9611	Chordata	Chordata	195	2.17e-45	NTclustered	gi\|134032097\|gb\|AC184825.7\|	9615	g16411	i0	95.122	627.157575757576	123	6	86	0	1	123	100772	100650	Canis Familiaris chromosome 24, clone XX-14L4, complete sequence	blastn	103481	195	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
13159004	13159004	PRJNA383995_P_NODE_2471_length_387_cov_0.745562_g2372_i0	PRJNA383995	2471	387	0.745562	2.88532494	Mus musculus	10090	Chordata	Chordata	704	0	NTclustered	gi\|282721923\|gb\|GQ850526.1\|	10090	g2372	i0	99.485	112.552971576227	388	1	100	1	1	387	1155	768	Mus musculus anti-human CD21 immunoglobulin heavy chain mRNA, complete cds	blastn	43558	704	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14434009	14434009	PRJNA383995_P_NODE_5892_length_260_cov_2.459716_g5793_i0	PRJNA383995	5892	260	2.459716	6.3952616	Cairina moschata	8855	Chordata	Chordata	52.8	0.024	NTclustered	gi\|2921976028\|gb\|CP130398.1\|	8855	g5793	i0	100	0.107692307692308	28	0	11	0	202	229	9382078	9382051	Cairina moschata breed yongchun chromosome 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Cairina	Cairina moschata
19531113	19531113	PRJNA383995_P_NODE_17156_length_164_cov_0.886957_g17057_i0	PRJNA383995	17156	164	0.886957	1.45460948	Crocodylus palustris	184238	Chordata	Chordata	292	7.41e-75	NTclustered	gi\|312233507\|ref\|NC_014706.1\|	184238	g17057	i0	98.78	72.9756097560976	164	2	100	0	1	164	507	344	Crocodylus palustris mitochondrion, complete genome	blastn	11968	292	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Crocodylidae	Crocodylus	Crocodylus palustris
20806855	20806855	PRJNA383995_P_NODE_14377_length_173_cov_1.612903_g14278_i0	PRJNA383995	14377	173	1.612903	2.79032219	Columba livia	8932	Chordata	Chordata	54.7	0.004	NTclustered	gi\|2728217565\|ref\|XM_065038787.1\|	8932	g14278	i0	100	0.335260115606936	29	0	17	0	100	128	2246	2274	PREDICTED: Columba livia synaptonemal complex protein 1 (SYCP1), transcript variant X8, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
23357303	23357303	PRJNA383995_P_NODE_11059_length_197_cov_1.797297_g10960_i0	PRJNA383995	11059	197	1.797297	3.54067509	Mus musculus	10090	Chordata	Chordata	56.5	0.001	NTclustered	gi\|15011724\|gb\|AC005302.70\|	10090	g10960	i0	96.97	2.14720812182741	33	1	17	0	52	84	86969	86937	Mus musculus strain 129S6/SvEvTac chromosome 10 clone rp21-481n4, complete sequence	blastn	423	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24631675	24631675	PRJNA383995_P_NODE_4240_length_302_cov_1.177866_g4141_i0	PRJNA383995	4240	302	1.177866	3.55715532	Apteryx mantelli	2696672	Chordata	Chordata	54.7	0.008	NTclustered	gi\|840016890\|emb\|LK066393.1\|	202946	g4141	i0	100	0.0960264900662252	29	0	10	0	185	213	207549	207577	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold1803	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli

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