metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB2368" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB2368" and tax_phylum = "Arthropoda"

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
1297103	1297103	PRJEB2368_P_NODE_12482_length_205_cov_1.273810_g12163_i0	PRJEB2368	12482	205	1.27381	2.6113105	Stegana prigenti	1127313	Arthropoda	Arthropoda	154	4.77e-33	NTclustered	gi\|1575855041\|gb\|MH372492.1\|	1127313	g12163	i0	81	7.87317073170732	200	33	97	4	8	205	321	125	Stegana prigenti isolate 1883 tubulin alpha-1 chain (TUBA1) gene, partial cds	blastn	1614	154	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Stegana	Stegana prigenti
2572786	2572786	PRJEB2368_P_NODE_2923_length_487_cov_3.566667_g2626_i0	PRJEB2368	2923	487	3.566667	17.36966829	Timema californicum	61474	Arthropoda	Arthropoda	56.5	0.004	NTclustered	gi\|1965181363\|emb\|OE475415.1\|	61474	g2626	i0	90.909	0.0903490759753593	44	1	8	2	360	400	266	309	2_Tcm_b3v08	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
3849104	3849104	PRJEB2368_P_NODE_13884_length_172_cov_2.400000_g13565_i0	PRJEB2368	13884	172	2.4	4.128	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	54.7	0.004	NTclustered	gi\|1963617327\|emb\|OC873114.1\|	1979941	g13565	i0	100	0.168604651162791	29	0	17	0	123	151	1610	1638	Medioppia subpectinata	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
8949902	8949902	PRJEB2368_P_NODE_13328_length_182_cov_1.344828_g13009_i0	PRJEB2368	13328	182	1.344828	2.44758696	Mantichorula semenowi	302824	Arthropoda	Arthropoda	178	2.45e-40	NTclustered	gi\|194354482\|gb\|EU825991.1\|	302824	g13009	i0	84.615	90.7582417582418	182	24	99	4	1	180	786	965	Mantichorula semenowi beta-actin mRNA, complete cds	blastn	16518	178	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Mantichorula	Mantichorula semenowi
14051018	14051018	PRJEB2368_P_NODE_12972_length_190_cov_1.274510_g12653_i0	PRJEB2368	12972	190	1.27451	2.421569	Pseudostegana stigmatptera	1509428	Arthropoda	Arthropoda	137	4.38e-28	NTclustered	gi\|1575855119\|gb\|MH372531.1\|	1509428	g12653	i0	79.787	6.88421052631579	188	38	99	0	3	190	398	211	Pseudostegana stigmatptera isolate 972 tubulin alpha-1 chain (TUBA1) gene, partial cds	blastn	1308	137	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Pseudostegana	Pseudostegana stigmatptera
16599701	16599701	PRJEB2368_P_NODE_11014_length_286_cov_1.417671_g10696_i0	PRJEB2368	11014	286	1.417671	4.05453906	Macdunnoughia confusa	254380	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|2917930488\|emb\|OZ234932.1\|	254380	g10696	i0	100	0.101398601398601	29	0	10	0	234	262	3319027	3319055	Macdunnoughia confusa genome assembly, chromosome: 6	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Macdunnoughia	Macdunnoughia confusa
19148390	19148390	PRJEB2368_P_NODE_11336_length_277_cov_2.162500_g11017_i0	PRJEB2368	11336	277	2.1625	5.990125	Leiobunum subalpinum	3086104	Arthropoda	Arthropoda	52.8	0.025	NTclustered	gi\|2920024403\|emb\|OZ239125.1\|	3086104	g11017	i0	100	0.101083032490975	28	0	10	0	211	238	12416224	12416251	Leiobunum subalpinum genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Opiliones	Sclerosomatidae	Leiobunum	Leiobunum subalpinum
20423600	20423600	PRJEB2368_P_NODE_13637_length_176_cov_1.719424_g13318_i0	PRJEB2368	13637	176	1.719424	3.02618624	Drosophila tropicalis	46794	Arthropoda	Arthropoda	178	2.35e-40	NTclustered	gi\|2802791061\|ref\|XM_068303176.1\|	46794	g13318	i0	85.714	95.1590909090909	168	24	95	0	1	168	685	518	PREDICTED: Drosophila tropicalis Actin 5C (Act5C), transcript variant X1, mRNA	blastn	16748	178	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila tropicalis
22974878	22974878	PRJEB2368_P_NODE_2559_length_535_cov_2.891566_g2271_i0	PRJEB2368	2559	535	2.891566	15.4698781	Oppiella nova	334625	Arthropoda	Arthropoda	54.7	0.015	NTclustered	gi\|1962580772\|emb\|OC914909.1\|	334625	g2271	i0	100	0.0542056074766355	29	0	5	0	200	228	7584	7612	Oppiella nova	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
24248719	24248719	PRJEB2368_P_NODE_13420_length_180_cov_1.349650_g13101_i0	PRJEB2368	13420	180	1.34965	2.42937	Pediculus humanus	121225	Arthropoda	Arthropoda	126	8.87e-25	NTclustered	gi\|242013040\|ref\|XM_002427183.1\|	121224	g13101	i0	86.842	18.3777777777778	114	14	63	1	8	120	1218	1331	Pediculus humanus corporis tubulin alpha-3 chain, putative (Phum_PHUM304110), partial mRNA	blastn	3308	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Pediculidae	Pediculus	Pediculus humanus

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