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

10 rows where analysis = "blastn", bioproject = "PRJNA1113956" 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
3574289	3574289	PRJNA1113956_P_NODE_14443_length_327_cov_1.818898_g14103_i0	PRJNA1113956	14443	327	1.818898	5.94779646	root	1	Root_unresolved	Root_unresolved	505	1.9599999999999995e-138	NTclustered	gi\|372282852\|emb\|FO081860.4\|	9823	g14103	i0	94.495	26.2691131498471	327	18	100	0	1	327	28839	28513	Pig DNA sequence from clone WTSI_1061-33H9 on chromosome Y, complete sequence	blastn	8590	510	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
4851731	4851731	PRJNA1113956_P_NODE_12564_length_365_cov_1.318493_g12224_i0	PRJNA1113956	12564	365	1.318493	4.81249945	root	1	Root_unresolved	Root_unresolved	647	0	NTclustered	gi\|372282852\|emb\|FO081860.4\|	9823	g12224	i0	98.63	40.4657534246575	365	5	100	0	1	365	18513	18877	Pig DNA sequence from clone WTSI_1061-33H9 on chromosome Y, complete sequence	blastn	14770	652	0.992331288343558	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
7874838	7874838	PRJNA1113956_P_NODE_2027_length_1304_cov_1.965069_g1861_i0	PRJNA1113956	2027	1304	1.965069	25.62449976	Jaculus jaculus	51337	Chordata	Chordata	58.4	0.003	NTclustered	gi\|2147835963\|ref\|XM_045149547.1\|	51337	g1861	i0	100	0.11579754601227	31	0	2	0	406	436	2459	2489	PREDICTED: Jaculus jaculus zinc finger protein 585A-like (LOC101599479), transcript variant X1, mRNA	blastn	151	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Dipodidae	Jaculus	Jaculus jaculus
7874852	7874852	PRJNA1113956_P_NODE_20887_length_247_cov_0.885057_g20547_i0	PRJNA1113956	20887	247	0.885057	2.18609079	Mus musculus	10090	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|12805196\|gb\|BC002057.1\|	10090	g20547	i0	100	99.3076923076923	247	0	100	0	1	247	713	467	Mus musculus glutamate oxaloacetate transaminase 1, soluble, mRNA (cDNA clone MGC:6100 IMAGE:3489628), complete cds	blastn	24529	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9952032	9952032	PRJNA1113956_P_NODE_18128_length_271_cov_1.550505_g17788_i0	PRJNA1113956	18128	271	1.550505	4.20186855	Mus	10088	Chordata	Chordata	496	9.55e-136	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g17788	i0	99.631	100	271	1	100	0	1	271	904	634	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	27100	496	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14250828	14250828	PRJNA1113956_P_NODE_12012_length_379_cov_2.349673_g11672_i0	PRJNA1113956	12012	379	2.349673	8.90526067	Mus musculus	10090	Chordata	Chordata	56.5	0.003	NTclustered	gi\|354798862\|gb\|JN963363.1\|	10090	g11672	i0	94.595	0.390501319261214	37	1	9	1	33	68	11653	11689	Mus musculus targeted KO-first, conditional ready, lacZ-tagged mutant allele Agxt2:tm1a(KOMP)Wtsi; transgenic	blastn	148	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19347808	19347808	PRJNA1113956_P_NODE_13236_length_350_cov_0.884477_g12896_i0	PRJNA1113956	13236	350	0.884477	3.0956695	Dipodomys ordii	10020	Chordata	Chordata	58.4	7.11e-4	NTclustered	gi\|852795299\|ref\|XM_013032174.1\|	10020	g12896	i0	100	0.265714285714286	31	0	9	0	155	185	3649	3619	PREDICTED: Dipodomys ordii midline 1 (Mid1), transcript variant X1, mRNA	blastn	93	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Heteromyidae	Dipodomys	Dipodomys ordii
20150385	20150385	PRJNA1113956_P_NODE_5836_length_685_cov_2.032680_g5520_i0	PRJNA1113956	5836	685	2.03268	13.923858	Lacertidae	8522	Chordata	Chordata	67.6	2.44e-6	NTclustered	gi\|2596053312\|ref\|XM_060271217.1\|	8524	g5520	i0	90.196	1.15620437956204	51	5	7	0	322	372	603	653	PREDICTED: Zootoca vivipara G protein nucleolar 1 (putative) (GNL1), mRNA	blastn	792	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Zootoca	Zootoca vivipara
20623012	20623012	PRJNA1113956_P_NODE_11837_length_384_cov_1.485531_g11497_i0	PRJNA1113956	11837	384	1.485531	5.70443904	Erpetoichthys calabaricus	27687	Chordata	Chordata	616	1.04e-171	NTclustered	gi\|2327563818\|ref\|XM_051935385.1\|	27687	g11497	i0	95.573	36.09375	384	17	100	0	1	384	1264	881	PREDICTED: Erpetoichthys calabaricus tigger transposable element-derived protein 1-like (LOC127529964), mRNA	blastn	13860	616	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
21898832	21898832	PRJNA1113956_P_NODE_16278_length_297_cov_1.348214_g15938_i0	PRJNA1113956	16278	297	1.348214	4.00419558	Fringilla coelebs	37598	Chordata	Chordata	52.8	0.028	NTclustered	gi\|2917617555\|emb\|OZ228698.1\|	37598	g15938	i0	100	0.0942760942760943	28	0	9	0	3	30	19166294	19166267	Fringilla coelebs genome assembly, chromosome: 11	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs

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