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

5 rows where analysis = "blastn", bioproject = "PRJNA999747" 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
12753463	12753463	PRJNA999747_S_NODE_1690_length_231_cov_5.860000_g1658_i0	PRJNA999747	1690	231	5.86	13.5366	Chordata	7711	Chordata	Chordata	52.8	0.021	NTclustered	gi\|2721460824\|emb\|HG999682.4\|	9103	g1658	i0	100	0.242424242424242	28	0	12	0	94	121	32418365	32418392	Meleagris gallopavo genome assembly, chromosome: 3	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
17558491	17558491	PRJNA999747_S_NODE_4154_length_156_cov_1.904000_g4122_i0	PRJNA999747	4154	156	1.904	2.97024	Mus musculus	10090	Chordata	Chordata	265	1.52e-66	NTclustered	gi\|2510669837\|gb\|OQ871514.1\|	10090	g4122	i0	97.436	63.224358974359	156	2	99	2	2	156	4854	4700	Mus musculus clone BAC 18_2 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	9863	265	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22657602	22657602	PRJNA999747_S_NODE_2218_length_205_cov_2.936782_g2186_i0	PRJNA999747	2218	205	2.936782	6.0204031	Lampetra planeri	7750	Chordata	Chordata	62.1	2.97e-5	NTclustered	gi\|2805746514\|emb\|OZ078535.1\|	7750	g2186	i0	100	0.658536585365854	33	0	16	0	3	35	3598062	3598030	Lampetra planeri genome assembly, chromosome: 50	blastn	135	62.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
22657609	22657609	PRJNA999747_S_NODE_2778_length_186_cov_66.554839_g2746_i0	PRJNA999747	2778	186	66.554839	123.79200054	Mus musculus	10090	Chordata	Chordata	305	1.11e-78	NTclustered	gi\|2904934889\|gb\|PQ737812.1\|	10090	g2746	i0	96.237	103.376344086022	186	7	100	0	1	186	5	190	Mus musculus lncRNA222 lncRNA, complete sequence	blastn	19228	305	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22951898	22951898	PRJNA999747_S_NODE_2478_length_196_cov_3.054545_g2446_i0	PRJNA999747	2478	196	3.054545	5.9869082	root	1	Root_unresolved	Root_unresolved	361	2.48e-95	NTclustered	gi\|2645168801\|gb\|OR992004.1\|	10090	g2446	i0	100	99.9897959183673	195	0	99	0	1	195	1032	838	Mus musculus transgenic puromycin-resistant protein (Puro) gene, complete cds; red fluorescence protein (RFP) gene, complete sequence; and GFP-I-SceI (GFP-I-SceI) gene, complete cds	blastn	19598	361	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);;