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

5 rows where analysis = "blastn", bioproject = "PRJNA1046144" and tax_kingdom = "Orthornavirae"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4837299	4837299	PRJNA1046144_P_NODE_4_length_6415_cov_243.468327_g3_i0	PRJNA1046144	4	6415	243.468327	15618.49317705	root	1	Root_unresolved	Root_unresolved	11566	0	NTclustered	gi\|388240129\|emb\|HE818411.1\|	12242	g3	i0	99.559	99.8254091971941	6347	28	100	0	69	6415	6386	40	Tobacco mosaic virus isolate Changle-9, complete genome	blastn	640380	11566	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
6550734	6550734	PRJNA1046144_P_NODE_59686_length_233_cov_0.878049_g59391_i0	PRJNA1046144	59686	233	0.878049	2.04585417	Betacoronavirus pandemicum	3418604	Viruses	Viruses	425	1.07e-114	NTclustered	gi\|2161743781\|gb\|OL761638.1\|	2697049	g59391	i0	99.571	100	233	1	100	0	1	233	28707	28939	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/AZ-CDC-ASC210483568/2021, complete genome	blastn	23300	425	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
15475349	15475349	PRJNA1046144_P_NODE_52193_length_243_cov_1.367816_g51898_i0	PRJNA1046144	52193	243	1.367816	3.32379288	Chronazanb virus	3129852	Viruses	Viruses	141	4.54e-29	NTclustered	gi\|2717318485\|gb\|PP172249.1\|	3129852	g51898	i0	95.455	6.57201646090535	88	4	36	0	147	234	4398	4485	MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence	blastn	1597	141	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazanb virus
18024007	18024007	PRJNA1046144_P_NODE_355_length_2008_cov_3.012378_g328_i0	PRJNA1046144	355	2008	3.012378	60.48855024	Iflavirus sp.	1916690	Viruses	Viruses	1147	0	NTclustered	gi\|2895513769\|tpg\|BK068505.1\|	1916690	g328	i0	79.462	23.7001992031872	1636	322	81	12	319	1947	10102	11730	TPA_asm: Iflavirus sp. isolate WUR34 polyprotein gene, complete cds	blastn	47590	1147	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus sp.
22686215	22686215	PRJNA1046144_P_NODE_60218_length_232_cov_0.883436_g59923_i0	PRJNA1046144	60218	232	0.883436	2.04957152	Paramyxoviridae	11158	Viruses	Viruses	429	8.2e-116	NTclustered	gi\|2721617856\|gb\|PP711545.1\|	251774	g59923	i0	100	68.8189655172414	232	0	100	0	1	232	2855	3086	Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome	blastn	15966	429	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Rubulavirus	Porcine parainfluenza virus

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