metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA591000" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA591000" 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
564965	564965	PRJNA591000_P_NODE_15681_length_227_cov_2.797980_g14075_i0	PRJNA591000	15681	227	2.79798	6.3514146	Mus musculus	10090	Chordata	Chordata	324	3.88e-84	NTclustered	gi\|45544808\|gb\|AC110171.29\|	10090	g14075	i0	99.438	1	178	1	100	0	50	227	183536	183359	Mus musculus chromosome 12, clone RP23-400A5, complete sequence	blastn	227	324	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4392439	4392439	PRJNA591000_P_NODE_8084_length_489_cov_4.236957_g6575_i0	PRJNA591000	8084	489	4.236957	20.71871973	Mus musculus	10090	Chordata	Chordata	538	3e-148	NTclustered	gi\|49615228\|gb\|AC118017.15\|	10090	g6575	i0	100	40.4969325153374	291	0	100	0	199	489	150381	150671	Mus musculus chromosome 7, clone RP23-457C1, complete sequence	blastn	19803	538	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
5668663	5668663	PRJNA591000_P_NODE_10125_length_443_cov_1.299517_g8559_i0	PRJNA591000	10125	443	1.299517	5.75686031	Mus musculus	10090	Chordata	Chordata	307	8.28e-79	NTclustered	gi\|50345243\|gb\|AC132435.3\|	10090	g8559	i0	100	0.708803611738149	166	0	70	0	1	166	172277	172442	Mus musculus BAC clone RP23-223L12 from 10, complete sequence	blastn	314	307	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6943094	6943094	PRJNA591000_P_NODE_12926_length_407_cov_1.624339_g11338_i0	PRJNA591000	12926	407	1.624339	6.61105973	Phasianus colchicus	9054	Chordata	Chordata	56.5	0.003	NTclustered	gi\|1776081384\|ref\|XM_031590476.1\|	9054	g11338	i0	100	0.0737100737100737	30	0	7	0	11	40	5638	5609	PREDICTED: Phasianus colchicus mitogen-activated protein kinase kinase kinase 19 (MAP3K19), partial mRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Phasianus	Phasianus colchicus
8791429	8791429	PRJNA591000_P_NODE_5747_length_604_cov_3.297391_g4528_i0	PRJNA591000	5747	604	3.297391	19.91624164	Mus	10088	Chordata	Chordata	791	0	NTclustered	gi\|1304473138\|ref\|NM_001358854.1\|	10090	g4528	i0	100	78.8526490066225	428	0	100	0	177	604	2300	2727	Mus musculus colony stimulating factor 2 receptor, beta, low-affinity (granulocyte-macrophage) (Csf2rb), transcript variant 1, mRNA	blastn	47627	791	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9493343	9493343	PRJNA591000_P_NODE_4828_length_671_cov_2.182243_g3818_i0	PRJNA591000	4828	671	2.182243	14.64285053	Mus musculus	10090	Chordata	Chordata	244	1.03e-59	NTclustered	gi\|49258279\|gb\|AC131695.4\|	10090	g3818	i0	100	1.23248882265276	132	0	63	0	540	671	97341	97472	Mus musculus BAC clone RP23-396F8 from chromosome 6, complete sequence	blastn	827	244	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11341968	11341968	PRJNA591000_P_NODE_649_length_1296_cov_4.017364_g441_i0	PRJNA591000	649	1296	4.017364	52.06503744	Mus	10088	Chordata	Chordata	821	0	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g441	i0	99.557	71.2654320987654	451	1	73	1	618	1068	74	523	Mus musculus strain ME mitochondrion, complete genome	blastn	92360	821	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
17142575	17142575	PRJNA591000_P_NODE_4914_length_665_cov_3.823899_g2877_i2	PRJNA591000	4914	665	3.823899	25.42892835	Dendropsophus ebraccatus	150705	Chordata	Chordata	87.9	1.82e-12	NTclustered	gi\|2853363747\|ref\|XM_069951117.1\|	150705	g2877	i2	92.063	7.69022556390977	63	3	9	1	568	630	3114	3174	PREDICTED: Dendropsophus ebraccatus serpin family A member 10 (SERPINA10), mRNA	blastn	5114	87.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Dendropsophus	Dendropsophus ebraccatus
17142578	17142578	PRJNA591000_P_NODE_6554_length_553_cov_1.994275_g5193_i0	PRJNA591000	6554	553	1.994275	11.02834075	Mus musculus	10090	Chordata	Chordata	300	1.76e-76	NTclustered	gi\|1907120376\|ref\|XM_036160199.1\|	10090	g5193	i0	100	72.0506329113924	162	0	88	0	125	286	1540	1701	PREDICTED: Mus musculus pyridoxal-dependent decarboxylase domain containing 1 (Pdxdc1), transcript variant X4, mRNA	blastn	39844	300	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18416779	18416779	PRJNA591000_P_NODE_11135_length_428_cov_1.676692_g9557_i0	PRJNA591000	11135	428	1.676692	7.17624176	Mus musculus	10090	Chordata	Chordata	272	2.91e-68	NTclustered	gi\|50345243\|gb\|AC132435.3\|	10090	g9557	i0	100	10.9322429906542	147	0	57	0	1	147	172619	172473	Mus musculus BAC clone RP23-223L12 from 10, complete sequence	blastn	4679	272	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19691324	19691324	PRJNA591000_P_NODE_2976_length_800_cov_3.901427_g2270_i0	PRJNA591000	2976	800	3.901427	31.211416	Mus musculus	10090	Chordata	Chordata	1188	0	NTclustered	gi\|28412105\|gb\|AC124740.4\|	10090	g2270	i0	96.561	1.74125	727	8	91	3	64	790	32693	33402	Mus musculus BAC clone RP23-356M1 from chromosome 18, complete sequence	blastn	1393	1188	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20967102	20967102	PRJNA591000_P_NODE_13997_length_395_cov_0.699454_g12402_i0	PRJNA591000	13997	395	0.699454	2.7628433	Mus musculus	10090	Chordata	Chordata	91.6	8.01e-14	NTclustered	gi\|13435980\|gb\|BC004824.1\|	10090	g12402	i0	100	11.6632911392405	49	0	12	0	341	389	27	75	Mus musculus rhotekin, mRNA (cDNA clone IMAGE:2609590), ** WARNING: chimeric clone **	blastn	4607	91.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22242055	22242055	PRJNA591000_P_NODE_5298_length_638_cov_4.087028_g4177_i0	PRJNA591000	5298	638	4.087028	26.07523864	Mus musculus	10090	Chordata	Chordata	761	0	NTclustered	gi\|49615228\|gb\|AC118017.15\|	10090	g4177	i0	96.818	45.0595611285266	440	14	100	0	199	638	150381	150820	Mus musculus chromosome 7, clone RP23-457C1, complete sequence	blastn	28748	761	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);;