metadata: contig_metadata: 26 rows where bioproject = "PRJNA505837" and tax

26 rows where bioproject = "PRJNA505837" 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
483635	483635	PRJNA505837_S_NODE_341_length_249_cov_3.768182_g326_i0	PRJNA505837	341	249	3.768182	9.38277318	Mus musculus	10090	Chordata	Chordata	460	3.16e-125	NTclustered	gi\|21752834\|dbj\|AK093885.1\|	10090	g326	i0	100	83.1566265060241	249	0	100	0	1	249	1898	1650	Mus musculus cDNA fis, clone TRACH2010218, highly similar to CATHEPSIN D PRECURSOR (EC 3.4.23.5)	blastn	20706	460	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1110492	1110492	PRJNA505837_S_NODE_741_length_171_cov_3.521127_g726_i0	PRJNA505837	741	171	3.521127	6.02112717	Mus	10088	Chordata	Chordata	316	4.6e-82	NTclustered	gi\|56022177\|dbj\|AK198000.1\|	10090	g726	i0	100	99.280701754386	171	0	100	0	1	171	171	341	Mus musculus cDNA, clone:Y1G0126M24, strand:minus, reference:ENSEMBL:Mouse-Transcript-ENST:ENSMUST00000006235, based on BLAT search	blastn	16977	316	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1758800	1758800	PRJNA505837_S_NODE_1002_length_150_cov_4.057851_g987_i0	PRJNA505837	1002	150	4.057851	6.0867765	Mus musculus	10090	Chordata	Chordata	278	1.85e-70	NTclustered	gi\|74225281\|dbj\|AK152892.1\|	10090	g987	i0	100	82.2866666666667	150	0	100	0	1	150	1145	996	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830089I05 product:cathepsin D, full insert sequence	blastn	12343	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3661734	3661734	PRJNA505837_S_NODE_723_length_173_cov_2.444444_g708_i0	PRJNA505837	723	173	2.444444	4.22888812	Mus	10088	Chordata	Chordata	320	3.61e-83	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g708	i0	100	100	173	0	100	0	1	173	3095	2923	Mus musculus strain ME mitochondrion, complete genome	blastn	17300	320	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3661735	3661735	PRJNA505837_S_NODE_923_length_155_cov_4.134921_g908_i0	PRJNA505837	923	155	4.134921	6.40912755	Mus	10088	Chordata	Chordata	287	3.21e-73	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g908	i0	100	100	155	0	100	0	1	155	1307	1153	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	15500	287	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4310620	4310620	PRJNA505837_S_NODE_464_length_211_cov_3.148352_g449_i0	PRJNA505837	464	211	3.148352	6.64302272	Mus musculus	10090	Chordata	Chordata	390	3.459999999999999e-104	NTclustered	gi\|74140001\|dbj\|AK153244.1\|	10090	g449	i0	100	19.8293838862559	211	0	100	0	1	211	1003	1213	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830129D19 product:lysozyme, full insert sequence	blastn	4184	390	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4310622	4310622	PRJNA505837_S_NODE_524_length_199_cov_2.194118_g509_i0	PRJNA505837	524	199	2.194118	4.36629482	Mus musculus	10090	Chordata	Chordata	368	1.51e-97	NTclustered	gi\|74140001\|dbj\|AK153244.1\|	10090	g509	i0	100	99.0804020100502	199	0	100	0	1	199	290	92	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830129D19 product:lysozyme, full insert sequence	blastn	19717	368	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8763488	8763488	PRJNA505837_S_NODE_147_length_359_cov_3.957576_g132_i0	PRJNA505837	147	359	3.957576	14.20769784	Mus	10088	Chordata	Chordata	662	0	NTclustered	gi\|74191260\|dbj\|AK167361.1\|	10090	g132	i0	100	69.2172701949861	358	0	99	0	1	358	148	505	Mus musculus 14 days pregnant adult female placenta cDNA, RIKEN full-length enriched library, clone:I530008K10 product:cathepsin B, full insert sequence	blastn	24849	662	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9411795	9411795	PRJNA505837_S_NODE_768_length_169_cov_3.392857_g753_i0	PRJNA505837	768	169	3.392857	5.73392833	Mus musculus	10090	Chordata	Chordata	313	5.859999999999999e-81	NTclustered	gi\|74221241\|dbj\|AK170912.1\|	10090	g753	i0	100	100.005917159763	169	0	100	0	1	169	1052	884	Mus musculus NOD-derived CD11c +ve dendritic cells cDNA, RIKEN full-length enriched library, clone:F630209G10 product:Warning: possibly chimeric clone, full insert sequence	blastn	16901	313	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10039009	10039009	PRJNA505837_S_NODE_1008_length_150_cov_2.727273_g993_i0	PRJNA505837	1008	150	2.727273	4.0909095	Mus	10088	Chordata	Chordata	278	1.85e-70	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g993	i0	100	100	150	0	100	0	1	150	11374	11225	Mus musculus strain ME mitochondrion, complete genome	blastn	15000	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10687433	10687433	PRJNA505837_S_NODE_109_length_398_cov_4.124661_g94_i0	PRJNA505837	109	398	4.124661	16.41615078	Mus musculus	10090	Chordata	Chordata	736	0	NTclustered	gi\|50596\|emb\|X54966.1\|	10090	g94	i0	100	39.6884422110553	398	0	100	0	1	398	478	81	M.musculus ctsB gene (3' end) for cathepsin B	blastn	15796	736	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11313660	11313660	PRJNA505837_S_NODE_1009_length_150_cov_2.669421_g994_i0	PRJNA505837	1009	150	2.669421	4.0041315	Mus	10088	Chordata	Chordata	278	1.85e-70	NTclustered	gi\|2746383783\|gb\|PP914380.1\|	10090	g994	i0	100	100	150	0	100	0	1	150	844	993	Mus musculus isolate SK2917 cytochrome b (CYTB) gene, partial cds; mitochondrial	blastn	15000	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11962465	11962465	PRJNA505837_S_NODE_990_length_151_cov_3.319672_g975_i0	PRJNA505837	990	151	3.319672	5.01270472	Mus musculus	10090	Chordata	Chordata	272	8.689999999999998e-69	NTclustered	gi\|56029756\|dbj\|AK205579.1\|	10090	g975	i0	99.333	99.6887417218543	150	1	99	0	1	150	91	240	Mus musculus cDNA, clone:Y2G0102C16, strand:plus, reference:ENSEMBL:Mouse-Transcript-ENST:ENSMUST00000056887, based on BLAT search	blastn	15053	272	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13237593	13237593	PRJNA505837_S_NODE_291_length_266_cov_3.016878_g276_i0	PRJNA505837	291	266	3.016878	8.02489548	Mus musculus	10090	Chordata	Chordata	492	1.2099999999999999e-134	NTclustered	gi\|74225281\|dbj\|AK152892.1\|	10090	g276	i0	100	83.3684210526316	266	0	100	0	1	266	366	101	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830089I05 product:cathepsin D, full insert sequence	blastn	22176	492	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13864261	13864261	PRJNA505837_S_NODE_631_length_183_cov_2.422078_g616_i0	PRJNA505837	631	183	2.422078	4.43240274	root	1	Root_unresolved	Root_unresolved	337	3.84e-88	NTclustered	gi\|25045358\|emb\|AL833787.8\|	10090	g616	i0	100	98.1639344262295	182	0	99	0	2	183	152505	152686	Mouse DNA sequence from clone RP23-228E2 on chromosome 2, complete sequence	blastn	17964	337	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13864262	13864262	PRJNA505837_S_NODE_91_length_424_cov_3.326582_g76_i0	PRJNA505837	91	424	3.326582	14.10470768	Mus	10088	Chordata	Chordata	784	0	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g76	i0	100	100	424	0	100	0	1	424	611	1034	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	42400	784	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15138521	15138521	PRJNA505837_S_NODE_192_length_321_cov_3.948630_g177_i0	PRJNA505837	192	321	3.94863	12.6751023	Chordata	7711	Chordata	Chordata	593	3.9899999999999986e-165	NTclustered	gi\|74225281\|dbj\|AK152892.1\|	10090	g177	i0	100	99.1682242990654	321	0	100	0	1	321	759	439	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830089I05 product:cathepsin D, full insert sequence	blastn	31833	593	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15138524	15138524	PRJNA505837_S_NODE_972_length_152_cov_2.617886_g957_i0	PRJNA505837	972	152	2.617886	3.97918672	Mus	10088	Chordata	Chordata	281	1.46e-71	NTclustered	gi\|1679810813\|ref\|XM_021173591.2\|	10089	g957	i0	100	99.9868421052632	152	0	100	0	1	152	2436	2587	PREDICTED: Mus caroli prosaposin (Psap), transcript variant X3, mRNA	blastn	15198	281	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
15786394	15786394	PRJNA505837_S_NODE_853_length_161_cov_4.484848_g838_i0	PRJNA505837	853	161	4.484848	7.22060528	Mus musculus	10090	Chordata	Chordata	292	7.24e-75	NTclustered	gi\|12832103\|dbj\|AK002253.1\|	10090	g838	i0	99.379	99.9565217391304	161	1	100	0	1	161	475	635	Mus musculus adult male kidney cDNA, RIKEN full-length enriched library, clone:0610006K08 product:ferritin light chain 1, full insert sequence	blastn	16093	292	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16413177	16413177	PRJNA505837_S_NODE_433_length_220_cov_4.303665_g418_i0	PRJNA505837	433	220	4.303665	9.468063	Mus	10088	Chordata	Chordata	407	3.61e-109	NTclustered	gi\|118200683\|gb\|EF108335.1\|	10090	g418	i0	100	100	220	0	100	0	1	220	9135	9354	Mus musculus strain C3H/HeJ mitochondrion, complete genome	blastn	22000	407	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18335375	18335375	PRJNA505837_S_NODE_215_length_306_cov_4.299639_g200_i0	PRJNA505837	215	306	4.299639	13.15689534	Mus musculus	10090	Chordata	Chordata	558	1.38e-154	NTclustered	gi\|74223090\|dbj\|AK168866.1\|	10090	g200	i0	99.673	99.8039215686274	306	0	100	1	1	306	922	618	Mus musculus 17 days embryo kidney cDNA, RIKEN full-length enriched library, clone:I920061M18 product:ferritin light chain 1, full insert sequence	blastn	30540	558	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19609680	19609680	PRJNA505837_S_NODE_616_length_185_cov_2.711538_g601_i0	PRJNA505837	616	185	2.711538	5.0163453	Mus musculus	10090	Chordata	Chordata	340	3.0099999999999993e-89	NTclustered	gi\|74225281\|dbj\|AK152892.1\|	10090	g601	i0	100	84.6162162162162	184	0	99	0	2	185	1422	1239	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830089I05 product:cathepsin D, full insert sequence	blastn	15654	340	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20236942	20236942	PRJNA505837_S_NODE_336_length_251_cov_4.324324_g321_i0	PRJNA505837	336	251	4.324324	10.85405324	Mus	10088	Chordata	Chordata	464	2.47e-126	NTclustered	gi\|846387457\|dbj\|LC061936.1\|	10090	g321	i0	100	100	251	0	100	0	1	251	1718	1968	Mus musculus mitochondrion DNA, including ND2, tRNA-Trp, tRNA-Ala, tRNA-Asn, tRNA-Cys, tRNA-Tyr, COX1 genes, complete sequence, sequence_id: (4078..6548)_6	blastn	25100	464	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21512451	21512451	PRJNA505837_S_NODE_757_length_170_cov_3.609929_g742_i0	PRJNA505837	757	170	3.609929	6.1368793	Mus	10088	Chordata	Chordata	315	1.64e-81	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g742	i0	100	100	170	0	100	0	1	170	197	366	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	17000	315	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23436140	23436140	PRJNA505837_S_NODE_999_length_150_cov_4.834711_g984_i0	PRJNA505837	999	150	4.834711	7.2520665	Mus musculus	10090	Chordata	Chordata	278	1.85e-70	NTclustered	gi\|56037980\|dbj\|AK213803.1\|	10090	g984	i0	100	98.28	150	0	100	0	1	150	184	35	Mus musculus cDNA, clone:Y2G0129J01, strand:minus, reference:ENSEMBL:Mouse-Transcript-ENST:ENSMUST00000066401, based on BLAT search	blastn	14742	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24062427	24062427	PRJNA505837_S_NODE_39_length_641_cov_4.464052_g32_i0	PRJNA505837	39	641	4.464052	28.61457332	Mus	10088	Chordata	Chordata	1184	0	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g32	i0	100	100	641	0	100	0	1	641	1866	2506	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	64100	1184	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);;