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

9 rows where analysis = "blastn", bioproject = "PRJEB6097" and tax_kingdom = "Metazoa"

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
125585	125585	PRJEB6097_S_NODE_6501_length_157_cov_8.311475_g6447_i0	PRJEB6097	6501	157	8.311475	13.04901575	Lampetra planeri	7750	Chordata	Chordata	67.6	4.63e-7	NTclustered	gi\|2814976159\|emb\|OZ078388.2\|	7750	g6447	i0	97.436	1.12101910828025	39	1	25	0	119	157	5643537	5643499	Lampetra planeri genome assembly, chromosome: 65	blastn	176	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
1400067	1400067	PRJEB6097_S_NODE_5422_length_211_cov_2.840909_g5368_i0	PRJEB6097	5422	211	2.840909	5.99431799	Spelobia clunipes	1888022	Arthropoda	Arthropoda	315	2.1399999999999993e-81	NTclustered	gi\|1880643096\|gb\|MT584135.1\|	1888022	g5368	i0	96.335	93.3981042654028	191	7	91	0	21	211	6401	6591	Spelobia clunipes isolate DM962 mitochondrion	blastn	19707	315	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sphaeroceridae	Spelobia	Spelobia clunipes
6095434	6095434	PRJEB6097_S_NODE_5765_length_186_cov_2.450331_g5711_i0	PRJEB6097	5765	186	2.450331	4.55761566	Bombus	28641	Arthropoda	Arthropoda	52.8	0.016	NTclustered	gi\|2832700248\|ref\|XR_011174825.1\|	103934	g5711	i0	100	0.301075268817204	28	0	15	0	99	126	1433	1460	PREDICTED: Bombus flavifrons uncharacterized lncRNA (LOC138186175), ncRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus flavifrons
8645381	8645381	PRJEB6097_S_NODE_5907_length_178_cov_1.391608_g5853_i0	PRJEB6097	5907	178	1.391608	2.47706224	Petromyzontidae	7746	Chordata	Chordata	60.2	9e-5	NTclustered	gi\|2815004333\|emb\|OZ078626.2\|	7748	g5853	i0	97.143	1.5561797752809	35	1	20	0	59	93	2122290	2122324	Lampetra fluviatilis genome assembly, chromosome: 58	blastn	277	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
9052848	9052848	PRJEB6097_S_NODE_6328_length_163_cov_1.562500_g6274_i0	PRJEB6097	6328	163	1.5625	2.546875	Mus musculus	10090	Chordata	Chordata	54.7	0.004	NTclustered	gi\|68448667\|gb\|AC160561.2\|	10090	g6274	i0	100	0.177914110429448	29	0	18	0	135	163	34628	34600	Mus musculus BAC clone RP23-102D22 from chromosome 12, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10328635	10328635	PRJEB6097_S_NODE_6009_length_173_cov_2.623188_g5955_i0	PRJEB6097	6009	173	2.623188	4.53811524	Chironomus tepperi	113505	Arthropoda	Arthropoda	111	2.36e-20	NTclustered	gi\|2874216783\|ref\|XM_070642639.1\|	113505	g5955	i0	89.011	15.4913294797688	91	8	52	2	84	173	1462	1373	PREDICTED: Chironomus tepperi elongation factor 1-alpha-like (LOC139092294), mRNA	blastn	2680	111	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
10328638	10328638	PRJEB6097_S_NODE_6389_length_161_cov_2.833333_g6335_i0	PRJEB6097	6389	161	2.833333	4.56166613	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	2.87e-4	NTclustered	gi\|2912984370\|dbj\|AP039589.1\|	145626	g6335	i0	100	1.79503105590062	31	0	19	0	107	137	66230485	66230455	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence	blastn	289	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
12879225	12879225	PRJEB6097_S_NODE_6151_length_168_cov_3.827068_g6097_i0	PRJEB6097	6151	168	3.827068	6.42947424	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	52.8	0.014	NTclustered	gi\|2782839894\|ref\|XM_067055043.1\|	252671	g6097	i0	100	0.333333333333333	28	0	17	0	57	84	7988	7961	PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136798434), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
16294945	16294945	PRJEB6097_S_NODE_6593_length_155_cov_1.591667_g6539_i0	PRJEB6097	6593	155	1.591667	2.46708385	root	1	Root_unresolved	Root_unresolved	281	1.49e-71	NTclustered	gi\|78097480\|gb\|AC167666.4\|	7176	g6539	i0	99.355	287	155	1	100	0	1	155	1013	1167	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence	blastn	44485	281	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus

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