metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax

7 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax_phylum = "Nematoda"

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
8983	8983	PRJDB3785_S_NODE_7261_length_279_cov_0.913043_g7108_i0	PRJDB3785	7261	279	0.913043	2.54738997	Strongyloides papillosus	174720	Nematoda	Nematoda	60.2	1.54e-4	NTclustered	gi\|687022703\|emb\|LM525617.1\|	174720	g7108	i0	97.143	0.125448028673835	35	1	13	0	208	242	59720	59754	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000027	blastn	35	60.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
8990	8990	PRJDB3785_S_NODE_7641_length_271_cov_8.054054_g7488_i0	PRJDB3785	7641	271	8.054054	21.82648634	Caenorhabditis remanei	31234	Nematoda	Nematoda	78.7	4.1e-10	NTclustered	gi\|2445352248\|ref\|XM_053723719.1\|	31234	g7488	i0	94.118	0.660516605166052	51	3	19	0	184	234	282	232	Caenorhabditis remanei uncharacterized protein (GCK72_002963), partial mRNA	blastn	179	78.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
2558812	2558812	PRJDB3785_S_NODE_6223_length_302_cov_2.249012_g6070_i0	PRJDB3785	6223	302	2.249012	6.79201624	Caenorhabditis elegans	6239	Nematoda	Nematoda	263	1.19e-65	NTclustered	gi\|1972305872\|ref\|NM_076440.8\|	6239	g6070	i0	84.444	89.8476821192053	270	38	89	4	31	298	1173	906	Caenorhabditis elegans Actin-4 (act-4), mRNA	blastn	27134	263	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10211566	10211566	PRJDB3785_S_NODE_11529_length_224_cov_2.257143_g11376_i0	PRJDB3785	11529	224	2.257143	5.05600032	Caenorhabditis briggsae	6238	Nematoda	Nematoda	102	1.95e-17	NTclustered	gi\|268579136\|ref\|XM_002644505.1\|	6238	g11376	i0	80.137	24.28125	146	21	63	7	12	153	199	58	Caenorhabditis briggsae Protein CBR-PDI-2 (Cbr-pdi-2), partial mRNA	blastn	5439	102	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
12762496	12762496	PRJDB3785_S_NODE_6591_length_293_cov_1.553279_g6438_i0	PRJDB3785	6591	293	1.553279	4.55110747	Strongyloides ratti	34506	Nematoda	Nematoda	281	3.18e-71	NTclustered	gi\|1376146183\|ref\|XM_024653652.1\|	34506	g6438	i0	86.853	51.9658703071672	251	33	86	0	3	253	985	1235	Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA	blastn	15226	281	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
20409288	20409288	PRJDB3785_S_NODE_10577_length_233_cov_1.114130_g10424_i0	PRJDB3785	10577	233	1.11413	2.5959229	Strongyloides papillosus	174720	Nematoda	Nematoda	204	5.439999999999999e-48	NTclustered	gi\|687022644\|emb\|LM525558.1\|	174720	g10424	i0	89.441	107.901287553648	161	17	69	0	73	233	390501	390661	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004	blastn	25141	204	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
22960913	22960913	PRJDB3785_S_NODE_8079_length_264_cov_2.948837_g7926_i0	PRJDB3785	8079	264	2.948837	7.78492968	Sudhausia aristotokia	1357959	Nematoda	Nematoda	174	4.93e-39	NTclustered	gi\|525330271\|gb\|KC831557.1\|	1357959	g7926	i0	78.868	2.3030303030303	265	50	99	6	1	262	631	370	Sudhausia aristotokia large subunit ribosomal protein 2 (rpl-2) gene, partial cds	blastn	608	174	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Sudhausia	Sudhausia aristotokia

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