metadata: contig_metadata: 16 rows where bioproject = "PRJDB12134" and tax

16 rows where bioproject = "PRJDB12134" 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
1274218	1274218	PRJDB12134_P_NODE_10462_length_282_cov_1.440191_g10327_i0	PRJDB12134	10462	282	1.440191	4.06133862	Cairina moschata	8855	Chordata	Chordata	466	7.84e-127	NTclustered	gi\|2921976050\|gb\|CP130419.1\|	8855	g10327	i0	96.454	1.87943262411348	282	10	100	0	1	282	37976401	37976682	Cairina moschata breed yongchun chromosome 4	blastn	530	466	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Cairina	Cairina moschata
5102396	5102396	PRJDB12134_P_NODE_10385_length_283_cov_1.695238_g10250_i0	PRJDB12134	10385	283	1.695238	4.79752354	Mus musculus	10090	Chordata	Chordata	523	4.5999999999999983e-144	NTclustered	gi\|68300498\|gb\|AC155719.11\|	10090	g10250	i0	100	38.5724381625442	283	0	100	0	1	283	117442	117160	Mus musculus 6 BAC RP24-236K6 (Roswell Park Cancer Institute (C57BL/6J Male) Mouse BAC Library) complete sequence	blastn	10916	523	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6083803	6083803	PRJDB12134_P_NODE_13525_length_246_cov_2.502890_g13390_i0	PRJDB12134	13525	246	2.50289	6.1571094	Metazoa	33208	Chordata	Chordata	58.4	4.78e-4	NTclustered	gi\|1889973078\|ref\|XM_035821810.1\|	7739	g13390	i0	100	13.9024390243902	31	0	13	0	176	206	381	411	PREDICTED: Branchiostoma floridae tripartite motif-containing protein 3-like (LOC118416642), mRNA	blastn	3420	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma floridae
7652253	7652253	PRJDB12134_P_NODE_10407_length_283_cov_1.214286_g10272_i0	PRJDB12134	10407	283	1.214286	3.43642938	Mus musculus	10090	Chordata	Chordata	518	2.14e-142	NTclustered	gi\|31194052\|gb\|AC127363.3\|	10090	g10272	i0	99.647	3	283	1	100	0	1	283	28149	28431	Mus musculus BAC clone RP23-1D23 from chromosome 8, complete sequence	blastn	849	518	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8927057	8927057	PRJDB12134_P_NODE_11248_length_270_cov_1.274112_g11113_i0	PRJDB12134	11248	270	1.274112	3.4401024	Odocoileus virginianus	9874	Chordata	Chordata	209	1.3900000000000001e-49	NTclustered	gi\|2871636349\|ref\|XR_011485972.1\|	9874	g11113	i0	93.617	93.7222222222222	141	7	91	2	1	140	4715	4854	PREDICTED: Odocoileus virginianus uncharacterized lncRNA (LOC139033411), ncRNA	blastn	25305	209	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Odocoileus	Odocoileus virginianus
8927071	8927071	PRJDB12134_P_NODE_12148_length_255_cov_1.609890_g12013_i0	PRJDB12134	12148	255	1.60989	4.1052195	Mus musculus	10090	Chordata	Chordata	466	6.98e-127	NTclustered	gi\|2311270469\|ref\|NM_001412383.1\|	10090	g12013	i0	99.608	100	255	1	100	0	1	255	2377	2123	Mus musculus epsin 1 (Epn1), transcript variant 50, mRNA	blastn	25500	466	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8927092	8927092	PRJDB12134_P_NODE_13468_length_247_cov_0.890805_g13333_i0	PRJDB12134	13468	247	0.890805	2.20028835	Jaculus jaculus	51337	Chordata	Chordata	56.5	0.002	NTclustered	gi\|2147852458\|ref\|XM_045155033.1\|	51337	g13333	i0	92.5	0.161943319838057	40	2	16	1	146	185	336	298	PREDICTED: Jaculus jaculus FRAS1 related extracellular matrix 2 (Frem2), mRNA	blastn	40	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Dipodidae	Jaculus	Jaculus jaculus
16576988	16576988	PRJDB12134_P_NODE_7854_length_348_cov_1.880000_g7719_i0	PRJDB12134	7854	348	1.88	6.5424	Lampetra fluviatilis	7748	Chordata	Chordata	56.5	0.003	NTclustered	gi\|2805739249\|emb\|OZ078462.1\|	7748	g7719	i0	96.97	0.0948275862068965	33	1	9	0	22	54	4700209	4700241	Lampetra fluviatilis genome assembly, chromosome: 59	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
20400619	20400619	PRJDB12134_P_NODE_12617_length_251_cov_0.876404_g12482_i0	PRJDB12134	12617	251	0.876404	2.19977404	Mus musculus	10090	Chordata	Chordata	459	1.1499999999999996e-124	NTclustered	gi\|66793166\|gb\|AC157774.5\|	10090	g12482	i0	99.602	10.8804780876494	251	1	100	0	1	251	163827	163577	Mus musculus chromosome 8, clone RP23-423E20, complete sequence	blastn	2731	459	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21676620	21676620	PRJDB12134_P_NODE_11698_length_263_cov_1.352632_g11563_i0	PRJDB12134	11698	263	1.352632	3.5574221600000002	Mus musculus	10090	Chordata	Chordata	486	5.5499999999999986e-133	NTclustered	gi\|2548330513\|gb\|OQ915115.1\|	10090	g11563	i0	100	81.9619771863118	263	0	100	0	1	263	4804	5066	Mus musculus clone BAC JH_40 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	21556	486	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22952120	22952120	PRJDB12134_P_NODE_9639_length_295_cov_1.400901_g9504_i0	PRJDB12134	9639	295	1.400901	4.13265795	Suricata suricatta	37032	Chordata	Chordata	52.8	0.027	NTclustered	gi\|1702039213\|ref\|XM_029937849.1\|	37032	g9504	i0	100	0.474576271186441	28	0	9	0	1	28	2279	2252	PREDICTED: Suricata suricatta zinc finger protein 514-like (LOC115290103), transcript variant X2, mRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Herpestidae	Suricata	Suricata suricatta
23933031	23933031	PRJDB12134_P_NODE_11639_length_264_cov_1.308901_g11504_i0	PRJDB12134	11639	264	1.308901	3.45549864	Mammalia	40674	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2633851551\|ref\|XM_061413686.1\|	9906	g11504	i0	100	3.84469696969697	29	0	11	0	236	264	935	963	PREDICTED: Bos javanicus Rap guanine nucleotide exchange factor 5 (RAPGEF5), transcript variant X3, mRNA	blastn	1015	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
24225878	24225878	PRJDB12134_P_NODE_13020_length_249_cov_0.886364_g12885_i0	PRJDB12134	13020	249	0.886364	2.20704636	Mus musculus	10090	Chordata	Chordata	459	1.1399999999999998e-124	NTclustered	gi\|142373150\|ref\|NM_172885.2\|	10090	g12885	i0	100	99.1726907630522	248	0	99	0	1	248	2724	2971	Mus musculus transmembrane protein 132D (Tmem132d), mRNA	blastn	24694	459	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24225895	24225895	PRJDB12134_P_NODE_13960_length_244_cov_0.912281_g13825_i0	PRJDB12134	13960	244	0.912281	2.22596564	Oryctolagus cuniculus	9986	Chordata	Chordata	207	4.44e-49	NTclustered	gi\|2862872585\|ref\|XM_008271729.4\|	9986	g13825	i0	88.953	79.9549180327869	172	14	69	4	27	195	4688	4857	PREDICTED: Oryctolagus cuniculus nucleolar protein 11 (NOL11), transcript variant X1, mRNA	blastn	19509	207	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Oryctolagus	Oryctolagus cuniculus
27538022	27538022	PRJDB12134_P_NODE_12404_length_252_cov_0.871508_g12269_i0	PRJDB12134	12404	252	0.871508	2.19620016	Sus scrofa	9823	Chordata	Chordata	59.3	6.08e-8	NR	XP_020937328.1	9823	g12269	i0	61.7	0.55952380952381	47	18	56	0	17	157	18	64	XP_020937328.1 collagen alpha-2(I) chain-like [Sus scrofa]	diamond	141	59.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
30437541	30437541	PRJDB12134_P_NODE_5173_length_467_cov_3.370558_g5039_i0	PRJDB12134	5173	467	3.370558	15.74050586	root	1	Root_unresolved	Root_unresolved	190	1.52e-56	NR	KAK9406952.1	8729	g5039	i0	67.2	93.8672376873662	125	41	80.3	0	93	467	158	282	KAK9406952.1 ras-related C3 botulinum toxin substrate 3 [Crotalus adamanteus]	diamond	43836	190	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Viperidae	Crotalus	Crotalus adamanteus

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