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

9 rows where analysis = "blastn", bioproject = "PRJNA929940" 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
909147	909147	PRJNA929940_S_NODE_53781_length_156_cov_1.310924_g53546_i0	PRJNA929940	53781	156	1.310924	2.04504144	Anarta stigmosa	1869462	Arthropoda	Arthropoda	52.8	0.013	NTclustered	gi\|2918376560\|emb\|OZ237980.1\|	1869462	g53546	i0	100	0.179487179487179	28	0	18	0	112	139	5126747	5126720	Anarta stigmosa genome assembly, chromosome: 4	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Anarta	Anarta stigmosa
3460013	3460013	PRJNA929940_S_NODE_47923_length_163_cov_1.547619_g47688_i0	PRJNA929940	47923	163	1.547619	2.52261897	Plodia interpunctella	58824	Arthropoda	Arthropoda	54.7	0.004	NTclustered	gi\|2716157356\|ref\|XM_053766765.2\|	58824	g47688	i0	92.105	0.233128834355828	38	3	23	0	42	79	3473	3436	PREDICTED: Plodia interpunctella ras-related protein Rab-24-like (LOC128682183), mRNA	blastn	38	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pyralidae	Plodia	Plodia interpunctella
7287219	7287219	PRJNA929940_S_NODE_38826_length_177_cov_1.664286_g38591_i0	PRJNA929940	38826	177	1.664286	2.94578622	Darwinula stevensoni	69355	Arthropoda	Arthropoda	62.1	2.48e-5	NTclustered	gi\|1936491559\|emb\|LR899535.1\|	69355	g38591	i0	95	0.621468926553672	40	1	23	1	108	147	41898	41936	Darwinula stevensoni	blastn	110	62.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
8562050	8562050	PRJNA929940_S_NODE_30827_length_193_cov_6.692308_g30592_i0	PRJNA929940	30827	193	6.692308	12.91615444	Cydia splendana	1100963	Arthropoda	Arthropoda	52.8	0.017	NTclustered	gi\|2695898591\|ref\|XM_063769561.1\|	1100963	g30592	i0	100	0.145077720207254	28	0	15	0	130	157	994	1021	PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Cydia	Cydia splendana
14937087	14937087	PRJNA929940_S_NODE_43772_length_169_cov_1.454545_g43537_i0	PRJNA929940	43772	169	1.454545	2.45818105	Cimex lectularius	79782	Arthropoda	Arthropoda	52.8	0.014	NTclustered	gi\|1351638001\|ref\|XM_024228386.1\|	79782	g43537	i0	100	0.165680473372781	28	0	17	0	56	83	295	268	PREDICTED: Cimex lectularius uncharacterized LOC112127420 (LOC112127420), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cimicidae	Cimex	Cimex lectularius
16212067	16212067	PRJNA929940_S_NODE_20633_length_226_cov_2.857143_g20398_i0	PRJNA929940	20633	226	2.857143	6.45714318	Daphnia pulex	6669	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2192734159\|ref\|XM_046600325.1\|	6669	g20398	i0	94.595	0.654867256637168	37	0	15	2	141	175	8462	8498	PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA	blastn	148	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
16212070	16212070	PRJNA929940_S_NODE_30873_length_193_cov_3.967949_g30638_i0	PRJNA929940	30873	193	3.967949	7.65814157	Nasonia vitripennis	7425	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|1815719506\|ref\|XM_003425601.5\|	7425	g30638	i0	100	0.77720207253886	30	0	16	0	25	54	4801	4772	PREDICTED: Nasonia vitripennis protein kinase C, brain isozyme (LOC100116629), transcript variant X3, mRNA	blastn	150	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Pteromalidae	Nasonia	Nasonia vitripennis
16212071	16212071	PRJNA929940_S_NODE_3253_length_442_cov_6.982716_g3020_i0	PRJNA929940	3253	442	6.982716	30.86360472	Oppiella nova	334625	Arthropoda	Arthropoda	52.8	0.043	NTclustered	gi\|1962580772\|emb\|OC914909.1\|	334625	g3020	i0	100	0.0633484162895928	28	0	6	0	1	28	7585	7612	Oppiella nova	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
18760735	18760735	PRJNA929940_S_NODE_25095_length_210_cov_1.109827_g24860_i0	PRJNA929940	25095	210	1.109827	2.3306367	Palaemon carinicauda	392227	Arthropoda	Arthropoda	52.8	0.018	NTclustered	gi\|2804991525\|ref\|XM_068358978.1\|	392227	g24860	i0	100	0.266666666666667	28	0	13	0	62	89	3008	3035	PREDICTED: Palaemon carinicauda Schwannomin interacting protein 1 (Schip1), transcript variant X1, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Palaemon	Palaemon carinicauda

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