metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1193541" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1193541" 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
320627	320627	PRJNA1193541_P_NODE_12781_length_249_cov_0.875000_g12643_i0	PRJNA1193541	12781	249	0.875	2.17875	Mus musculus	10090	Chordata	Chordata	460	3.16e-125	NTclustered	gi\|26185464\|emb\|AL671899.11\|	10090	g12643	i0	100	7.57028112449799	249	0	100	0	1	249	22762	22514	Mouse DNA sequence from clone RP23-27B23 on chromosome 3, complete sequence	blastn	1885	460	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4147471	4147471	PRJNA1193541_P_NODE_11924_length_252_cov_1.653631_g11786_i0	PRJNA1193541	11924	252	1.653631	4.16715012	Cairina moschata	8855	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2921976028\|gb\|CP130398.1\|	8855	g11786	i0	100	0.111111111111111	28	0	11	0	10	37	9382051	9382078	Cairina moschata breed yongchun chromosome 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Cairina	Cairina moschata
7420290	7420290	PRJNA1193541_P_NODE_12786_length_249_cov_0.875000_g12648_i0	PRJNA1193541	12786	249	0.875	2.17875	Polypteridae	8289	Chordata	Chordata	337	5.559999999999998e-88	NTclustered	gi\|2327554546\|ref\|XM_051932774.1\|	27687	g12648	i0	92.405	19.7791164658635	237	16	94	2	11	245	889	1125	PREDICTED: Erpetoichthys calabaricus E3 SUMO-protein ligase ZBED1-like (LOC127529397), mRNA	blastn	4925	340	0.991176470588235	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
8695403	8695403	PRJNA1193541_P_NODE_13487_length_246_cov_1.664740_g13349_i0	PRJNA1193541	13487	246	1.66474	4.0952604	Bos	9903	Chordata	Chordata	436	5.25e-118	NTclustered	gi\|2633822459\|ref\|XM_061404520.1\|	9906	g13349	i0	98.78	100	246	2	100	1	1	246	5687	5443	PREDICTED: Bos javanicus transforming acidic coiled-coil containing protein 1 (TACC1), transcript variant X10, mRNA	blastn	24600	436	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
8695404	8695404	PRJNA1193541_P_NODE_14227_length_244_cov_0.900585_g14089_i0	PRJNA1193541	14227	244	0.900585	2.1974274	Bos	9903	Chordata	Chordata	451	1.86e-122	NTclustered	gi\|2633843460\|ref\|XM_061411821.1\|	9906	g14089	i0	100	82.5204918032787	244	0	100	0	1	244	3483	3726	PREDICTED: Bos javanicus 24-dehydrocholesterol reductase (DHCR24), mRNA	blastn	20135	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
9248508	9248508	PRJNA1193541_P_NODE_13628_length_246_cov_0.890173_g13490_i0	PRJNA1193541	13628	246	0.890173	2.18982558	Canis lupus	9612	Chordata	Chordata	302	2e-77	NTclustered	gi\|35187712\|gb\|AY339973.1\|	9615	g13490	i0	89.627	11.5325203252033	241	19	97	4	4	242	1003	767	Canis familiaris clone 1 satellite sequence	blastn	2837	302	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
14349661	14349661	PRJNA1193541_P_NODE_14532_length_243_cov_0.905882_g14394_i0	PRJNA1193541	14532	243	0.905882	2.20129326	Canis lupus	9612	Chordata	Chordata	169	2.0799999999999997e-37	NTclustered	gi\|118344491\|gb\|AC186686.9\|	9615	g14394	i0	89.051	33.4609053497942	137	13	56	2	104	239	97799	97934	Canis Familiaris chromosome 31, clone XX-265A5, complete sequence	blastn	8131	169	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
15070116	15070116	PRJNA1193541_P_NODE_14292_length_244_cov_0.900585_g14154_i0	PRJNA1193541	14292	244	0.900585	2.1974274	Bovidae	9895	Chordata	Chordata	444	3.11e-120	NTclustered	gi\|148747483\|ref\|NM_174684.2\|	9913	g14154	i0	100	66.6229508196721	240	0	98	0	5	244	1904	1665	Bos taurus ATP synthase F1 subunit alpha (ATP5F1A), mRNA; nuclear gene for mitochondrial product	blastn	16256	444	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
16897658	16897658	PRJNA1193541_P_NODE_10394_length_274_cov_0.855721_g10256_i0	PRJNA1193541	10394	274	0.855721	2.34467554	Mus musculus	10090	Chordata	Chordata	52.8	0.025	NTclustered	gi\|354794436\|gb\|JN958937.1\|	10090	g10256	i0	100	0.204379562043796	28	0	10	0	208	235	12780	12807	Mus musculus targeted KO-first, conditional ready, lacZ-tagged mutant allele Prss38:tm1a(KOMP)Wtsi; transgenic	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18172225	18172225	PRJNA1193541_P_NODE_14775_length_242_cov_0.911243_g14637_i0	PRJNA1193541	14775	242	0.911243	2.20520806	Mus musculus	10090	Chordata	Chordata	448	2.3799999999999995e-121	NTclustered	gi\|74221061\|dbj\|AK156345.1\|	10090	g14637	i0	100	96.1157024793388	242	0	100	0	1	242	1434	1193	Mus musculus activated spleen cDNA, RIKEN full-length enriched library, clone:F830017G14 product:nuclear receptor coactivator 3, full insert sequence	blastn	23260	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20168677	20168677	PRJNA1193541_P_NODE_4816_length_382_cov_1.495146_g4678_i0	PRJNA1193541	4816	382	1.495146	5.71145772	Bovidae	9895	Chordata	Chordata	701	0	NTclustered	gi\|2633875230\|ref\|XM_061420457.1\|	9906	g4678	i0	99.738	88.738219895288	382	1	100	0	1	382	35	416	PREDICTED: Bos javanicus C-X-C motif chemokine 6 (LOC133249694), mRNA	blastn	33898	706	0.992917847025496	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
20721966	20721966	PRJNA1193541_P_NODE_14837_length_242_cov_0.911243_g14699_i0	PRJNA1193541	14837	242	0.911243	2.20520806	Mus musculus	10090	Chordata	Chordata	448	2.3799999999999995e-121	NTclustered	gi\|55774372\|gb\|AC112263.4\|	10090	g14699	i0	100	72.301652892562	242	0	100	0	1	242	86490	86731	Mus musculus BAC clone RP23-403P24 from 5, complete sequence	blastn	17497	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21997297	21997297	PRJNA1193541_P_NODE_12858_length_249_cov_0.875000_g12720_i0	PRJNA1193541	12858	249	0.875	2.17875	Mus musculus	10090	Chordata	Chordata	460	3.16e-125	NTclustered	gi\|45120398\|gb\|AC141888.4\|	10090	g12720	i0	100	8.66666666666667	249	0	100	0	1	249	100491	100243	Mus musculus BAC clone RP23-462H3 from chromosome 19, complete sequence	blastn	2158	460	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21997480	21997480	PRJNA1193541_P_NODE_8858_length_292_cov_1.159817_g8720_i0	PRJNA1193541	8858	292	1.159817	3.38666564	Bos indicus x Bos taurus	30522	Chordata	Chordata	540	4.74e-149	NTclustered	gi\|1542929076\|ref\|XM_027528309.1\|	30522	g8720	i0	100	80.4452054794521	292	0	100	0	1	292	1808	2099	PREDICTED: Bos indicus x Bos taurus eukaryotic translation initiation factor 4H (EIF4H), transcript variant X2, mRNA	blastn	23490	540	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos indicus x Bos taurus
23994519	23994519	PRJNA1193541_P_NODE_12459_length_250_cov_0.870056_g12321_i0	PRJNA1193541	12459	250	0.870056	2.17514	Bos	9903	Chordata	Chordata	457	4.1099999999999985e-124	NTclustered	gi\|2633747538\|ref\|XM_061384924.1\|	9906	g12321	i0	99.6	99.292	250	1	100	0	1	250	700	949	PREDICTED: Bos javanicus serine dehydratase (SDS), transcript variant X2, mRNA	blastn	24823	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus

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