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

24 rows where analysis = "blastn", bioproject = "PRJNA688157" 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
666832	666832	PRJNA688157_S_NODE_59101_length_287_cov_3.831776_g58959_i0	PRJNA688157	59101	287	3.831776	10.99719712	Mus musculus	10090	Chordata	Chordata	54.7	0.007	NTclustered	gi\|71533340\|gb\|AC156162.2\|	10090	g58959	i0	100	0.101045296167247	29	0	10	0	168	196	100783	100755	Mus musculus BAC clone RP24-342A17 from chromosome 9, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
666833	666833	PRJNA688157_S_NODE_71561_length_268_cov_2.456410_g71419_i0	PRJNA688157	71561	268	2.45641	6.5831788	Erpetoichthys calabaricus	27687	Chordata	Chordata	163	1.09e-35	NTclustered	gi\|2327581580\|ref\|XM_051922993.1\|	27687	g71419	i0	79.447	6.22388059701493	253	35	90	11	26	267	1004	1250	PREDICTED: Erpetoichthys calabaricus E3 SUMO-protein ligase ZBED1-like (LOC127526706), mRNA	blastn	1668	163	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
3217722	3217722	PRJNA688157_S_NODE_82823_length_253_cov_1.722222_g82681_i0	PRJNA688157	82823	253	1.722222	4.35722166	Bos taurus	9913	Chordata	Chordata	159	1.31e-34	NTclustered	gi\|50872227\|gb\|AC149756.4\|	9913	g82681	i0	90.909	353.648221343874	121	8	47	3	124	241	9739	9859	Bos taurus BAC CH240-361I2 (Children's Hospital Oakland Research Institute Bovine BAC Library (male)) complete sequence	blastn	89473	159	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
4494754	4494754	PRJNA688157_S_NODE_36564_length_333_cov_1.188462_g36422_i0	PRJNA688157	36564	333	1.188462	3.95757846	Pseudorca crassidens	82174	Chordata	Chordata	195	4.93e-45	NTclustered	gi\|310942474\|dbj\|AP011083.1\|	82174	g36422	i0	83.105	59.7717717717718	219	32	64	3	1	214	18724	18942	Pseudorca crassidens genomic DNA, clone: QGB1-286P09, complete sequence	blastn	19904	195	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Pseudorca	Pseudorca crassidens
7045477	7045477	PRJNA688157_S_NODE_49026_length_305_cov_3.327586_g48884_i0	PRJNA688157	49026	305	3.327586	10.1491373	Mus musculus	10090	Chordata	Chordata	189	2.08e-43	NTclustered	gi\|82779810\|gb\|AC162449.4\|	10090	g48884	i0	84.536	0.636065573770492	194	27	64	3	109	302	132562	132752	Mus musculus chromosome 1, clone RP23-424E19, complete sequence	blastn	194	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7045481	7045481	PRJNA688157_S_NODE_83566_length_252_cov_2.832402_g83424_i0	PRJNA688157	83566	252	2.832402	7.13765304	Cervus canadensis	1574408	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2090084491\|ref\|XR_006268145.1\|	1574408	g83424	i0	100	0.111111111111111	28	0	11	0	193	220	1852	1825	PREDICTED: Cervus canadensis uncharacterized LOC122436880 (LOC122436880), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Cervus	Cervus canadensis
9595398	9595398	PRJNA688157_S_NODE_29368_length_353_cov_2.221429_g29226_i0	PRJNA688157	29368	353	2.221429	7.84164437	Bubalus kerabau	3119969	Chordata	Chordata	475	1.6699999999999994e-129	NTclustered	gi\|2496480262\|ref\|XR_008713097.1\|	3119969	g29226	i0	91.667	239.977337110482	348	21	97	5	1	341	2136	2482	PREDICTED: Bubalus kerabau uncharacterized LOC129649343 (LOC129649343), transcript variant X1, ncRNA	blastn	84712	475	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bubalus	Bubalus kerabau
9595400	9595400	PRJNA688157_S_NODE_49108_length_305_cov_2.560345_g48966_i0	PRJNA688157	49108	305	2.560345	7.80905225	Bubalus kerabau	3119969	Chordata	Chordata	121	7.68e-23	NTclustered	gi\|2496487531\|ref\|XR_008714149.1\|	3119969	g48966	i0	82.857	38.3934426229508	140	18	45	5	7	144	1334	1199	PREDICTED: Bubalus kerabau uncharacterized LOC129651453 (LOC129651453), ncRNA	blastn	11710	121	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bubalus	Bubalus kerabau
11380210	11380210	PRJNA688157_S_NODE_58489_length_288_cov_4.344186_g58347_i0	PRJNA688157	58489	288	4.344186	12.51125568	Bos	9903	Chordata	Chordata	322	1.84e-83	NTclustered	gi\|50199361\|dbj\|AB117056.1\|	9913	g58347	i0	100	93.9236111111111	174	0	100	0	115	288	338	511	Bos taurus mitochondrial DNA, D-loop region, isolate: K20	blastn	27050	322	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
11380211	11380211	PRJNA688157_S_NODE_65029_length_278_cov_1.517073_g64887_i0	PRJNA688157	65029	278	1.517073	4.21746294	Mus	10088	Chordata	Chordata	514	2.7199999999999996e-141	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g64887	i0	100	100	278	0	100	0	1	278	2592	2869	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	27800	514	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11380214	11380214	PRJNA688157_S_NODE_90689_length_246_cov_2.341040_g90547_i0	PRJNA688157	90689	246	2.34104	5.7589584	root	1	Root_unresolved	Root_unresolved	455	1.4500000000000002e-123	NTclustered	gi\|212354\|gb\|J00889.1\|CHKMYC	9031	g90547	i0	100	100.317073170732	246	0	100	0	1	246	2933	2688	Chicken cellular myc proto-oncogene, complete cds	blastn	24678	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
13420785	13420785	PRJNA688157_S_NODE_30791_length_348_cov_11.927273_g30649_i0	PRJNA688157	30791	348	11.927273	41.50691004	Mus musculus	10090	Chordata	Chordata	634	2.5699999999999996e-177	NTclustered	gi\|28175801\|gb\|BC043020.1\|	10090	g30649	i0	100	97.8448275862069	343	0	99	0	1	343	197	539	Mus musculus hemoglobin alpha, adult chain 1, mRNA (cDNA clone MGC:57888 IMAGE:5684314), complete cds	blastn	34050	634	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13420786	13420786	PRJNA688157_S_NODE_36051_length_334_cov_2.091954_g35909_i0	PRJNA688157	36051	334	2.091954	6.98712636	Bos taurus	9913	Chordata	Chordata	150	1.09e-31	NTclustered	gi\|2587687915\|ref\|XM_010805950.4\|	9913	g35909	i0	100	6.83832335329341	81	0	24	0	134	214	374	294	PREDICTED: Bos taurus endomucin (EMCN), transcript variant X2, mRNA	blastn	2284	150	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
15969530	15969530	PRJNA688157_S_NODE_61633_length_283_cov_2.471429_g61491_i0	PRJNA688157	61633	283	2.471429	6.99414407	Mus musculus	10090	Chordata	Chordata	518	2.14e-142	NTclustered	gi\|15080560\|gb\|BC012020.1\|	10090	g61491	i0	99.647	97.1978798586572	283	1	100	0	1	283	1611	1329	Mus musculus cDNA clone IMAGE:4500967, with apparent retained intron	blastn	27507	518	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16479530	16479530	PRJNA688157_S_NODE_75773_length_262_cov_3.285714_g75631_i0	PRJNA688157	75773	262	3.285714	8.60857068	Mus	10088	Chordata	Chordata	484	1.99e-132	NTclustered	gi\|846387676\|dbj\|LC061971.1\|	10090	g75631	i0	100	100	262	0	100	0	1	262	1711	1450	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_20	blastn	26200	484	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
17244786	17244786	PRJNA688157_S_NODE_45734_length_312_cov_1.803347_g45592_i0	PRJNA688157	45734	312	1.803347	5.62644264	Bubalus kerabau	3119969	Chordata	Chordata	189	2.13e-43	NTclustered	gi\|2496390965\|ref\|XR_008718006.1\|	3119969	g45592	i0	93.701	65.3301282051282	127	7	41	1	13	139	1453	1328	PREDICTED: Bubalus kerabau uncharacterized LOC129659300 (LOC129659300), transcript variant X18, ncRNA	blastn	20383	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bubalus	Bubalus kerabau
17754521	17754521	PRJNA688157_S_NODE_51874_length_300_cov_1.814978_g51732_i0	PRJNA688157	51874	300	1.814978	5.444934	Metazoa	33208	Chordata	Chordata	540	4.89e-149	NTclustered	gi\|2587618129\|ref\|XR_009493721.1\|	9913	g51732	i0	99.661	31.3433333333333	295	1	98	0	6	300	2086	1792	PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344768), transcript variant X1, ncRNA	blastn	9403	540	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
17754523	17754523	PRJNA688157_S_NODE_64314_length_279_cov_1.514563_g64172_i0	PRJNA688157	64314	279	1.514563	4.22563077	Mus	10088	Chordata	Chordata	516	7.58e-142	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g64172	i0	100	100	279	0	100	0	1	279	2289	2567	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	516	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
17754529	17754529	PRJNA688157_S_NODE_97814_length_237_cov_2.268293_g97672_i0	PRJNA688157	97814	237	2.268293	5.37585441	Delphinidae	9726	Chordata	Chordata	235	1.97e-57	NTclustered	gi\|2280729179\|ref\|XM_033414992.2\|	9733	g97672	i0	84.81	121.68776371308	237	32	99	4	2	236	3388	3622	PREDICTED: Orcinus orca X-linked inhibitor of apoptosis (XIAP), transcript variant X3, mRNA	blastn	28840	235	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca
19028384	19028384	PRJNA688157_S_NODE_18455_length_395_cov_3.745342_g18313_i0	PRJNA688157	18455	395	3.745342	14.7941009	Artiodactyla	91561	Chordata	Chordata	523	6.659999999999999e-144	NTclustered	gi\|13345338\|gb\|AF327849.1\|AF327849	9894	g18313	i0	96.238	1062.38987341772	319	12	81	0	77	395	514	196	Giraffa camelopardalis clone Gcsine33 SINE/LINE Bov-B repeat sequence	blastn	419644	523	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Giraffidae	Giraffa	Giraffa camelopardalis
22344150	22344150	PRJNA688157_S_NODE_91978_length_245_cov_1.941860_g91836_i0	PRJNA688157	91978	245	1.94186	4.757557	Bubalus bubalis	89462	Chordata	Chordata	348	2.5200000000000005e-91	NTclustered	gi\|2148346391\|ref\|XR_006542750.2\|	89462	g91836	i0	92.276	66.1469387755102	246	18	100	1	1	245	483	728	PREDICTED: Bubalus bubalis uncharacterized LOC102406887 (LOC102406887), ncRNA	blastn	16206	348	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bubalus	Bubalus bubalis
23619662	23619662	PRJNA688157_S_NODE_25179_length_367_cov_2.384354_g25037_i0	PRJNA688157	25179	367	2.384354	8.75057918	Ovis aries	9940	Chordata	Chordata	289	2.44e-73	NTclustered	gi\|2607083488\|ref\|XR_009598330.1\|	9940	g25037	i0	87.266	0.727520435967302	267	16	69	3	113	367	3787	3527	PREDICTED: Ovis aries uncharacterized LOC132658532 (LOC132658532), ncRNA	blastn	267	289	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
24892959	24892959	PRJNA688157_S_NODE_59220_length_287_cov_2.528037_g59078_i0	PRJNA688157	59220	287	2.528037	7.25546619	Ovis aries	9940	Chordata	Chordata	392	1.3799999999999999e-104	NTclustered	gi\|2606975318\|ref\|XR_009595140.1\|	9940	g59078	i0	90.82	1.06271777003484	305	10	100	1	1	287	35805	36109	PREDICTED: Ovis aries uncharacterized LOC132657259 (LOC132657259), ncRNA	blastn	305	392	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
25403207	25403207	PRJNA688157_S_NODE_24820_length_368_cov_5.383051_g24678_i0	PRJNA688157	24820	368	5.383051	19.80962768	root	1	Root_unresolved	Root_unresolved	680	0	NTclustered	gi\|21314985\|gb\|BC030724.1\|	10090	g24678	i0	100	44.7961956521739	368	0	100	0	1	368	1520	1153	Mus musculus aldolase B, fructose-bisphosphate, mRNA (cDNA clone MGC:36580 IMAGE:5100784), complete cds	blastn	16485	680	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);;