metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA658591" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA658591" 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
13915416	13915416	PRJNA658591_S_NODE_6511_length_188_cov_1.496403_g6448_i0	PRJNA658591	6511	188	1.496403	2.81323764	Cheloniidae	8465	Chordata	Chordata	52.8	0.016	NTclustered	gi\|2911500576\|emb\|OZ223607.1\|	8472	g6448	i0	100	0.446808510638298	28	0	15	0	2	29	10181279	10181252	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 21	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
18477774	18477774	PRJNA658591_S_NODE_2235_length_284_cov_5.519149_g2172_i0	PRJNA658591	2235	284	5.519149	15.67438316	Vicugna pacos	30538	Chordata	Chordata	52.8	0.026	NTclustered	gi\|1777469384\|ref\|XR_004190006.1\|	30538	g2172	i0	100	0.0985915492957746	28	0	10	0	242	269	689	716	PREDICTED: Vicugna pacos uncharacterized LOC116280604 (LOC116280604), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Camelidae	Vicugna	Vicugna pacos
18477786	18477786	PRJNA658591_S_NODE_6435_length_189_cov_1.114286_g6372_i0	PRJNA658591	6435	189	1.114286	2.10600054	Mus caroli	10089	Chordata	Chordata	56.5	0.001	NTclustered	gi\|1679855561\|ref\|XM_029480371.1\|	10089	g6372	i0	100	0.317460317460317	30	0	16	0	44	73	1858	1887	PREDICTED: Mus caroli CYLD lysine 63 deubiquitinase (Cyld), transcript variant X2, mRNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
18477795	18477795	PRJNA658591_S_NODE_815_length_433_cov_4.531250_g752_i0	PRJNA658591	815	433	4.53125	19.6203125	Spinus spinus	160760	Chordata	Chordata	54.7	0.012	NTclustered	gi\|2917663466\|emb\|OZ228753.1\|	160760	g752	i0	94.444	0.166281755196305	36	1	8	1	156	190	37205122	37205157	Spinus spinus genome assembly, chromosome: 5	blastn	72	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus
24113355	24113355	PRJNA658591_S_NODE_8579_length_170_cov_2.760331_g8516_i0	PRJNA658591	8579	170	2.760331	4.6925627	Mammalia	40674	Chordata	Chordata	158	2.93e-34	NTclustered	gi\|2806545747\|ref\|XM_068562404.1\|	9764	g8516	i0	83.432	79.7882352941176	169	28	99	0	1	169	1107	1275	PREDICTED: Eschrichtius robustus ATP synthase F1 subunit alpha (ATP5F1A), mRNA	blastn	13564	158	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Eschrichtiidae	Eschrichtius	Eschrichtius robustus

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