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

5 rows where analysis = "blastn", bioproject = "PRJNA1073005" and tax_phylum = "Chordata"

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
5289774	5289774	PRJNA1073005_P_NODE_8405_length_269_cov_1.306122_g8286_i0	PRJNA1073005	8405	269	1.306122	3.51346818	Lethenteron reissneri	7753	Chordata	Chordata	139	1.84e-28	NTclustered	gi\|2635898345\|ref\|XM_061573063.1\|	7753	g8286	i0	78.07	16.0260223048327	228	44	84	6	29	253	137	361	PREDICTED: Lethenteron reissneri ferritin heavy chain B-like (LOC133355748), mRNA	blastn	4311	139	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
6564940	6564940	PRJNA1073005_P_NODE_4106_length_494_cov_3.149644_g3987_i0	PRJNA1073005	4106	494	3.149644	15.55924136	Microhyla fissipes	387934	Chordata	Chordata	71.3	1.33e-7	NTclustered	gi\|1698360607\|dbj\|LC465677.1\|	387934	g3987	i0	87.302	12.7651821862348	63	6	13	2	102	163	1480	1419	Microhyla fissipes KUHE:32942 mitochondrial genes for 12S rRNA, tRNA-Val, 16S rRNA, partial and complete sequence	blastn	6306	71.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Microhylidae	Microhyla	Microhyla fissipes
9114588	9114588	PRJNA1073005_P_NODE_7108_length_318_cov_1.257143_g6989_i0	PRJNA1073005	7108	318	1.257143	3.99771474	Sphaerodactylus townsendi	933632	Chordata	Chordata	52.8	0.03	NTclustered	gi\|2247582609\|ref\|XR_007243838.1\|	933632	g6989	i0	100	0.352201257861635	28	0	9	0	242	269	2678	2705	PREDICTED: Sphaerodactylus townsendi uncharacterized LOC125428457 (LOC125428457), transcript variant X1, ncRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Sphaerodactylidae	Sphaerodactylus	Sphaerodactylus townsendi
15489620	15489620	PRJNA1073005_P_NODE_8333_length_271_cov_1.671717_g8214_i0	PRJNA1073005	8333	271	1.671717	4.53035307	Tupaia chinensis	246437	Chordata	Chordata	220	6.44e-53	NTclustered	gi\|1561687040\|ref\|XM_006166226.3\|	246437	g8214	i0	83.544	86.6494464944649	237	37	87	2	1	236	381	146	PREDICTED: Tupaia chinensis Rac family small GTPase 2 (RAC2), transcript variant X2, mRNA	blastn	23482	220	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Scandentia	Tupaiidae	Tupaia	Tupaia chinensis
16763901	16763901	PRJNA1073005_P_NODE_7974_length_284_cov_1.208531_g7855_i0	PRJNA1073005	7974	284	1.208531	3.43222804	Mus musculus	10090	Chordata	Chordata	520	5.98e-143	NTclustered	gi\|14318724\|gb\|BC009155.1\|	10090	g7855	i0	99.648	97.5140845070423	284	1	100	0	1	284	21	304	Mus musculus microsomal glutathione S-transferase 1, mRNA (cDNA clone MGC:6549 IMAGE:2655738), complete cds	blastn	27694	520	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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