metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA657860" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA657860" 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
1901627	1901627	PRJNA657860_P_NODE_2902_length_174_cov_1.116788_g2846_i0	PRJNA657860	2902	174	1.116788	1.94321112	Mus musculus	10090	Chordata	Chordata	322	1.01e-83	NTclustered	gi\|51921458\|gb\|AC131766.4\|	10090	g2846	i0	100	15.4022988505747	174	0	100	0	1	174	115431	115258	Mus musculus BAC clone RP24-240O7 from 6, complete sequence	blastn	2680	322	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3176330	3176330	PRJNA657860_P_NODE_3683_length_153_cov_0.991379_g3627_i0	PRJNA657860	3683	153	0.991379	1.51680987	Mus musculus	10090	Chordata	Chordata	283	4.0799999999999995e-72	NTclustered	gi\|1122816953\|gb\|AH005932.3\|	10090	g3627	i0	100	43.0718954248366	153	0	100	0	1	153	4941	5093	Mus musculus pigment epithelium-derived factor gene, complete cds	blastn	6590	283	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3176339	3176339	PRJNA657860_P_NODE_763_length_380_cov_1.373178_g707_i0	PRJNA657860	763	380	1.373178	5.2180764	Mus musculus	10090	Chordata	Chordata	697	0	NTclustered	gi\|26345181\|dbj\|AK076187.1\|	10090	g707	i0	99.737	24.8131578947368	380	1	100	0	1	380	893	514	Mus musculus 18 days pregnant adult female placenta and extra embryonic tissue cDNA, RIKEN full-length enriched library, clone:3830418K20 product:apolipoprotein A-I, full insert sequence	blastn	9429	697	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4453368	4453368	PRJNA657860_P_NODE_424_length_546_cov_2.206287_g369_i0	PRJNA657860	424	546	2.206287	12.04632702	Mus musculus	10090	Chordata	Chordata	953	0	NTclustered	gi\|38174656\|gb\|BC061176.1\|	10090	g369	i0	98.172	103.727106227106	547	9	100	1	1	546	1373	827	Mus musculus serine (or cysteine) peptidase inhibitor, clade A, member 1E, mRNA (cDNA clone MGC:74313 IMAGE:30381238), complete cds	blastn	56635	953	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10090006	10090006	PRJNA657860_P_NODE_188_length_869_cov_10.082933_g150_i0	PRJNA657860	188	869	10.082933	87.62068777	Mus	10088	Chordata	Chordata	1583	0	NTclustered	gi\|317008606\|ref\|NM_001199999.1\|	10090	g150	i0	99.54	91.102416570771	869	4	100	0	1	869	919	51	Mus musculus major urinary protein 14 (Mup14), mRNA	blastn	79168	1583	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10829672	10829672	PRJNA657860_P_NODE_189_length_869_cov_6.604567_g150_i1	PRJNA657860	189	869	6.604567	57.39368723	Mus musculus	10090	Chordata	Chordata	1389	0	NTclustered	gi\|1102627096\|ref\|NM_001347129.1\|	10090	g150	i1	95.533	90.1449942462601	873	32	100	7	1	869	117	986	Mus musculus major urinary protein 7 (Mup7), mRNA	blastn	78336	1389	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10829688	10829688	PRJNA657860_P_NODE_3309_length_162_cov_1.240000_g3253_i0	PRJNA657860	3309	162	1.24	2.0088	Mus musculus	10090	Chordata	Chordata	300	4.36e-77	NTclustered	gi\|123237658\|emb\|CU207406.7\|	10090	g3253	i0	100	99.9938271604938	162	0	100	0	1	162	56683	56522	Mouse DNA sequence from clone DN-169A20 on chromosome 4, complete sequence	blastn	16199	300	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
12104827	12104827	PRJNA657860_P_NODE_890_length_352_cov_2.374603_g834_i0	PRJNA657860	890	352	2.374603	8.35860256	Mus musculus	10090	Chordata	Chordata	651	0	NTclustered	gi\|563580282\|ref\|NM_001110009.2\|	10090	g834	i0	100	62.4545454545455	352	0	100	0	1	352	36	387	Mus musculus apolipoprotein C-I (Apoc1), transcript variant 2, mRNA	blastn	21984	651	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13379539	13379539	PRJNA657860_P_NODE_1571_length_257_cov_1.772727_g1515_i0	PRJNA657860	1571	257	1.772727	4.55590839	Mus musculus	10090	Chordata	Chordata	475	1.1699999999999999e-129	NTclustered	gi\|148747545\|ref\|NM_011458.2\|	10090	g1515	i0	100	15.9260700389105	257	0	100	0	1	257	1561	1305	Mus musculus serine (or cysteine) peptidase inhibitor, clade A, member 3K (Serpina3k), mRNA	blastn	4093	475	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13915402	13915402	PRJNA657860_P_NODE_3791_length_150_cov_1.628319_g3735_i0	PRJNA657860	3791	150	1.628319	2.4424785	Mus	10088	Chordata	Chordata	278	1.85e-70	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g3735	i0	100	100	150	0	100	0	1	150	147	296	Mus musculus strain ME mitochondrion, complete genome	blastn	15000	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13915408	13915408	PRJNA657860_P_NODE_911_length_348_cov_1.623794_g855_i0	PRJNA657860	911	348	1.623794	5.65080312	Mus	10088	Chordata	Chordata	638	1.99e-178	NTclustered	gi\|846387676\|dbj\|LC061971.1\|	10090	g855	i0	99.713	100	348	1	100	0	1	348	1733	1386	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_20	blastn	34800	638	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14654380	14654380	PRJNA657860_P_NODE_1852_length_229_cov_2.005208_g1796_i0	PRJNA657860	1852	229	2.005208	4.59192632	Mus musculus	10090	Chordata	Chordata	422	1.35e-113	NTclustered	gi\|59858560\|ref\|NM_001012323.1\|	10090	g1796	i0	100	128.973799126638	228	0	99	0	1	228	629	856	Mus musculus major urinary protein 20 (Mup20), mRNA	blastn	29535	422	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15189928	15189928	PRJNA657860_P_NODE_1992_length_217_cov_1.333333_g1936_i0	PRJNA657860	1992	217	1.333333	2.89333261	Mus	10088	Chordata	Chordata	396	7.689999999999997e-106	NTclustered	gi\|846388176\|dbj\|LC062059.1\|	10090	g1936	i0	99.539	100	217	1	100	0	1	217	467	251	Mus musculus mitochondrion DNA, including Cytb, tRNA-Tyr, tRNA-Pro, tRNA-Phe, 12S rRNA genes and D-loop, complete sequence, sequence_id: (14446..634)_12	blastn	21700	396	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15928360	15928360	PRJNA657860_P_NODE_173_length_909_cov_3.266055_g137_i0	PRJNA657860	173	909	3.266055	29.68843995	Mus musculus	10090	Chordata	Chordata	1679	0	NTclustered	gi\|19353305\|gb\|BC024643.1\|	10090	g137	i0	100	99.2024202420242	909	0	100	0	1	909	2007	1099	Mus musculus albumin, mRNA (cDNA clone MGC:27522 IMAGE:4242076), complete cds	blastn	90175	1679	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16464219	16464219	PRJNA657860_P_NODE_3653_length_154_cov_0.982906_g3597_i0	PRJNA657860	3653	154	0.982906	1.51367524	Mus	10088	Chordata	Chordata	279	5.33e-71	NTclustered	gi\|354795652\|gb\|JN960153.1\|	10090	g3597	i0	99.351	99.948051948052	154	1	100	0	1	154	10055	10208	Mus musculus targeted deletion, lacZ-tagged mutant allele Apoc1:tm1(KOMP)Ucd; transgenic	blastn	15392	279	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18477760	18477760	PRJNA657860_P_NODE_595_length_452_cov_2.734940_g539_i0	PRJNA657860	595	452	2.73494	12.3619288	Mus musculus	10090	Chordata	Chordata	835	0	NTclustered	gi\|157951675\|ref\|NM_013474.2\|	10090	g539	i0	100	57.6858407079646	452	0	100	0	1	452	50	501	Mus musculus apolipoprotein A-II (Apoa2), transcript variant 1, mRNA	blastn	26074	835	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19012925	19012925	PRJNA657860_P_NODE_1435_length_271_cov_1.858974_g1379_i0	PRJNA657860	1435	271	1.858974	5.03781954	Mus	10088	Chordata	Chordata	459	1.2499999999999999e-124	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g1379	i0	99.602	102.952029520295	251	1	100	0	21	271	2587	2337	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	27900	459	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19012934	19012934	PRJNA657860_P_NODE_3715_length_152_cov_1.330435_g3659_i0	PRJNA657860	3715	152	1.330435	2.0222612	Mus	10088	Chordata	Chordata	281	1.46e-71	NTclustered	gi\|1039767080\|ref\|XM_011240477.2\|	10090	g3659	i0	100	36.7302631578947	152	0	100	0	1	152	1896	2047	PREDICTED: Mus musculus sterol carrier protein 2, liver (Scp2), transcript variant X1, mRNA	blastn	5583	281	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21563363	21563363	PRJNA657860_P_NODE_677_length_412_cov_2.042667_g621_i0	PRJNA657860	677	412	2.042667	8.41578804	Mus	10088	Chordata	Chordata	761	0	NTclustered	gi\|354795652\|gb\|JN960153.1\|	10090	g621	i0	100	98.5218446601942	412	0	100	0	1	412	10762	10351	Mus musculus targeted deletion, lacZ-tagged mutant allele Apoc1:tm1(KOMP)Ucd; transgenic	blastn	40591	761	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22302708	22302708	PRJNA657860_P_NODE_1298_length_287_cov_1.080000_g1242_i0	PRJNA657860	1298	287	1.08	3.0996	Mus musculus	10090	Chordata	Chordata	531	2.799999999999999e-146	NTclustered	gi\|1345670184\|ref\|NM_017399.5\|	10090	g1242	i0	100	88.1951219512195	287	0	100	0	1	287	171	457	Mus musculus fatty acid binding protein 1, liver (Fabp1), mRNA	blastn	25312	531	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22302717	22302717	PRJNA657860_P_NODE_1878_length_227_cov_1.384211_g1822_i0	PRJNA657860	1878	227	1.384211	3.14215897	Mus musculus	10090	Chordata	Chordata	420	4.81e-113	NTclustered	gi\|118129942\|ref\|NM_133977.2\|	10090	g1822	i0	100	36.6828193832599	227	0	100	0	1	227	2305	2079	Mus musculus transferrin (Trf), mRNA	blastn	8327	420	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22302741	22302741	PRJNA657860_P_NODE_3718_length_152_cov_1.330435_g3662_i0	PRJNA657860	3718	152	1.330435	2.0222612	Mus musculus	10090	Chordata	Chordata	281	1.46e-71	NTclustered	gi\|194425627\|gb\|EU882234.1\|	10090	g3662	i0	100	95.25	152	0	100	0	1	152	289	138	Mus musculus major urinary protein 24 mRNA, complete cds	blastn	14478	281	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22838806	22838806	PRJNA657860_P_NODE_2498_length_189_cov_1.743421_g2442_i0	PRJNA657860	2498	189	1.743421	3.29506569	Mus	10088	Chordata	Chordata	350	5.14e-92	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g2442	i0	100	100	189	0	100	0	1	189	833	1021	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	18900	350	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23578114	23578114	PRJNA657860_P_NODE_679_length_412_cov_1.637333_g623_i0	PRJNA657860	679	412	1.637333	6.74581196	Mus musculus	10090	Chordata	Chordata	760	0	NTclustered	gi\|12858540\|dbj\|AK018701.1\|	10090	g623	i0	100	99.7572815533981	411	0	99	0	1	411	145	555	Mus musculus adult male kidney cDNA, RIKEN full-length enriched library, clone:0610005C23 product:TRANSTHYRETIN PRECURSOR (PREALBUMIN), full insert sequence	blastn	41100	760	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);;