metadata: contig_metadata: 11 rows where bioproject = "PRJNA1047321" and tax

11 rows where bioproject = "PRJNA1047321" 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
174452	174452	PRJNA1047321_P_NODE_6181_length_256_cov_1.486339_g6010_i0	PRJNA1047321	6181	256	1.486339	3.80502784	Sus scrofa	9823	Chordata	Chordata	394	3.36e-105	NTclustered	gi\|509046\|emb\|X70941.1\|	9823	g6010	i0	98.649	21.375	222	3	99	0	32	253	313	92	S.scrofa DNA for centromere specific motif	blastn	5472	394	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
1449130	1449130	PRJNA1047321_P_NODE_6902_length_249_cov_0.875000_g6731_i0	PRJNA1047321	6902	249	0.875	2.17875	Sus scrofa	9823	Chordata	Chordata	379	9.1e-101	NTclustered	gi\|1191881272\|ref\|XM_005664093.3\|	9823	g6731	i0	98.598	1.29718875502008	214	3	86	0	36	249	2761	2548	PREDICTED: Sus scrofa solute carrier family 6 member 13 (SLC6A13), mRNA	blastn	323	379	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
7827053	7827053	PRJNA1047321_P_NODE_5987_length_260_cov_1.561497_g5816_i0	PRJNA1047321	5987	260	1.561497	4.0598922	Sus scrofa	9823	Chordata	Chordata	252	2.18e-62	NTclustered	gi\|331703000\|emb\|CU914767.8\|	9823	g5816	i0	93.529	76.2461538461538	170	9	65	1	1	168	57577	57408	Pig DNA sequence from clone CH242-38E23 on chromosome X, complete sequence	blastn	19824	252	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
10377723	10377723	PRJNA1047321_P_NODE_8389_length_242_cov_0.911243_g8218_i0	PRJNA1047321	8389	242	0.911243	2.20520806	Sus scrofa	9823	Chordata	Chordata	438	1.4299999999999999e-118	NTclustered	gi\|237874106\|emb\|CU207383.6\|	9823	g8218	i0	99.583	0.991735537190083	240	1	99	0	3	242	4464	4703	Pig DNA sequence from clone CH242-506C13 on chromosome X, complete sequence	blastn	240	438	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
14203094	14203094	PRJNA1047321_P_NODE_1912_length_494_cov_3.451306_g1744_i0	PRJNA1047321	1912	494	3.451306	17.04945164	Mus musculus	10090	Chordata	Chordata	52.8	0.048	NTclustered	gi\|60279846\|gb\|AC147513.16\|	10090	g1744	i0	100	0.11336032388664	28	0	6	0	14	41	132161	132188	Mus musculus chromosome 1, clone RP23-105K16, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14203136	14203136	PRJNA1047321_P_NODE_7112_length_248_cov_0.880000_g6941_i0	PRJNA1047321	7112	248	0.88	2.1824	Sus scrofa	9823	Chordata	Chordata	167	7.679999999999999e-37	NTclustered	gi\|254746260\|emb\|FP015883.12\|	9823	g6941	i0	80.444	18.4314516129032	225	39	89	2	1	221	196689	196912	Pig DNA sequence from clone CH242-13O19 on chromosome X, complete sequence	blastn	4571	167	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
21851282	21851282	PRJNA1047321_P_NODE_4798_length_291_cov_1.412844_g4627_i0	PRJNA1047321	4798	291	1.412844	4.11137604	Sus scrofa	9823	Chordata	Chordata	472	1.75e-128	NTclustered	gi\|165931764\|emb\|AM932491.1\|	9823	g4627	i0	99.234	51.3642611683849	261	2	90	0	1	261	245	505	Sus scrofa centromeric satellite repeat, clone Pg9	blastn	14947	472	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
25236121	25236121	PRJNA1047321_P_NODE_7600_length_246_cov_0.890173_g7429_i0	PRJNA1047321	7600	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	189	1.62e-43	NTclustered	gi\|77622039\|emb\|CR762083.2\|	8364	g7429	i0	81.579	18.8861788617886	228	42	93	0	1	228	183	410	Xenopus tropicalis finished cDNA, clone TEgg025l04	blastn	4646	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
28614359	28614359	PRJNA1047321_P_NODE_8167_length_243_cov_0.905882_g7996_i0	PRJNA1047321	8167	243	0.905882	2.20129326	Physeter macrocephalus	9755	Chordata	Chordata	42.4	0.0488	NR	XP_054936518.1	9755	g7996	i0	51.2	1.06172839506173	43	19	53.1	1	17	145	7	47	XP_054936518.1 transcobalamin-2 isoform X3 [Physeter macrocephalus]	diamond	258	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Physeteridae	Physeter	Physeter macrocephalus
29056507	29056507	PRJNA1047321_P_NODE_7828_length_245_cov_0.895349_g7657_i0	PRJNA1047321	7828	245	0.895349	2.19360505	Polypterus senegalus	55291	Chordata	Chordata	107	1.45e-25	NR	KAG2455236.1	55291	g7657	i0	58	6.94285714285714	81	34	99.2	0	3	245	207	287	KAG2455236.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	1701	107	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32248548	32248548	PRJNA1047321_P_NODE_8398_length_242_cov_0.911243_g8227_i0	PRJNA1047321	8398	242	0.911243	2.20520806	Ambystoma mexicanum	8296	Chordata	Chordata	56.2	6.24e-7	NR	XP_069494769.1	8296	g8227	i0	48.6	3.84297520661157	72	27	76.9	1	240	55	239	310	XP_069494769.1 protein farnesyltransferase subunit beta [Ambystoma mexicanum]	diamond	930	56.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Ambystomatidae	Ambystoma	Ambystoma mexicanum

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