metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB39269" 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
1331343	1331343	PRJEB39269_P_NODE_40662_length_215_cov_2.522727_g40257_i0	PRJEB39269	40662	215	2.522727	5.42386305	Latimeria chalumnae	7897	Chordata	Chordata	60.2	1.13e-4	NTclustered	gi\|2721754178\|ref\|XM_064552669.1\|	7897	g40257	i0	97.222	0.637209302325581	36	0	16	1	129	163	11866	11901	PREDICTED: Latimeria chalumnae periaxin (PRX), mRNA	blastn	137	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
3883213	3883213	PRJEB39269_P_NODE_78524_length_159_cov_4.666667_g78119_i0	PRJEB39269	78524	159	4.666667	7.42000053	Sus scrofa	9823	Chordata	Chordata	150	4.54e-32	NTclustered	gi\|220682617\|gb\|EU853705.1\|	9823	g78119	i0	100	265.503144654088	81	0	100	0	1	81	107549	107629	Sus scrofa acetyl-coenzyme A carboxylase beta (ACACB) gene, complete cds, alternatively spliced	blastn	42215	150	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
3883231	3883231	PRJEB39269_P_NODE_84104_length_155_cov_16.646552_g83699_i0	PRJEB39269	84104	155	16.646552	25.8021556	Jaculus jaculus	51337	Chordata	Chordata	76.8	7.56e-10	NTclustered	gi\|2147875786\|ref\|XR_006634867.1\|	51337	g83699	i0	80.556	9.65806451612903	108	13	66	8	2	104	15	119	PREDICTED: Jaculus jaculus U2 spliceosomal RNA (LOC123457024), ncRNA	blastn	1497	76.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Dipodidae	Jaculus	Jaculus jaculus
6435321	6435321	PRJEB39269_P_NODE_89246_length_151_cov_3.562500_g88841_i0	PRJEB39269	89246	151	3.5625	5.379375	Canis lupus	9612	Chordata	Chordata	106	9.33e-19	NTclustered	gi\|167860228\|gb\|AC190116.3\|	9615	g88841	i0	87.234	5.32450331125828	94	11	87	1	43	135	188275	188182	Canis familiaris chromosome 31, clone XX-443F3, complete sequence	blastn	804	106	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
14085341	14085341	PRJEB39269_P_NODE_36492_length_228_cov_1.947090_g36087_i0	PRJEB39269	36492	228	1.94709	4.4393652	Eretmochelys imbricata	27787	Chordata	Chordata	52.8	0.02	NTclustered	gi\|2913380327\|emb\|OZ223903.1\|	27787	g36087	i0	100	0.12280701754386	28	0	12	0	114	141	3387378	3387351	Eretmochelys imbricata isolate rEreImb1 genome assembly, chromosome: 22	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Eretmochelys	Eretmochelys imbricata
14085364	14085364	PRJEB39269_P_NODE_63332_length_174_cov_0.962963_g62927_i0	PRJEB39269	63332	174	0.962963	1.67555562	Scyliorhinus canicula	7830	Chordata	Chordata	86.1	1.44e-12	NTclustered	gi\|1952459419\|ref\|XM_038779474.1\|	7830	g62927	i0	87.838	1.79310344827586	74	8	42	1	35	107	809	882	PREDICTED: Scyliorhinus canicula sorting nexin-11-like (LOC119954333), transcript variant X2, mRNA	blastn	312	86.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
19182541	19182541	PRJEB39269_P_NODE_43996_length_207_cov_1.220238_g43591_i0	PRJEB39269	43996	207	1.220238	2.52589266	Mus musculus	10090	Chordata	Chordata	374	3.4e-99	NTclustered	gi\|2548330513\|gb\|OQ915115.1\|	10090	g43591	i0	99.512	41.1932367149758	205	1	99	0	3	207	3264	3468	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	8527	374	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19182586	19182586	PRJEB39269_P_NODE_83156_length_156_cov_2.452991_g82751_i0	PRJEB39269	83156	156	2.452991	3.82666596	Erpetoichthys calabaricus	27687	Chordata	Chordata	52.8	0.013	NTclustered	gi\|2327560703\|ref\|XM_051934506.1\|	27687	g82751	i0	100	3.07692307692308	28	0	18	0	1	28	10287	10260	PREDICTED: Erpetoichthys calabaricus ectodysplasin A2 receptor (eda2r), mRNA	blastn	480	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
23009156	23009156	PRJEB39269_P_NODE_87839_length_152_cov_4.575221_g87434_i0	PRJEB39269	87839	152	4.575221	6.95433592	Ailuropoda melanoleuca	9646	Chordata	Chordata	62.1	2.06e-5	NTclustered	gi\|1845353832\|ref\|XM_034642189.1\|	9646	g87434	i0	85.965	0.375	57	8	38	0	96	152	4886	4942	PREDICTED: Ailuropoda melanoleuca uncharacterized LOC117795940 (LOC117795940), mRNA	blastn	57	62.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Ursidae	Ailuropoda	Ailuropoda melanoleuca

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