metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA459724" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA459724" 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
2993728	2993728	PRJNA459724_S_NODE_2743_length_155_cov_4.841667_g2740_i0	PRJNA459724	2743	155	4.841667	7.50458385	Mus musculus	10090	Chordata	Chordata	239	9.11e-59	NTclustered	gi\|354788816\|gb\|JN953317.1\|	10090	g2740	i0	100	8.90967741935484	129	0	83	0	20	148	36811	36683	Mus musculus targeted KO-first, conditional ready, lacZ-tagged mutant allele Nfe2l3:tm1a(EUCOMM)Hmgu; transgenic	blastn	1381	239	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4270003	4270003	PRJNA459724_P_NODE_1764_length_419_cov_2.484615_g1394_i0	PRJNA459724	1764	419	2.484615	10.41053685	Mus musculus	10090	Chordata	Chordata	481	4.34e-131	NTclustered	gi\|1032033214\|gb\|KX121610.1\|	10090	g1394	i0	94.949	43.8568019093079	297	11	100	1	127	419	1128	832	Mus musculus clone contig 1 chromocenter region genomic sequence	blastn	18376	481	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4270010	4270010	PRJNA459724_S_NODE_1064_length_198_cov_1.214724_g1061_i0	PRJNA459724	1064	198	1.214724	2.40515352	Sus scrofa	9823	Chordata	Chordata	316	5.51e-82	NTclustered	gi\|300422385\|emb\|FP565766.8\|	9823	g1061	i0	99.425	0.878787878787879	174	1	88	0	17	190	117742	117569	Pig DNA sequence from clone CH242-130B8 on chromosome X, complete sequence	blastn	174	316	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
4270022	4270022	PRJNA459724_S_NODE_2104_length_166_cov_4.687023_g2101_i0	PRJNA459724	2104	166	4.687023	7.78045818	Gallus gallus	9031	Chordata	Chordata	169	1.32e-37	NTclustered	gi\|297306101\|dbj\|AB556462.1\|	9031	g2101	i0	85.802	13.2530120481928	162	20	97	3	5	165	576	417	Gallus gallus DNA, CENP-A associated sequence, partial sequence, clone: CAIP#159	blastn	2200	169	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
6820712	6820712	PRJNA459724_P_NODE_786_length_670_cov_2.218409_g542_i0	PRJNA459724	786	670	2.218409	14.8633403	Mus musculus	10090	Chordata	Chordata	414	7.39e-111	NTclustered	gi\|1032033214\|gb\|KX121610.1\|	10090	g542	i0	91.809	66.889552238806	293	11	93	1	131	410	3931	3639	Mus musculus clone contig 1 chromocenter region genomic sequence	blastn	44816	414	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6820728	6820728	PRJNA459724_S_NODE_2926_length_153_cov_1.822034_g2923_i0	PRJNA459724	2926	153	1.822034	2.78771202	Mirounga angustirostris	9716	Chordata	Chordata	93.5	7.38e-15	NTclustered	gi\|2721894472\|ref\|XR_006793547.3\|	9716	g2923	i0	85.263	8.9281045751634	95	8	59	5	58	148	5384	5476	PREDICTED: Mirounga angustirostris WT1 interacting protein (WTIP), transcript variant X2, misc_RNA	blastn	1366	93.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga angustirostris
7471950	7471950	PRJNA459724_S_NODE_306_length_257_cov_2.617117_g303_i0	PRJNA459724	306	257	2.617117	6.72599069	Rodentia	9989	Chordata	Chordata	124	4.8799999999999994e-24	NTclustered	gi\|2687688182\|ref\|XM_063257629.1\|	10141	g303	i0	83.212	3.17120622568093	137	21	53	2	17	152	757	892	PREDICTED: Cavia porcellus tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein zeta (Ywhaz), transcript variant X1, mRNA	blastn	815	124	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Caviidae	Cavia	Cavia porcellus
8096180	8096180	PRJNA459724_S_NODE_1507_length_180_cov_13.910345_g1504_i0	PRJNA459724	1507	180	13.910345	25.038621	Mus musculus	10090	Chordata	Chordata	309	8.21e-80	NTclustered	gi\|56177962\|gb\|AC113122.9\|	10090	g1504	i0	98.844	9.16666666666667	173	2	96	0	8	180	119750	119922	Mus musculus chromosome 8, clone RP23-349P4, complete sequence	blastn	1650	309	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10022253	10022253	PRJNA459724_P_NODE_3328_length_252_cov_70.775785_g2936_i0	PRJNA459724	3328	252	70.775785	178.3549782	root	1	Root_unresolved	Root_unresolved	372	1.54e-98	NTclustered	gi\|2904934840\|gb\|PQ737764.1\|	10090	g2936	i0	93.281	331.805555555556	253	16	100	1	1	252	93	345	Mus musculus lncRNA174 lncRNA, complete sequence	blastn	83615	372	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10646900	10646900	PRJNA459724_P_NODE_1949_length_390_cov_2.254848_g1566_i0	PRJNA459724	1949	390	2.254848	8.7939072	Mus musculus	10090	Chordata	Chordata	721	0	NTclustered	gi\|1032033214\|gb\|KX121610.1\|	10090	g1566	i0	100	40.6769230769231	390	0	100	0	1	390	2672	2283	Mus musculus clone contig 1 chromocenter region genomic sequence	blastn	15864	721	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10646913	10646913	PRJNA459724_S_NODE_1469_length_182_cov_1.523810_g1466_i0	PRJNA459724	1469	182	1.52381	2.7733342	Sus scrofa	9823	Chordata	Chordata	224	3.1e-54	NTclustered	gi\|168149179\|emb\|CU392844.6\|	9823	g1466	i0	92.949	29.5989010989011	156	7	85	4	27	180	176416	176569	Pig DNA sequence from clone CH242-399I22 on chromosome 7, complete sequence	blastn	5387	224	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
10646916	10646916	PRJNA459724_S_NODE_1649_length_176_cov_2.737589_g1646_i0	PRJNA459724	1649	176	2.737589	4.81815664	Sus scrofa	9823	Chordata	Chordata	137	3.98e-28	NTclustered	gi\|242380112\|emb\|CU855678.9\|	9823	g1646	i0	96.386	159.278409090909	83	3	47	0	1	83	161919	162001	Pig DNA sequence from clone CH242-77L7 on chromosome 2, complete sequence	blastn	28033	137	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
13196650	13196650	PRJNA459724_S_NODE_2891_length_153_cov_4.093220_g2888_i0	PRJNA459724	2891	153	4.09322	6.2626266	Sus scrofa	9823	Chordata	Chordata	84.2	4.44e-12	NTclustered	gi\|111153821\|emb\|CT827800.8\|	9823	g2888	i0	97.917	27.2222222222222	48	1	31	0	42	89	78024	78071	Pig DNA sequence from clone CH242-193M5 on chromosome 7, complete sequence	blastn	4165	84.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
15745707	15745707	PRJNA459724_P_NODE_4913_length_181_cov_2.644737_g4521_i0	PRJNA459724	4913	181	2.644737	4.78697397	Mus musculus	10090	Chordata	Chordata	335	1.36e-87	NTclustered	gi\|1032033214\|gb\|KX121610.1\|	10090	g4521	i0	100	41	181	0	100	0	1	181	1623	1803	Mus musculus clone contig 1 chromocenter region genomic sequence	blastn	7421	335	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15745717	15745717	PRJNA459724_S_NODE_1913_length_170_cov_4.666667_g1910_i0	PRJNA459724	1913	170	4.666667	7.9333339	Sus scrofa	9823	Chordata	Chordata	300	4.6e-77	NTclustered	gi\|166409160\|emb\|CU392841.11\|	9823	g1910	i0	100	3.67058823529412	162	0	95	0	9	170	94886	94725	Pig DNA sequence from clone CH242-278D24 on chromosome 6, complete sequence	blastn	624	300	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
18945490	18945490	PRJNA459724_S_NODE_2995_length_152_cov_2.068376_g2992_i0	PRJNA459724	2995	152	2.068376	3.14393152	Gallus	9030	Chordata	Chordata	248	1.48e-61	NTclustered	gi\|2028522877\|gb\|MT800350.1\|	9031	g2992	i0	99.27	90.1315789473684	137	1	90	0	3	139	14896	14760	Gallus gallus isolate 33917 mitochondrion, complete genome	blastn	13700	248	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
23395258	23395258	PRJNA459724_P_NODE_879_length_632_cov_2.311774_g618_i0	PRJNA459724	879	632	2.311774	14.61041168	Mus musculus	10090	Chordata	Chordata	667	0	NTclustered	gi\|2510669768\|gb\|OQ871509.1\|	10090	g618	i0	99.457	50.6772151898734	368	1	98	1	73	439	1915	2282	Mus musculus clone BAC 10_3 45S ribosomal RNA and 18S ribosomal RNA genes, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, 3' and 5' external transcribed spacers, complete sequence; and 18S ribosomal RNA gene, partial sequence	blastn	32028	667	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23395272	23395272	PRJNA459724_S_NODE_2559_length_158_cov_3.235772_g2556_i0	PRJNA459724	2559	158	3.235772	5.11251976	Canis lupus	9612	Chordata	Chordata	167	4.47e-37	NTclustered	gi\|48675429\|gb\|AC147708.7\|	9615	g2556	i0	90.551	107.677215189873	127	11	80	1	1	127	95918	95793	Canis Familiaris, clone XX-25G10, complete sequence	blastn	17013	167	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
24669181	24669181	PRJNA459724_S_NODE_1440_length_183_cov_2.574324_g1437_i0	PRJNA459724	1440	183	2.574324	4.71101292	Mirounga angustirostris	9716	Chordata	Chordata	147	6.949999999999999e-31	NTclustered	gi\|2721840479\|ref\|XR_010412510.1\|	9716	g1437	i0	89.256	64.7267759562842	121	7	64	6	65	181	457	339	PREDICTED: Mirounga angustirostris uncharacterized LOC135364785 (LOC135364785), transcript variant X1, ncRNA	blastn	11845	147	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga angustirostris
25320209	25320209	PRJNA459724_P_NODE_2240_length_347_cov_26.446541_g1852_i0	PRJNA459724	2240	347	26.446541	91.76949727	root	1	Root_unresolved	Root_unresolved	586	7.279999999999998e-163	NTclustered	gi\|2904934840\|gb\|PQ737764.1\|	10090	g1852	i0	97.406	351.146974063401	347	3	100	6	1	347	345	5	Mus musculus lncRNA174 lncRNA, complete sequence	blastn	121848	586	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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