metadata: contig_metadata: 12 rows where bioproject = "PRJNA380129" and tax

12 rows where bioproject = "PRJNA380129" 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
4902051	4902051	PRJNA380129_P_NODE_944_length_666_cov_0.822606_g639_i0	PRJNA380129	944	666	0.822606	5.47855596	Mus	10088	Chordata	Chordata	254	1.69e-62	NTclustered	gi\|1912481453\|gb\|MW054196.1\|	10090	g639	i0	99.286	45.990990990991	140	1	45	0	281	420	214	353	Mus musculus isolate Lead acetate + ZnCl2 large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	30630	254	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9330091	9330091	PRJNA380129_P_NODE_2588_length_371_cov_0.842105_g2264_i0	PRJNA380129	2588	371	0.842105	3.12420955	Mus musculus	10090	Chordata	Chordata	163	1.5599999999999998e-35	NTclustered	gi\|84662986\|gb\|AC166336.15\|	10090	g2264	i0	100	0.91644204851752	88	0	46	0	284	371	128681	128594	Mus musculus chromosome 1, clone RP24-74G12, complete sequence	blastn	340	163	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11880727	11880727	PRJNA380129_P_NODE_3530_length_180_cov_3.549669_g3206_i0	PRJNA380129	3530	180	3.549669	6.3894042	Mus musculus	10090	Chordata	Chordata	257	3.01e-64	NTclustered	gi\|41351640\|gb\|AC102902.6\|	10090	g3206	i0	100	1.05	139	0	100	0	1	139	20508	20370	Mus musculus chromosome 16, clone RP24-313G10, complete sequence	blastn	189	257	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13155738	13155738	PRJNA380129_P_NODE_3491_length_189_cov_4.631250_g3167_i0	PRJNA380129	3491	189	4.63125	8.7530625	Hynobius leechii	113391	Chordata	Chordata	87.9	4.45e-13	NTclustered	gi\|88660711\|gb\|DQ388468.1\|	113391	g3167	i0	87.838	2.66666666666667	74	9	39	0	60	133	428	355	Hynobius leechii isolate NK12-3 12S ribosomal RNA gene, partial sequence; mitochondrial	blastn	504	87.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Hynobiidae	Hynobius	Hynobius leechii
15101928	15101928	PRJNA380129_P_NODE_3652_length_159_cov_1.407692_g3328_i0	PRJNA380129	3652	159	1.407692	2.23823028	Mammalia	40674	Chordata	Chordata	67.6	4.7e-7	NTclustered	gi\|2587467638\|ref\|XM_060033335.1\|	9728	g3328	i0	100	22.6415094339623	36	0	23	0	124	159	1258	1293	PREDICTED: Delphinus delphis GNAS complex locus (GNAS), transcript variant X8, mRNA	blastn	3600	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Delphinus	Delphinus delphis
15704702	15704702	PRJNA380129_P_NODE_1573_length_449_cov_3.797619_g1250_i0	PRJNA380129	1573	449	3.797619	17.05130931	Mus musculus	10090	Chordata	Chordata	475	2.1799999999999993e-129	NTclustered	gi\|1907067910\|ref\|XM_006529281.5\|	10090	g1250	i0	99.617	70.5991091314031	261	0	100	1	189	449	1852	2111	PREDICTED: Mus musculus nuclear antigen Sp100 (Sp100), transcript variant X1, mRNA	blastn	31699	475	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16979348	16979348	PRJNA380129_P_NODE_3094_length_328_cov_4.648829_g2770_i0	PRJNA380129	3094	328	4.648829	15.24815912	Mus musculus	10090	Chordata	Chordata	569	6.889999999999998e-158	NTclustered	gi\|23497895\|emb\|AL671895.9\|	10090	g2770	i0	100	0.939024390243902	308	0	94	0	1	308	20154	19847	Mouse DNA sequence from clone RP23-342E4 on chromosome 4, complete sequence	blastn	308	569	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18253647	18253647	PRJNA380129_P_NODE_675_length_758_cov_1.731139_g381_i0	PRJNA380129	675	758	1.731139	13.12203362	Mus musculus	10090	Chordata	Chordata	499	2.2599999999999998e-136	NTclustered	gi\|56790333\|gb\|AC153618.4\|	10090	g381	i0	99.634	1.53825857519789	273	1	76	0	1	273	80350	80078	Mus musculus 6 BAC RP23-5O1 (Roswell Park Cancer Institute (C57BL/6J Female) Mouse BAC Library) complete sequence	blastn	1166	499	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20803483	20803483	PRJNA380129_P_NODE_3097_length_326_cov_3.774411_g2773_i0	PRJNA380129	3097	326	3.774411	12.30457986	Mus musculus	10090	Chordata	Chordata	507	5.44e-139	NTclustered	gi\|68268257\|gb\|AC153141.7\|	10090	g2773	i0	99.286	1.04601226993865	280	2	100	0	1	280	47291	47012	Mus musculus BAC clone RP23-268A17 from chromosome 10, complete sequence	blastn	341	507	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22078531	22078531	PRJNA380129_P_NODE_1638_length_438_cov_1.254279_g1315_i0	PRJNA380129	1638	438	1.254279	5.49374202	Mus musculus	10090	Chordata	Chordata	268	3.86e-67	NTclustered	gi\|45384729\|gb\|AC124377.4\|	10090	g1315	i0	100	1.19634703196347	145	0	60	0	294	438	76701	76845	Mus musculus BAC clone RP24-396N12 from chromosome 5, complete sequence	blastn	524	268	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22078535	22078535	PRJNA380129_P_NODE_3418_length_205_cov_1.823864_g3094_i0	PRJNA380129	3418	205	1.823864	3.7389212	Mus musculus	10090	Chordata	Chordata	285	1.6199999999999998e-72	NTclustered	gi\|56790465\|gb\|AC132443.3\|	10090	g3094	i0	100	15.2536585365854	154	0	98	0	47	200	146306	146459	Mus musculus BAC clone RP23-157C23 from 6, complete sequence	blastn	3127	285	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24628298	24628298	PRJNA380129_P_NODE_1840_length_413_cov_0.846354_g1516_i0	PRJNA380129	1840	413	0.846354	3.49544202	Mus musculus	10090	Chordata	Chordata	244	6.1e-60	NTclustered	gi\|354788330\|gb\|JN952831.1\|	10090	g1516	i0	100	2.00484261501211	132	0	50	0	1	132	26289	26420	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Ccdc11:tm1e(KOMP)Ucd; transgenic	blastn	828	244	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);;