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

9 rows where analysis = "blastn", bioproject = "PRJNA800090" 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
797122	797122	PRJNA800090_P_NODE_13681_length_1096_cov_3.142162_g12268_i0	PRJNA800090	13681	1096	3.142162	34.43809552	Strongyloides ratti	34506	Nematoda	Nematoda	560	1.4999999999999995e-154	NTclustered	gi\|1376146183\|ref\|XM_024653652.1\|	34506	g12268	i0	79.775	46.2363138686131	801	139	72	21	288	1075	386	1176	Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA	blastn	50675	560	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
3348746	3348746	PRJNA800090_P_NODE_163723_length_243_cov_1.678161_g161538_i0	PRJNA800090	163723	243	1.678161	4.07793123	Pristionchus lheritieri	70414	Nematoda	Nematoda	135	2.11e-27	NTclustered	gi\|150984655\|gb\|EF634989.1\|	70414	g161538	i0	80.108	6.82304526748971	186	34	75	2	29	211	10	195	Pristionchus lheritieri small subunit ribosomal protein 28 (rps-28) mRNA, complete cds	blastn	1658	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus lheritieri
8450994	8450994	PRJNA800090_P_NODE_172787_length_236_cov_0.874251_g170602_i0	PRJNA800090	172787	236	0.874251	2.06323236	Strongyloides ratti	34506	Nematoda	Nematoda	126	1.23e-24	NTclustered	gi\|1376149723\|ref\|XM_024643204.1\|	34506	g170602	i0	82.192	0.61864406779661	146	26	62	0	60	205	2252	2107	Strongyloides ratti Methionine synthase (SRAE_2000434600), partial mRNA	blastn	146	126	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
9725017	9725017	PRJNA800090_P_NODE_127868_length_281_cov_1.099057_g125683_i0	PRJNA800090	127868	281	1.099057	3.08835017	Ditylenchus destructor	166010	Nematoda	Nematoda	333	8.259999999999999e-87	NTclustered	gi\|254679589\|gb\|GQ327968.1\|	166010	g125683	i0	88.686	97.3167259786477	274	29	97	2	1	273	870	598	Ditylenchus destructor actin 1 mRNA, complete cds	blastn	27346	333	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
16100465	16100465	PRJNA800090_P_NODE_171333_length_237_cov_0.869048_g169148_i0	PRJNA800090	171333	237	0.869048	2.05964376	Caenorhabditis elegans	6239	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|1734332862\|ref\|NM_001313287.2\|	6239	g169148	i0	90.476	1.24050632911392	42	4	18	0	34	75	154	195	Caenorhabditis elegans Cullin neddylation domain-containing protein (cul-3), partial mRNA	blastn	294	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19924218	19924218	PRJNA800090_P_NODE_149936_length_256_cov_1.540107_g147751_i0	PRJNA800090	149936	256	1.540107	3.94267392	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.023	NTclustered	gi\|351063524\|emb\|FO081456.1\|	6239	g147751	i0	100	0.21875	28	0	11	0	81	108	10591	10618	Caenorhabditis elegans Cosmid F56C11, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19926731	19926731	PRJNA800090_P_NODE_82836_length_366_cov_1.818182_g80651_i0	PRJNA800090	82836	366	1.818182	6.65454612	Meloidogyne incognita	6306	Nematoda	Nematoda	60.2	2.08e-4	NTclustered	gi\|33329239\|gb\|AF531165.1\|	6306	g80651	i0	88.462	0.14207650273224	52	3	13	3	52	100	668	617	Meloidogyne incognita putative esophageal gland cell secretory protein 6 (msp6) mRNA, complete cds	blastn	52	60.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne incognita
22475811	22475811	PRJNA800090_P_NODE_27578_length_741_cov_2.010417_g25551_i0	PRJNA800090	27578	741	2.010417	14.89718997	Strongyloides ratti	34506	Nematoda	Nematoda	488	4.769999999999999e-133	NTclustered	gi\|1376154049\|ref\|XM_024646386.1\|	34506	g25551	i0	78.976	53.7503373819163	742	136	99	18	3	736	173	902	Strongyloides ratti V-type proton ATPase subunit B, kidney (SRAE_X000121000), partial mRNA	blastn	39829	488	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
25024360	25024360	PRJNA800090_P_NODE_164660_length_242_cov_2.208092_g162475_i0	PRJNA800090	164660	242	2.208092	5.34358264	Caenorhabditis briggsae	6238	Nematoda	Nematoda	250	7.2e-62	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g162475	i0	87.5	81.0371900826446	216	27	89	0	8	223	270	55	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	19611	250	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae

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