metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax_phylum = "Rotifera"

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
12398276	12398276	PRJNA940501_S_NODE_206070_length_191_cov_1.486486_g205252_i0	PRJNA940501	206070	191	1.486486	2.83918826	Philodina megalotrocha	1234259	Rotifera	other_Eukaryota	311	2.45e-80	NTclustered	gi\|2537903911\|gb\|JX494729.2\|	1234259	g205252	i0	100	87.9581151832461	168	0	88	0	24	191	1361	1528	Philodina megalotrocha isolate A751 18S ribosomal RNA gene, partial sequence	blastn	16800	311	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina megalotrocha
14011604	14011604	PRJNA940501_S_NODE_206131_length_191_cov_1.445946_g205313_i0	PRJNA940501	206131	191	1.445946	2.76175686	Adinetidae	104780	Rotifera	other_Eukaryota	353	4.02e-93	NTclustered	gi\|2537903787\|gb\|KM043252.2\|	104782	g205313	i0	100	100	191	0	100	0	1	191	908	718	Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence	blastn	19100	353	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
17835725	17835725	PRJNA940501_S_NODE_397594_length_150_cov_1.317757_g396776_i0	PRJNA940501	397594	150	1.317757	1.9766355	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	261	1.86e-65	NTclustered	gi\|1173728640\|gb\|KY886363.1\|	10195	g396776	i0	98	100.02	150	3	100	0	1	150	1471	1620	Brachionus plicatilis isolate AP1 small subunit ribosomal RNA gene, partial sequence	blastn	15003	261	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
18774074	18774074	PRJNA940501_S_NODE_97815_length_239_cov_2.382653_g96997_i0	PRJNA940501	97815	239	2.382653	5.69454067	Adineta vaga complex sp. A JFF-2016	1813164	Rotifera	other_Eukaryota	390	4.0099999999999996e-104	NTclustered	gi\|1005055512\|gb\|KU860655.1\|	1813164	g96997	i0	98.636	52.6359832635983	220	3	92	0	20	239	1863	2082	Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence	blastn	12580	390	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. A JFF-2016
21660562	21660562	PRJNA940501_S_NODE_43897_length_294_cov_2.585657_g43079_i0	PRJNA940501	43897	294	2.585657	7.60183158	Eurotatoria	2816136	Rotifera	other_Eukaryota	425	1.39e-114	NTclustered	gi\|72153762\|gb\|DQ089743.1\|	231624	g43079	i0	95.185	42.8809523809524	270	12	91	1	1	269	2158	1889	Rotaria rotatoria 28S ribosomal RNA gene, partial sequence	blastn	12607	425	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria

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